Project Description
I need an interactive Excel dashboard that lets me analyse three core KPIs—sales performance, customer satisfaction and employee productivity—in a single, easy-to-read view. The workbook should focus on data analysis rather than static reporting, so everything has to update automatically when new data is pasted into the model.
My preferred visual format is clear, well-labelled charts (bar, line or combo where appropriate). Tables can sit behind the scenes for calculations, but the front end must stay chart-centric and visually balanced. Slicers or drop-downs for date ranges, regions or product lines will help me drill into the numbers quickly, so please add them where you think they add value.
Deliverables
• One Excel (.xlsx) file containing:
– Dynamic data model with any needed formulas or pivot tables
– Chart-based dashboard page highlighting the three KPIs
– Simple instructions (in-sheet notes) on how to refresh or extend the data
The file should run smoothly in the latest desktop version of Excel without external add-ins. If you need sample data to build against, just let me know and I will provide it.