Online Tutorial for Data Analysis and Automation
Google-Sheets-Dashboard
The Heavy Machinery Dashboard in Google Sheets tracks 16 KPI cards and 18 charts across 6 pages, driven by 15 native slicers over a 500-order book that auto-expands to 1,000 rows. Built on real pivot tables, it covers plant output, dealer orders, backlog and warranty service in one browser file.
A pivot-and-slicer Electronics & Semiconductors Dashboard in Google Sheets with 6 pages, 16 KPI cards, 18 charts and 15 slicers covering wafer starts, yield, device mix and fab margin – built on 500 sample production lots.
The Textiles & Apparel Manufacturing Dashboard in Google Sheets tracks 16 KPI cards, 16 pivot-driven charts and 15 slicers across Overview, Production, Quality and Orders pages, plus an order lookup screen – built on native pivot tables and slicers, ready for 1,000 production rows.
A six-page steel and metals mill dashboard built on native Google Sheets pivot tables and slicers: 16 KPI cards, 14 charts, 16 slicers and an order-level lookup, with 380 rows of demo data ready to be replaced with your own order log.
A production-reporting dashboard for chemical plants built entirely in Google Sheets: 6 tabs, 16 KPI cards, 18 native charts and 15 slicers over a 380-batch demo dataset covering output, yield, OEE, cost and margin.
A six-page Power Generation Dashboard in Google Sheets built on native pivot tables and slicers – 16 KPI cards, 18 charts and a record lookup covering MWh, capacity factor, availability, outage hours, revenue and margin across your generation fleet.
A walkthrough of the Oil & Gas Dashboard in Google Sheets – 6 tabs, 16 KPI cards, 18 pivot-driven charts and 15 native slicers for production, uptime, operating cost and netback reporting, with 500 rows of labelled demo data to start from.
The Marine & Ports Dashboard in Google Sheets reports vessel calls, cargo tonnage, TEU, berth utilisation and shipping line revenue across 6 tabs, 16 KPI cards, 18 pivot-driven charts and 15 slicers – a one-time-purchase reporting layer over your own vessel call log.
A pivot-and-slicer Railways Dashboard in Google Sheets with 6 tabs, 16 KPI cards, 19 charts and gauges and 15 slicers – covering punctuality, route revenue, operating margin and passenger demand from your own service log.
A five-page Shipping Dashboard in Google Sheets built on native pivot tables and slicers – freight spend, carrier mix, trade lanes, customer delivery quality and a shipment-ID lookup, with 500 sample shipments loaded and room for 1,000 rows.