Google Sheets Dashboard Setup

I have several raw CSV exports that need to live in one Google Sheets workbook and then feed a clean, interactive analysis dashboard. The job starts with importing the files, scrubbing duplicates, normalising dates and currency columns, and making sure every figure is recognised as a true number so formulas run without error.

Once the data tabs are stable, the next step is to create a dashboard tab that pulls key insights at a glance—totals by product, trends over time, and simple filters so I can slice results by month or category without touching the underlying sheets. I’m happy to lean on standard Google Sheets tools: QUERY, ARRAYFORMULA, pivot tables, charts, and slicers. No add-ons are required—everything should run natively in the browser.

Deliverables
• Cleaned data tabs with protected headers and documented formulas
• A single dashboard tab with automated charts and dynamic filters
• Short Loom or written walkthrough showing how to refresh or extend the file in future

Acceptance criteria
• Source numbers and the sheet match 100 %
• Dashboard auto-updates when new rows are appended to the data tabs
• All formulas are contained within the sheet (no external scripts)

If you’ve built similar Google Sheets dashboards before and can keep the file lightweight and self-explanatory, this task should be straightforward.