Data: From the “Advanced Excel Dashboard Design for Business Intelligence” Udemy course.
Scenario: “Could you build a dashboard that we can use to filter by region, track
monthly revenue trends, and see performance year over year? I’d also like to compare performance across stores, and identify which specific products drove the biggest gains and losses.”
Dimensions and Measures:
Dimensions: Year, Month, Store Name/Region/Type, Product Name/Category
Measures: Units Sold, Revenue, Profit
