Excel Sales Dashboard & Cleanup

I’m working with a single workbook that captures two years of sales activity. While most of the data is usable, I still run into the odd duplicate, a handful of blanks, and the occasional product or customer name that’s been typed two different ways. Once those issues are fixed, I want to see everything come to life in an easy-to-refresh dashboard. The dashboard must give me a clear view of: • Sales by product, customer, and region • Sales targets lined up against the actual figures so gaps jump off the page Feel free to lean on Power Query for the cleanup, PivotTables and slicers for drill-downs, and standard Excel charts or conditional formatting for appealing visuals—whatever combination keeps refreshes quick and the file size reasonable. I’ll provide the current workbook plus a short data key. I expect back: 1. A cleaned dataset (no duplicates, consistent names, missing values handled) 2. The interactive dashboard on its own sheet 3. A quick set of refresh instructions so I can keep everything up to date on my own Fast turnaround and a concise overview of your approach will help me choose the right person.