top of page

Customer analytics dashboard

This single-page Power BI report provides a consolidated view of bike-customer performance, combining geography, demographics and purchasing behaviour on one canvas.

  • A vertical slicer pane Country, Gender, Age, Income Level—drives every visual on the page, enabling rapid segmentation without navigation to other views.

  • KPI cards across the top surface headline metrics: total revenue, bicycle buyers and customer count.

  • The central map shades countries by revenue, immediately showing market concentration.

  • A clustered column chart to the right breaks down customer counts by country and gender, revealing gender mix in key markets.

  • Supporting visuals complete the picture:

    • Monthly revenue trend (line chart) captures seasonality.

    • Bubble plot relates average ticket size to income tiers, highlighting spending power across segments.

    • Pie chart profiles customers by occupation, signalling workforce categories with highest engagement.

The report is powered by a star schema: a sales fact table linked one-to-many to dimensions for Country, Gender, Age Band, Income Level and Occupation. Measures are written in DAX, ensuring filter context from slicers flows cleanly through all visuals and the dashboard updates instantly.

bottom of page