Project Overview
A full Power BI analytics project built on the classic Northwind Traders dataset — a fictitious food import/export company — demonstrating end-to-end BI development from raw relational data to polished executive dashboards.
Technical Build
- Data Model: Recreated the Northwind relational schema in Power BI — Orders, Order Details, Products, Customers, Employees, Shippers, and Suppliers
- Power Query: Loaded and transformed multiple related tables, enforced correct data types, created a proper date dimension table
- DAX: Revenue, Profit Margin, Orders per Customer, Employee Sales Rank, Freight Cost analysis, and time intelligence measures
- Design: Dashboard layout prototyped in Figma first for clean UX, then built in Power BI with consistent color language and clear hierarchy
Key Insights
- Top 20% of customers generate 65% of revenue — clear Pareto dynamic
- Q4 consistently peaks due to holiday ordering patterns
- Freight costs vary significantly by shipper — potential cost reduction opportunity