Your organization is striving to increase the quantity and profitability of orders. In addition, the organization wants to gain insights into how they can better predict future business growth.
Your task is to analyze the data from the Orders_Northwind.csv dataset (orders_northwind_mod8). You are provided links to the dataset and to a document describing the variables in the dataset (MIS543_PortfolioProject_Variables_list_clothing_store)
Your analysis should include the necessary descriptive analytics tests to communicate your understanding of what story the data is telling us. Also, your analysis should include the necessary predictive analytics tests to assist decision makers in achieving their business goals.
Deliverables for this assignment are:
• Description of the business problem including the organization’s strategic goals
I already wrote the business problem, but please feel free to add to it.
The Retail Clothing Store is on a mission and determined to increase the quantity of sales and the overall productivity of sales by analyzing and finding insights in predictive analysis. In analyzing the Orders_Northwind_Mod8.csv dataset, appropriate descriptive analysis shall be conducted expressing and interpreting the comprehension of the data to aid in decision-making confidence.
• List, at a minimum, 4 business questions. Justify how these business questions will solve the organization’s business problem and achieve their strategic goals. I already wrote the business questions
- In which territory are sales highest?
The business question, in which territory are sales highest, will answer which territory is purchasing the most product. Further analysis can discover which product and why to improve upon sales. - Which products are sold most?
The business question, which products are purchased most, will answer the business question as to the products most purchased. Further analysis can discover territory is purchasing the most product. Further analysis can discover which product brings in the most sales. - Which customers have the most purchases?
The business question, which customers have the most purchases, answers are purchased most, will answer the business question as to the products most purchased. Further analysis can discover which territory is purchasing the most. - What product is discounted the most?
The business question, what product is discounted the most, will answer the business question as to the product that is most discounted and why. Further analysis can discover why that specific product gets discounted more than others.
• List the null hypotheses (H0) and alternative hypotheses for each business question - H0 - Territory 27511 has the highest in sales.
Ha - Territory 27511 does not have the highest in sales. - H0 - Product 59 is sold most in category 4.
Ha - Product 59 is not sold most in category 4. - H0 - Customer ID RISCU has the highest sales in category 4.
Ha - Customer ID RISCU does not have the highest sales in category 4. - H0 - Product 30 offers the highest discounts in category 8.
Ha - Product 30 does not offer the highest discounts in category 8.
• List the statistical tests you intend to use and why
• List the visualizations you intend to use and why
• Descriptive statistics to include charts, graphs, and tables and analysis of your findings
• Predictive statistics to include charts, graphs, and tables, and analysis of your findings
• Analysis of findings with respect to business questions and hypotheses
• Recommendations for further analysis: what other data sources, including big data sources, could the organization utilize to help them achieve their business goals.
Sample Solution