Interactive Excel Sales Dashboard

The project is an end-to-end build of an interactive Excel dashboard that pulls sales data into Power Pivot, models it with DAX measures, and surfaces the results through PivotTables, charts, and slicers. Core visual components • Charts – bar, pie, and line views will highlight revenue, profit, order count, and quantity trends. • PivotTables – serve as the analytical backbone, letting users drill from region down to individual salesperson. • Slicers – pre-defined filters (region, category, product, time period, and salesperson) must seamlessly control every visual for quick cross-section analysis. Data model & logic Sales tables will be loaded into the Data Model, related on dates, geography, product hierarchy, and customer dimensions. Key DAX measures will include Total Sales, Total Profit, Order Count, Quantity, YoY %, and Profit Margin. All calculations need to respond instantly to slicer changes. User experience The workbook opens on a summary dashboard with high-level KPIs across the top, followed by interactive visuals. Secondary sheets can host detailed PivotTables for deeper exploration while remaining connected to the same slicers. The layout should stay clean, printable on A4, and run smoothly in desktop Excel 2016+ without add-ins. Deliverable • Excel file (.xlsx) containing the complete Data Model, measures, visuals, and formatted slicers, ready for immediate use. Acceptance 1. Slicer selections instantly refresh every chart and PivotTable. 2. All measures return accurate results when spot-checked against raw data. 3. No external links or refresh errors appear on file open.