Project Overview
A Power BI dashboard analyzing chocolate product sales data — tracking performance by product line, region, salesperson, and time period.
Technical Build
- Source Data: Excel workbook with raw sales transactions, product catalog, and salesperson mapping
- Power Query: Cleaned and shaped data — unpivoted monthly columns, merged product and sales tables, standardized region names
- Data Model: Fact table (sales) connected to product, salesperson, date, and geography dimensions
- DAX: Total Revenue, Units Sold, Average Order Value, % of Total by Category, and period-over-period comparisons
Dashboard Features
- Sales performance by salesperson with ranking and target vs actual
- Top and bottom performing chocolate products by revenue
- Geographic revenue map and regional drill-through
- Monthly trend with year-over-year comparison