Here is a list of questions that you will be answering for this case. Complete instructions for how to
construct the interactive Excel dashboard are in tutorial videos for this project. Please read this student
case handout in its entirety before starting the case. Use the data dictionary provided on page 1 of these
instructions and the interactive Excel dashboard file to answer the following questions:
1. What is the trend of sales for the Consumer Products market?
2.
What is the trend of sales for the Medical category?
3.
For 2021, how much were sales in the customer location of Italy?
4. For 2021, how much were sales in the division of Germany?
5. What is the top product line in the Electronics market?
6. What is the top product line in the division of India?
7.
How could this dashboard help the company in its decision-making? What overall strategy
questions could this dashboard address?
Note: For questions that reference sales for a specified market or category by year and quarter, you will
need to hover over the data points in the sales trend charts to see the sales dollar amount.
Fig: 1