CASE STUDY · HEALTHCARE · POSTGRESQL, POWER BI · FIELDBOOSTER 2022–23

PatientCare Analytics

About one in seven patients missed their appointment. An enhanced reminder cut semi-urban no-shows by a fifth, worth about BDT 0.87M a year.

APPOINTMENTS
73,692
NO-SHOW RATE, BASELINE
13.9%
PILOT REDUCTION
−5.9 pts
WEEKLY REPORTING TIME
−74%
Overview page of the PatientCare Power BI report
The overview page of the five-page Power BI report, built for the operations team.

THE QUESTION

Where do missed appointments concentrate, and does a better reminder fix them?

PatientCare is an outpatient network of 14 clinics in Bangladesh, with 115 doctors and 34,460 registered patients. From January 2022 to mid-June 2023 it booked 73,692 appointments, and about one in seven booked patients did not turn up. Working with the operations team, I brought 12 data sources (557,423 records) into one reporting model.

FINDING 01

It’s where patients live, not when they book.

Semi-urban patients missed 15.9% of appointments, against 11.9% for urban patients, in every month and every time slot. They hold about half of the baseline appointments and 56% of the missed fees.

Semi-urban vs urban no-show rate by month and by time of day
FINDING 02

A second reminder cuts no-shows by a fifth.

A 24-hour message plus a 2-hour follow-up cut semi-urban no-shows from 26.0% to 20.1% in a six-week pilot. The 1,409 appointments were split 1:1 within each clinic and month, so both groups faced the same clinics and months.

Pilot no-show rates and the 95% confidence interval of the reduction
FINDING 03

Every no-show is a fee left behind.

At BDT 1,139 per missed visit, no-shows cost about BDT 3.9M in fees over the seven-month baseline. The pilot kept about BDT 42k in six weeks; rolled out to every semi-urban patient, it would keep about BDT 0.87M a year.

Missed fees before the pilot, fees kept in the pilot and the 12-month projection
THE REMINDER PILOT · SIX WEEKS · SEMI-URBAN MORNINGS

It works, and June says keep measuring.

−5.9 ptsfewer no-shows across the whole pilot (95% CI 1.2 to 10.6 points, p = 0.013).
0 ptsDrop in the semi-urban no-show rate, enhanced vs standard reminder10 pts

Roll out now · Operations

The enhanced reminder for all semi-urban morning appointments: about BDT 0.44M a year in fees kept.

Extend next · Operations

Semi-urban afternoon and evening slots, up to about BDT 0.87M a year in total. Then pilot walk-ins and same-day bookings (17.7% and 17.0%).

Keep measuring · Analytics

Keep a small standard-reminder comparison group, review failed reminders monthly, and re-measure after six months.

HOW I BUILT IT

PostgreSQL
12 source extracts (557,423 records) cleaned into a star schema, with 4,342 data-quality issues logged instead of deleted.
Checks
41 automated tests run before every report.
Power BI
A five-page report with 84 DAX measures, including the pilot’s 95% confidence interval and a two-proportion z-test.
Reporting
Automating the preparation cut the weekly report from 244 to 62.5 minutes, about three hours saved every week.
NEXT PROJECTDiscount Guardrails