Appointment Scheduling Optimisation

Overview

From fragmented manual scheduling to a digital operating model.

Led the analysis and redesign of a healthcare appointment scheduling process to improve patient experience, reduce no show rates, optimise clinician utilisation and increase operational efficiency across Harmonie Medical Centre.

The project focused on transforming fragmented manual scheduling activities into a future state digital model supported by automated reminders, self service booking, operational dashboards and improved workflow governance.

The Problem

A 34.4% no show rate built on manual processes.

The medical centre relied on manual scheduling, resulting in high patient no show rates, double bookings, long wait times, limited clinician availability visibility, inefficient follow up coordination and poor operational reporting.

High appointment no show rates (34.4%)

Double bookings and scheduling conflicts

No automated appointment reminders

No self service booking options

Poor scheduling visibility for clinicians

Manual follow up management

Limited KPI reporting capability

Fragmented scheduling workflows

Root cause analysis using 5 Whys traced the no show rate and double booking issues to the absence of digital infrastructure, automated reminders and a centralised scheduling system — gaps the future state model was designed to close.

Process Redesign

AS IS and TO BE, end to end.

The AS IS model surfaces every manual touchpoint: verbal confirmation only, no reminders, manual availability checking and manual follow up coordination. The TO BE model introduces an online booking portal, system confirmations, automated reminders and structured follow up workflows.

AS IS appointment scheduling process diagram — **AS IS process.** Three swimlanes: Patient (verbal confirmation only, waiting with no reminders, missed appointment loop), Front Desk Staff (manual availability check, manual scheduling) and Clinicians (consultation, follow up decision). The manual handoffs at every stage create the no show and double booking risk.

TO BE future state appointment scheduling process diagram — **TO BE process.** Four swimlanes: Patient (online self service or walk in), System (slot availability, automated confirmation, reminders), Front-desk (walk in logging, slot reinstatement on non-confirmation) and Clinician (consultation and system-assisted follow up booking).

Dashboard Evidence

The data behind the 34.4% no show rate.

Two Power BI dashboard views built from the scheduling dataset, covering appointment volumes, no show patterns, clinician utilisation, double booking risk and time slot analysis across 10,000 appointments and 1,000 patients.

Healthcare scheduling dashboard showing appointment volumes and no-show rate — **Scheduling overview.** 10,000 appointments, 34.4% no show rate, 33.3% clinician utilisation, double booking at 1.57%. Monthly trend, status distribution, specialisation breakdown and time slot demand visible across the dataset.

Healthcare scheduling dashboard showing no-show patterns and clinician analysis — **No show and double booking analysis.** Highest no show at 10:30 to 11:00 AM, worst day Sunday (53.4%), emergency slot fill rate 48.4%. Clinician level no show rates, appointment type double booking risk and language based no show patterns.

Impact & Outcomes

£144K opportunity, 162% ROI.

25,000

Annual patient visits

34.4%

No show rate identified in data

£144K

Projected annual benefit opportunity

162%

Projected return on investment

1,440

Appointments recoverable annually

10,000

Appointments in the analysed dataset

✓Identified opportunity to recover approximately 1,440 appointments annually

✓Defined scheduling KPI framework covering no show rates, utilisation and efficiency

✓Produced AS IS and TO BE process models for both booking and follow up workflows

✓Developed Power BI healthcare dashboard framework from appointment dataset

✓Created ROI assessment demonstrating 162% projected return

✓Produced phased implementation roadmap with automation and self service recommendations

Deliverables

The full artefact set.

Business Analysis

Business Requirements Document
Stakeholder analysis
Functional requirements
Non functional requirements
AS IS process model
TO BE process model
Gap analysis
Root cause analysis (5 Whys)

Analytics & Reporting

KPI framework
Healthcare dashboard design
Appointment demand analysis
No show pattern analysis
Clinician utilisation reporting
ROI assessment

Solution & Delivery

Solution evaluation matrix
Automated reminder framework
Self service booking design
Operational dashboard concepts
Implementation roadmap

Business analysisHealthcare operationsProcess optimisationPower BIBPMN process modellingKPI frameworkRoot cause analysisGap analysisROI assessmentSolution evaluationLucidchartStakeholder analysis