Project Description
IMPROVING PATIENT EXPERIENCE IN THE EMERGENCY ROOM
WITH WAITING TIME MONITORS BY DEPARTMENT SPECIALTY
ZUYDERLAND
BRIEF
Waiting for medical help in an unexpected situation can be one of the most stressful and frustrating experiences that patients and their loved ones go through. It’s common for individuals to feel anxious and, in some cases, exhibit violent behaviors. To help ease their minds a bit, Zuyderland, a hospital in South Limburg, decided to introduce an innovative solution to improve the patient experience.
The idea was to develop monitors that visualize the expected waiting time in the emergency room. These kinds of monitors already exist in several Dutch hospitals, so what’s so special about this solution? Zuyderland decided to go a step further and provide patients with a waiting time monitor per department specialty based on a data model, now that’s a unique and innovative feature! During the development of this solution, our Data Science expert worked closely with Zuyderland to lay the groundwork and supported them with:
- Data preparation
Developing a suitable statistical model
Domain knowledge and expertise
A working prototype of the monitor
THE CONCEPT
In the past, patients had no idea what was going on behind the scenes, but now they get a better idea of how busy it is. Based on the crowdedness of the emergency room, patients now have a better grasp of how much time they will spend waiting for treatment. Moreover, to safeguard their privacy, the calculated waiting time spans only from the moment they enter the emergency room until they begin receiving treatment.
CUSTOMER CHALLENGE
The first challenge was to collect data from the SAP system and transform it in near real-time to provide up-to-date information. Next, we worked on developing a statistical model to accurately represent real-time conditions of the emergency room. This model takes into account the number of people currently in the ER to estimate how long a new patient has to wait. This step is complex because the data must be both accurate and up-to-date. There are cases where the data is not complete — for example, a patient still in the waiting room may not have all their data entered, or some essential information might not be logged until later, leading to incomplete data that must be managed. To deal with this, the statistical model is designed to set a maximum expected waiting time. This helps in setting realistic expectations for patients. Finally, in-depth knowledge of the medical domain is crucial to this project to ensure high quality data.
TECHNIQUES AND TECHNOLOGIES
This project required a close collaboration between the Data Science expert from Mediaan and Zuyderland. During this project the following methods and technologies were used:
- Microsoft SQL
- Python
- Statistical Modeling
- Machine Learning
- PowerBI
RESULTS
The provided solution retrieves data every five minutes, depending on the type of patients and specialties. The created model incorporates a comprehensive analysis of patient flow patterns, taking into account the influx data from the past two years. This historical insight, combined with real-time updates, provides patients with a transparent and reliable estimation of their waiting times. Overall, this innovative solution has significantly improved the patient experience in the ER.
WANT TO SEE MORE?
OTHER PROJECTS
CONTACT
GET IN TOUCH!
Would you like to learn more about our solution? Just provide your contact information, and one of our experts will get in touch with you.
We hope we have now convinced you that we are the ideal partner to brainstorm with about your specific needs. Don’t hesitate to contact us!