Excel Sales Data Dashboard

I have a raw sales dataset that needs to be transformed into an insightful, presentation-ready Excel workbook. The first step will be a full data scrub—removing duplicates, handling any missing values, and standardising date and currency formats—so every calculation and visual is reliable.

Once the data is pristine, I’ll need you to build the analytical layer: clear formulas and well-structured PivotTables that summarise total sales by product, reveal sales trends over time, and compare performance across regions. From those pivots, create bar, line, and pie charts that quickly communicate the story behind the numbers.

The final piece is an interactive dashboard where stakeholders can filter by product or region and instantly see the updated visuals. Please keep navigation intuitive and label everything plainly so even non-technical colleagues can explore the data with confidence.

Deliverables
• Cleaned dataset with all transformations documented in a separate sheet
• Dynamic PivotTables underpinning each metric (product, time, region)
• Bar, line, and pie charts linked to the pivots
• Interactive dashboard on a dedicated tab with slicers/controls for easy filtering
• A single, well-organised .xlsx file ready for immediate distribution

I’ll consider the project complete once every figure ties back to the source data and the workbook opens without errors or broken links.