Interactive Power BI dashboard analysing sales performance, customer demographics, and product profitability using the AdventureWorks dataset.
This repository contains an interactive Power BI dashboard built using the AdventureWorks dataset.
The dashboard analyses sales performance, customer demographics, and product profitability to deliver actionable business insights for decision-makers.
The project focuses on transforming raw transactional data into clear, decision-ready intelligence through effective data modelling, visualisation, and storytelling.
- Which regions generate the highest Total Revenue and Profit?
- How do sales and profit trends change over time?
- Which customer segments (e.g. high-income, repeat customers) drive the most value?
- Which products contribute most to profitability, not just sales volume?
- Where do pricing, discounting, or product-mix risks exist?
- Revenue and profit are highly concentrated in a small number of regions.
- Clear seasonality patterns exist in monthly and yearly sales trends.
- High sales volume does not always translate into high profit, indicating margin pressure.
- Discounted sales increase revenue but can negatively impact profitability.
- High-income customers contribute disproportionately to total revenue.
- Middle-aged customers show the highest purchasing activity.
- Repeat customers drive a significant share of total sales.
- Regions with the highest customer counts also generate the highest revenue.
- A small subset of products drives the majority of sales (Pareto effect).
- Some high-volume products deliver low profit margins.
- Several lower-volume products generate strong profitability.
- Persistently underperforming products indicate portfolio optimisation opportunities.
- Power BI Desktop
- Data modelling and relationships
- DAX measures for KPIs and aggregations
- Interactive slicers, drill-downs, and tooltips