Excel Operational Data Dashboard Suite

I need an end-to-end Excel solution that turns my raw operational data into clear, action-oriented insights. The workbook should import or paste data easily, clean it behind the scenes, then surface the story through a mix of charts, pivot tables, and an interactive dashboard.

Here’s what I expect to receive:
• A structured data model ready for refresh without breaking formulas or links
• Dynamic pivot tables that let me slice performance by date, department, and any additional fields you spot as valuable
• Visually consistent charts and graphs that highlight trends, outliers, and KPI progress
• A dashboard page with slicers, drop-downs, or buttons so non-technical users can explore the numbers themselves
• Clear documentation of any VBA, Power Query steps, or named ranges you add, so future edits are straightforward

Acceptance criteria
• Workbook opens with no errors or security warnings
• All visuals update correctly when new rows are appended and the model is refreshed
• No hard-coded paths—everything works on any Windows machine running the latest Microsoft 365 Excel build

If you have sample dashboards or templates that show your style, feel free to reference them so I can confirm we’re on the same wavelength before you begin.