ZAN Project Overview
Zoey's Motivation
Working with real world data provided to us by Hospital X is interesting. People’s behaviour, even when they follow expectations, are often varied and unique, and there is always a possibility of observing unexpected behaviours in the data. While we start off seeking improve the productivity of our sponsor’s colleagues, there is no telling what our analysis of the data might uncover about the situation and the problem, and that makes the project exciting.
It is very encouraging that our work has the potential to impact people’s lives. The sponsor’s concern for the community he works in is motivating as well. That has led him to do more for the hospital, even on top of his normal duties, inspires me to want to dig through the data and see if we can find anything that could him help the hospital improve their processes.
Aishwarya's Motivation
Many hospitals and clinics often face the problem of cancelled appointments as well as no show by patients. The time allocated by the doctors and consultations for these patients goes to waste, time that could have been significantly used by another patient in need of it. Our motivation is to be able to come up with a solution to efficiently maximize the utilization of the doctor’s time to be able to serve as many patients as possible. In this process, the doctors do not have to spend their time allocated to patients idly.
Another possible problem that we wish to look into through this project is the link between a patient’s details and his/her probability of cancelling an appointment. There could be various factors that influence the chance of a patient not showing up, such as the time of the appointment, the location of the patient, the age of the patient, experience of previous visit and so on. We hope to study these factors and try to find a possible link between the two. In doing so, we would be able to predict the probability of a patient not turning up for the appointment, and subsequently allocate the time to another patient in need.
Nas's Motivation
This project offers a follow-up to a previous project that I have done with a subsidiary of Hospital X. During that project, I have learn a lot about the organization and the amount of effort put in by the various stakeholders in order to improve the mental wellbeing of the general population. As an operationa management student, I am keen in exploring ways in improving the productivity of the staff as well as maximizing the access of care to the patients.
This project interests me as it offers a unique opportunity to further explore an unfamiliar domain (the medical sector). I believe that we can learn much from our project sponsor as he is a champion for data analytics and has considerable experience.
The objectives of the project would be the following:
- Analysis of Hospital X's inpatients data
- To understand the data domains
- To understand the workflow of scheduling a patient’s consultation process
- To identify the contributing factors that lead patients to defaulting appointments
- To conduct what-if analyses to understand changes in appointment rates if the patient is referred to a medical professional nearer to them
- To evaluate the feasibility of creating a predictive model
- Recommendations based on findings
- To help stakeholders understand the analysis of the findings
- To consider the feasibility of a visual aid such as dashboard to aid in the stakeholders' future reference
The dataset is based on Hospital X's child and adolescent department inpatient records. The inpatient records are processed by the hospital staff working on the front desk. The patient visits are mainly categorised into 1) first appointment with a doctor, 2) review appointment with a doctor, 3) first appointment with a psychologist and 4) reviewed appointment with a psychologist.
As we have not obtained the data until the NDA is signed, we will only share our initial thought process of how we will tackle the project. We shall adopt closely to the Data Analytics Lifecycle approach.
Prior to obtaining the actual data, we have been researching on the project topic to familiarise ourselves with the field domain and to understand the perspectives of the various stakeholders. We identified doctors, hospital frontline staff, patients who defaulted their appointments, patients who are unable to book an appointment due to no slots and Hospital X as the relevant stakeholders in this project.
With reference from several research papers, our secondary findings would be the following:
- Younger patients are significantly less likely to keep their initial outpatient mental health appointments
- No-show behavior is positively correlated with lower income and lower socioeconomic status
- Previous appointment experience of the patient, such as number of previous appointments, their types and lead times, do play a part in a patient defaulting his or her appointment
- The longer a patient has to wait for an appointment to be scheduled, the less likely is the patient to keep his or her first appointment
At this phase of the project, we will focus on understanding the given dataset and clean the data. Concurrently, we will decide on the analytical model and prepare the data accordingly.
While the project will revolve around the above objectives, our project sponsor is flexible to allow us to explore other possible relevant analytical tools or techniques that would enhance the findings.
- The dataset is limited to records from 2015 to 2016, which prevent any seasonal or yearly analysis
- The dataset only pertains to our project sponsor’s department, which administers only younger patients of ages 18 years and below.
