Overview
Designed a Star Schema data warehouse using the Northwind Dataset to enable scalable sales reporting across multiple dimensions — Time, Product, and Customer. This project demonstrates end-to-end BI development from data modelling to dashboard delivery.
Built a star schema with a central fact table (sales transactions) surrounded by dimension tables for Time, Product, Customer, and Region. This structure enables fast aggregation queries and flexible slicing across any dimension combination.
- Analyzed over 51,000 transaction records to surface key business insights:
- Top-performing product identified, contributing $149K+ in total revenue
- April confirmed as the peak revenue month, informing seasonal inventory planning
- Regional and product-level breakdowns enabled cross-dimensional performance comparison
- Built an interactive Power BI dashboard featuring:
- Revenue trend line chart by month (seasonal analysis)
- Product performance bar chart (top 10 by revenue)
- Customer segmentation by order frequency
- Dynamic slicers for time period, region, and product category
- Star schema modelling across 3 dimensions (Time, Product, Customer)
- 51,000+ transaction records processed
- $149K+ top-product revenue identified
- Seasonal inventory planning insight delivered
- Interactive Power BI dashboard with 4 report pages