Discussion
YenRose99
CarlsCookies-StudentTemplatewithguidance.pptxCarl’s Cookies
Business Data Analytics - Touchstone 1
Name Here
Date Here
1
What cookies sold Best?
Visualization: Present a chart or table summarizing cookie sales data. Hint: Use a visualization that helps compare the sales performance of different cookie varieties over time or across categories.
Key insights: Identify patterns in cookie sales and customer feedback. Consider whether Carl should continue, improve, or discontinue specific cookie varieties.
Speaker Notes: Explain how the data informed your insights. Justify your recommendations based on trends and feedback provided.
2
Most effective Marketing by total gross sales and average gross sales
Visualization: Present data comparing the impact of different marketing strategies on sales and costs. Hint: Choose a visualization that highlights which marketing methods yield the highest returns or have the lowest costs.
Key insights: Identify which marketing method yields the best return on investment.
Speaker Notes: Describe how you evaluated marketing effectiveness. Provide a recommendation for Carl’s future marketing strategy.
3
Trends in Net Income Including Scenarios
Visualization: Present income trends based on different potential changes (e.g., price increase, cost changes). Show how these changes affect Carl’s weekly net income. Hint: Use a visual format that clearly compares multiple scenarios side by side.
Speaker Notes: Discuss how you approached analyzing income trends. Explain how each scenario impacts overall profitability.
4
Excel Calculation for Question #3
Include relevant calculations or data analysis steps used to determine income trends.
Speaker Notes: Provide an overview of your calculations and how they support your findings.
5
Distribution of average weekly customer spending
Visualization: Display data that illustrates customer spending behavior across different segments. Hint: Consider a visual that categorizes customers into different spending levels and shows the proportion of each group.
Key insights: Identify key customer segments and potential opportunities for upselling.
Speaker Notes: Explain how you segmented customers based on their spending. Justify your recommendations for targeting each segment.
6
Geometric Mean and Gross Sales by Quarter
Visualization: Use a chart to display quarterly sales growth trends. Hint: Focus on a visual that highlights growth patterns and any deviations from Carl’s goals.
Key insights: Determine whether Carl is meeting his quarterly growth goals.
Speaker Notes: Discuss how you analyzed the sales trends. Provide actionable recommendations for improving sales performance.
7
Effect of discounts on weekly Average Satisfaction Ratings
Visualization: Display data showing the relationship between discounts and customer satisfaction. Hint: Choose a visual that shows whether higher discounts correlate with increased satisfaction.
Key insights: Evaluate whether offering discounts is beneficial for Carl’s business.
Speaker Notes: Explain how you evaluated the impact of discounts on customer satisfaction. Provide a recommendation on whether Carl should continue offering discounts.
8
Excel Calculations for Question 6
Include relevant calculations or data analysis steps used to evaluate the discount program.
Speaker Notes: Describe how your calculations support your recommendation.
9
Chi-Square Test of Association
Analysis: Present findings that help Carl predict ingredient needs based on seasonal or quarterly trends. Hint: Use a format that helps identify patterns in cookie sales across different quarters.
Key insights: Suggest how Carl can improve his ordering process to reduce waste and ensure availability.
Speaker Notes: Explain how you analyzed the data to identify ordering patterns. Provide recommendations for improving ingredient management.
10
Summary
Key Points: Summarize your main findings and final recommendations across all questions.
Actionable Steps: Provide a clear list of actions Carl should take to optimize his operations.
Speaker Notes: Recap the most important takeaways from your analysis. Emphasize how your recommendations will help Carl achieve his goals.
11
