Waiting List Analysis Course

Sound problems? If you are using Apple iOS, please make sure you unmute your device to hear sound in the video.

Who is this course for?

The Waiting List Analysis course is for hospital and healthcare provider staff that want to improve patient care by reducing waiting times supported by analytical techniquesThe participant will become comfortable using data to drive waiting list performance in their organisation. 

"MedModus’ waiting list tracker tool is central to managing and improving waiting list performance in Tallaght Hospital. The tool allows us to observe trends, drill down to specialist level, study chronological booking and make forecasts. The fact that the trackers are produced automatically saves many hours of reporting time and allows our scheduled care teams to focus on improving wait times for patients rather than producing reports. It facilitates more focused discussions with medical and surgical consultants and provides immediate information on proposed changes to waiting list trends."

John Kelly

COO, Tallaght University Hospital, Dublin, Ireland

Example of a waiting list tracker dashboard.
Orthopaedic waiting list dashboard.
Demand versus capacity graph.
Pivot table and chart showing growth in orthopaedic waiting list.
Example of waiting list tracker.

Aims of the course

  • To develop a tool that will allow users to continually monitor waiting list performance
  • To give healthcare professionals the fundamental techniques needed to analyse waiting lists
  • To provide examples of how data can be used to drive waiting list improvement in hospitals

What will I learn?


Waiting List Tracker – On completion of this course, you will have a comprehensive understanding of the use and implementation of a Waiting List Tracking tool. You will be able to create this tool for your hospital, making waiting list analysis more efficient and helping you to draw important insights.


Chronological booking – Ensuring the longest waiters are seen first while allowing for urgency, is vital to reducing patient wait times. You will learn how to measure this at a specialty and doctor level.


Demand vs. capacity analysis – Changes in demand and capacity can have significant impacts on waiting lists. You will learn how to estimate these, helping you to better plan the services your hospital provides.


Performance targets – Measuring specialties and doctors against performance targets will quickly highlight where potential problems lie. You will learn how to create custom performance targets for your hospital


Real-world knowledge – You will learn proven, practical techniques that can immediately be used in your hospital

One-on-One Support

Throughout this course you will be provided with one-on-one support by a dedicated tutor. Following the course this tutor will assist you in creating a waiting list tracker for your hospital.

Lesson plan

Lesson 1: Waiting List Data – 25 minutes

Lesson 2: How to Determine Waiting Time – 60 minutes

Lesson 3: Appointments & Patient Priority – 75 minutes

Lesson 4: Patient-Level Tracking – 25 minutes

Lesson 5: Chronological Booking – 45 minutes

Lesson 6: Estimating Demand – 40 minutes

Lesson 7: Demand vs. Capacity – 50 minutes

Lesson 8: Breach Targets – 20 minutes

Lesson 9: Updating the Dataset – 15 minutes

Lesson 10: Data Visualisations – 30 minutes

Lesson 11: Conclusion & Assessment – 180 minutes

How will I be assessed?

There is continual evaluation throughout this course, with a quiz after each lesson. You must pass the quiz in each lesson before you can progress to the next topic. The final lesson includes an assessment, where you will be tested on the analysis techniques covered in the course. The final assessment will be graded by the course teacher, and must be passed to complete the course. You will then be provided with a Certificate of Completion. 

The entire course takes 10 hours to complete. You will have access to the course materials for 6 months.


  • Hospital or healthcare provider employee
  • Intermediate Microsoft Excel skills (e.g. writing formulas, pivot tables)
  • Microsoft Excel 2013 or 2016 installation (with Power Pivot enabled)
  • dual monitor setup will make it easier to follow along. One screen can be used for the video content and the other for your work in Excel. Using a second monitor or tablet to watch the video content will speed up your progress.

Course Price

25% off until 31st December 2020

€1,995 €1,495


6 months course access


One-on-one support


2 days post-course support to create waiting list tracker for your hospital

View Course Preview

Please fill out the form below to preview a lesson from the course or contact us on [email protected] for more information.