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.