Business Problem:
You’ve just been hired as the Lead Business Intelligence Analyst for Maven Toys, a small toy store chain in the US. As one of your first tasks, the COO has asked you to prepare a new monthly dashboard for the company’s Regional Sales Managers.
Business Needs:
- Required a dashboard that can be used by the COO and all the regional sales managers.
- Users should be able to filter by Region.
- It should allow them to track monthly revenue trends.
- Should be able to see performance year-over-year.
- Make it easy to compare performance across stores.
- Identify and showcase products that drove the biggest gains and losses.
Approach:
- Defined the purpose of the dashboard
- Chose the key metrics & interactivity
- Planned ahead for growing source data
- Prepared the data for visualization
- Created primary & supporting visuals
- Designed the final dashboard layout