Visual Google Sheets KPI Dashboard

All of our daily sales data already lives inside a single Google Sheet—I simply need it turned into a clear, one-page dashboard that updates itself. The layout should be driven by graphs and charts, not tables, so anyone on the team can see what matters at a glance.

Filters must let the viewer slice results by Date range, Product category, Supplier, and Customer on the fly. Once filtered, the dashboard should instantly surface:
• Total sales
• Number of units sold
• Supplier performance (I have basic on-time delivery data, but I’m open to better ways to visualise this).

You can stay completely within the Google ecosystem—native Sheets charts, Looker Studio, or an Apps Script-powered solution are all fine—as long as it auto-refreshes and requires no paid add-ons. The data model is already arranged with columns for date, item, category, supplier, customer, quantity, and revenue, so you can plug straight in.

Deliverables:
• Live, shareable dashboard linked to my Sheet
• Built-in filters exactly as listed above
• Clean, readable charts for every KPI
• Short hand-over doc or video explaining how to maintain or tweak it

Speed and clarity matter more than decorative flair, but the end product still needs to look professional and load quickly. Let’s make it painless for the team to oversee daily operations without ever leaving Google Sheets.