Data analysis of Cheers hospital

Since it’s inception, Hospital for Children Eye ENT and Rehabilitation Service (CHEERS) has amassed data from various sources such as all the software used in daily operations, research department and the finance department. With priority in budgeting which is always a significant factor, CHEERS wanted Moonlit Solutions to analyze the data from different sectors within the hospital and create forecasting models to help with their operational efficiency.

Cheers

Scope of work

  • Data curation from different sectors of the hospital (but only limited to their Hospital Management Information System)
  • Data wrangling and principal component analysis
  • Exploratory data analysis
  • Creation and validation of different forecasting models
  • Assist in the creation of the forecasting section in the hospital master plan that is currently being developed.

Methodology

After the acquisition stage, all analysis presented in notebooks followed the following methodology:

  • Gaining domain expertise
  • Data wrangling and cleaning (a lot of imputing using the domain knowledge and meeting stakeholders)
  • Exploratory Data Analysis
  • Forecasting with multiple models (AR, MA, ARIMA, SARIMA, Bayesian, Deep Learning)and different KPIs (Daily sales, Daily patient visits)
  • Optimization (Parameter tuning)

Outputs

  • Robust forecasting models predicting future sales
  • A report document
  • Dashboard showcasing interactive charts and tables (and all analysis notebooks for research reproducibility)

The exploratory data analysis and forecasts generated went through various levels of quality assurance to validate the correctness. Unfortunately, the COVID-19 epidemic and subsequent lockdowns was going to affect the business. The model created wasBAU (Business As Usual). It did not forecast out of the world scenarios like COVID-19 (a Black Swan event). However, it will create a benchmark for measuring the effects of COVID-19 in the future. The forecasting can still be used to understand the impact of COVID-19 on the business. The exploratory data on the other hand, provides significant insights for the hospital’s strategy development.