Online Tutorial for Data Analysis and Automation
A full walkthrough of the Project Management Office (PMO) Dashboard in Google Sheets – six linked pages, sixteen pivot-driven charts, sixteen slicers, 500 sample projects and a project lookup page for budget, RAG status, milestone and capacity reporting.
A six-page Engineering Dashboard in Google Sheets built on native pivot tables and slicers. Track project cost, engineer hours, department workload, lead engineer performance, billing model mix and delivery phases – and look up any single project by ID.
The Knowledge Management Dashboard in Google Sheets tracks 16 KPI cards and 16 slicer-driven pivot charts across six tabs, on 500 sample knowledge base articles. Measure cost savings, readership, content mix and review health, then look up any article by ID.
A six-page Google Sheets dashboard for tracking audit engagements, findings, exposure value and control categories – built on native pivot tables and slicers, with 500 sample audits already loaded.
A six-page Google Sheets dashboard for transport operators – 500 sample trips, $215,597 of revenue, 16 slicers and 16 charts built on native pivot tables. Walk through every page, see what it does well, and learn where it stops.
Track Core Web Vitals, page speed, SEO traffic, bounce rate, CTR, keyword rankings and website KPIs with this Google Sheets dashboard template.
A pivot-and-slicer Community Services Dashboard in Google Sheets that tracks 16 KPIs across Overview, Centers, Programs and Clients pages, plus a Case ID search tab. 500 sample records, 1,000-row capacity, no subscription.
A Google Sheets restaurant dashboard that tracks 16 KPIs across 4 interactive pages using 24 native pivot tables, 16 charts and 16 slicers. Compare outlets, cuisines, channels and customer segments without a POS subscription.
Sports and Recreation Dashboard in Google Sheets tracks bookings, revenue, attendance, facility utilisation, membership revenue, coaching, and satisfaction.
Review the HealthTech Dashboard in Google Sheets with 7 tabs, 5 KPI cards, 25 charts, slicers, Case ID search, and data entry.