← All work
Saltbush Rail
Punctuality report
A 40-tab spreadsheet became one report per line, with the on-time rate and the delays that caused it.
400
staff read it weekly
Role
Analyst, with network control
Tools
Looker, SQL
When
2019
The problem
On-time figures lived in a 40-tab spreadsheet that took a day to update, and most managers never opened it.
Each line manager wanted their own view, so the file kept growing.
The result
The control room uses it in the weekly service review, and line managers check their own page on Monday morning.
The spreadsheet was retired three months later.
How I got there
I cleaned five years of timetable and delay records into one model and built one Looker report per line, refreshed every night.
Each report leads with the week’s on-time rate, then the three delays that cost the most minutes, written in plain words.