Descriptive Data Visualization in Google Sheets

I have a collection of raw spreadsheets inside Google Workspace that need to tell a clearer story. Your job is to pull the data into a structured Google Sheet, perform straightforward descriptive analysis (totals, averages, trends over time, category breakdowns, etc.), and then turn those insights into eye-catching charts or graphs.

The final file must remain fully editable in Google Sheets, but I also want the option to download it as an Excel workbook without losing formulas or visuals. Please keep the workflow cloud-based so my team can follow along and leave comments.

Deliverables:
• A cleaned, well-labeled Google Sheet with formulas in place
• At least one dynamic dashboard tab featuring the agreed-upon charts/graphs
• Brief notes inside the sheet explaining any calculated fields or pivot settings

I’ll share view-only access to the source files once we start; you can request edit rights as needed. Let me know your estimated turnaround time and a couple of sample visualizations you’ve built in Google Sheets before, and we can get moving.