Online Tutorial for Data Analysis and Automation
A page-by-page walkthrough of the Secondary Schools Dashboard in Google Sheets – five linked reporting pages, 18 charts, 15 slicers and a coded Student ID lookup over 500 sample rows, with an honest note on what the file does and does not hold about pupils.
A six-tab Google Sheets reporting template for primary schools: 16 KPI cards, 21 charts and gauges, 15 slicers, native pivot tables and a Record ID lookup. Class-level data only – no pupil names, dates of birth, contact details, SEN or safeguarding fields anywhere in the file.
A fire safety audit management system web app with 22 screens, 6 roles, weighted compliance scoring, derived site risk, a 1,677-asset register and 15 reports.
A finished Google Apps Script web app for escape room venues: day-grid schedule, slot-factor pricing, booking lifecycle, game results and leaderboard, payments, invoices, vouchers, promo codes, props and 20 reports across 8 server-enforced roles. Live demo inside.
A full walkthrough of the Gaming Zone & Arcade Management System Web App – time-billed stations, prepaid game cards and ticket balances, bookings, tournaments, party packages, a costed snack bar, a prize counter and 13 reports, with a live demo and eight seeded logins.
A six-tab Google Sheets calendar for diagnostic centres and preventive-health clinics: 100 sample bookings, 16 checkup package types, 28 clinic rooms, and four linked views. No patient data fields, by design.
Plan and review administrative bed-turnover events with annual, monthly, daily, and central event-register views in Google Sheets.
Ten elevator maintenance KPIs on one Google Sheets board – uptime, callbacks, MTTR, entrapment response, PM completion, overdue work orders and more – with a month picker, MTD/YTD basis, Target or prior-year comparison and direction-aware traffic lights.
Track 10 solar installation KPIs with actual-versus-target cards, MTD and YTD trends, prior-year comparisons, and editable definitions in Google Sheets.
Track 13 locksmith KPIs in Google Sheets with a month picker, MTD and YTD traffic lights, per-KPI trends, group analysis, targets and prior-year comparison.