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.
A complete Amusement Park Ticketing Management System Web App built on Google Sheets and Google Apps Script – 22 screens covering counter sales, gate scanning, season passes, rides, safety, cash reconciliation and 20 reports, with 5 server-enforced roles and a live demo you can sign into right now.
A bed-level hostel management system built as a single Google Apps Script web app: a fourteen-night bed board, self-posting folios, a cafe till, 17 exportable reports, 7 roles and 10 rules the server refuses to break. Free live demo with every role login.
A walkthrough of the Gym Personal Records (PR) Tracker in Google Sheets – the Total PRs Logged card, four live charts, the 16-column register, and the five columns that calculate Est. 1RM, Gain, Strength Ratio and % to Goal for you.
A one-page Google Sheets workout log with a live Total Volume Lifted KPI card, four auto-updating charts and a 15-column session table. Here is how every part of it works, what it does well, and where it stops.
A formula-driven Google Sheets KPI scorecard for 15 web analytics KPIs, with a month picker, MTD and YTD traffic lights, a per-KPI trend page and a group analysis page. Independent template – it does not connect to Google Analytics or GA4; you enter your own monthly numbers.
A month-by-month paid search scorecard built in Google Sheets: 13 KPIs across four groups, MTD and YTD achievement, traffic lights, a single-KPI trend page and a group roll-up. You enter your own numbers – it does not connect to any ad platform.
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.