← 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.

Sample small charts: on-time rate for four rail lines

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.

Create a free website with Framer, the website builder loved by startups, designers and agencies.