This project delivers a single-page Power BI dashboard built on a star-schema model (one sales fact table linked to six descriptive dimensions). The report is fully slice-driven: changing Year, Country, or any demographic filter (Education, Occupation, Gender, Marital Status, Income) redraws every visual in place, allowing users to pivot seamlessly between time periods, markets, and customer segments.

​

The three screenshots illustrate typical states produced by these slicers:

​

• Annual focus – selecting an individual year narrows KPIs and charts to that period and highlights the dominant region on the map.

• Aggregate view – clearing the Year slicer reveals multi-year performance and exposes differences in average order value across countries.

• Country drill-down – combining a specific year with a single country centres the map, recalculates all metrics, and spotlights that market’s adoption rate.

​

All calculations are handled with DAX measures against the star schema, ensuring filters propagate cleanly and visuals respond instantly. The result is a concise, executive-level report that supports quick assessments of revenue distribution, ticket size, and bike-purchase penetration without the need for multiple pages or complex navigation.