Google Sheets Dashboard & Private Filters

I want to upgrade our current Google Sheet so every team member can sort, search, or analyse data without disturbing anyone else’s view, even though we all sign in with the same Gmail account. Alongside that, I need a single-page dashboard that pulls live numbers from the main sheet and shows them in a clean, visually appealing layout.

Core priorities
- Independent Filter Views: each user must be able to turn filters on or off without altering what colleagues see. Please be ready to demonstrate this with the shared Gmail login.
- Dynamic Dashboard: charts and metrics should refresh automatically as new rows are added or edited.
- Staff-wise tracking: the dashboard needs to break down sales, pending work, follow-ups and completions by employee.

Dashboard must combine strong visual design, real-time updates, and fully customisable widgets so I can tweak KPIs later without rewriting formulas.

Deliverables
1. Main sheet re-engineered with protected master data and personalised filter views.
2. Linked dashboard sheet that updates instantly, requires no manual refresh, and works on desktop and mobile.
3. Short Loom or Meet walk-through showing the setup in action using the shared Gmail ID.

When you reply include:
• examples of past Google Sheets or Data Studio dashboards you have built,
• your relevant experience with filter views and query/array formulas, and
• a brief outline of how you would approach this project.

I’m ready to start as soon as I see a clear plan that ticks every box above.