Which products should be prioritised for increase in sales

Assignment Help Management Information Sys

Reference no: EM131983510

Case Study

You are working as a Data Scientist in an ecommerce company. The company is a market leader with range of product segments. The main product segments are latest gadgets, books, toys, household items and clothes.

However, the company's performance especially its profitability is decreasing due to increased competition and changing customer expectations.

The company has well qualified board of directors who believe in the power of data analytics in solving business problems and thus make important business decisions.

Due to your
data analytics skills and data science capability, the company executives have given you a special task in analysing the company's sales data for each product segment and each geographic region.

The executives have requested you the following:

1. Develop the dataset for few product segment with at least 1000 records and with attributes such as

• product name,

• product price,

• shipping type (free or customer paid)

• monthly sales ($)

• geographic region

• No. Of customers who bought the product,

• Customer type (New or existing)

You are also allowed to add any more attributes to describe product segment

Note: You must develop your own unique and original dataset - copying a dataset from another student or from the internet will result in reduced or zero marks. [PYTHON code required]

2. Research any specific data mining or classification technique and propose a suitable technique or model to determine any association or relationships among the attributes.

3. Develop a predictive model to predict monthly sales for a given geographic region. You can use any of the methods such as Naive Bayes, decision trees or linear regression.

You are also welcome to do a comparative analysis of all the methods you come across in your research and use the comparative analysis to justify your approach and research findings.

4. Based on your analysis, present recommendations to the board for the following business problems:

• What is the most likely geographic region to target new customers to increase sales and profit?

• Which products should be prioritised for increase in sales?

• What will be impact on product sales if free shipping is provided to all products?

• Any new innovative ideas to improve company's profitability supported by your data analytics.

Proposed Report Structure

The report should be structured using the following headings (2000 words)

1. Executive Summary

2. Table of Contents

3. List of Abbreviations and assumptions made

4. Introduction - What is the problem?

5. Research Methodology

6. Analytical Findings

7. Recommendations to the company

8. An implementation plan based on the recommendations you have provided

9. Conclusions

10. List of References

11. Appendix (E.g. Python code)

Note:

• You must submit your sample data as a CSV file.

• Use Python code to analyse their data and draw graphs, and you must include all that code in the Appendix and separate ‘ipynb' should also be submitted in the link provided.

Reference no: EM131983510

Questions Cloud

What is the sticker price of the new car you can buy : What is the sticker price of the new car you can buy after graduation, if you have budgeted $350 per month for payments, and you are offered 3% APR.

Describe the position of closing cash throughout the year : FNSACC503 Manage Budget and Forecasts - Describe the position of closing cash throughout the year. The owner realises that there will be significant expenses

How much net income should be distributed to queen : Dane and Queen had $50,000 and $171,000, respectively, in their January 1 capital balances. How much net income should be distributed to Queen?

What is the contribution margin per unit for each chocolate : Steve Smith is ready to complete cost-volume-profit analysis. What is contribution margin per unit for each chocolate bar produced given the fact pattern above?

Which products should be prioritised for increase in sales : The company's performance especially its profitability is decreasing due to increased competition and changing customer expectations.

Great culture and internal employee : If a company has a great culture and internal employee relationship, the PR will come eventually and customers will return.

Develop the journal entries that should be recorded : To stimulate the sales of its Alladin breakfast cereal. Develop the journal entries that should be recorded in 2018 relative to the premium plan.

Largest retailer in its industry : A perfect example of a company that prioritizes its employees, which in turns benefits the customers is Costco. Even though Costco is not the largest retailer

Compute the cost of goods destroyed : Compute the cost of goods destroyed. Compute the cost of goods destroyed, assuming that the gross profit is 33 1/z% of sales.

User Account

All Pages