← All work

Fernhill Health

Clinic wait times

Check-in data showed waits peaked at the same two hours every day. A new triage rota moved nurses to those hours.

−18%

average wait

Role

Lead analyst, with the clinical operations team

Tools

SQL, Python, Looker

When

2024

The problem

Patients at twelve clinics waited about three quarters of an hour from check-in to their first nurse, and the wait was getting longer every quarter.

Staff blamed rising demand, but nobody had looked at when the patients actually arrived.

Sample line chart: average clinic wait in minutes falls after a new rota

The result

The new rota went live in July across all twelve clinics. Waits started falling the first week and kept falling through the winter.

A weekly Looker report now shows the wait at each clinic, so a site that slips gets noticed on Monday, not at the end of the quarter.

How I got there

I joined two years of check-in times with the nurse rosters in SQL and found two daily peaks, at 10 am and 2 pm, when rosters were at their thinnest.

With the operations lead I modelled three rota options in Python, tested them against the busiest months, and chose the one that moved two nurses into each peak without adding hours.

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