Demand forecast for hospitals

data

Objective

A healthcare client needed to predict demand over 8 years and simulate the impact of a variety of initiatives.

Key challenges:

  • Consolidating complex data from several different sources
  • Forecasting demand at the most granular level, based on a multitude of factors
  • Simulating the impact of different initiatives for individual sites and Primary Care Trusts at different granularities (including closing and opening of hospital specialties/departments)
2

Technical solution

Access database with Excel front-end.

Access database contains:

  • Data from multiple sources (e.g. estimated demographic development per zip code)
  • Simulation logic and results

Excel front-end:

  • Modify simulation parameters and trigger simulation
  • Create reports based on simulation results
  • Export results to PowerPoint and standard Excel format required by authorities
impact

Result

The client managed to prepare a detailed forecast and initiative plan for the next decade based on the simulation tool. Results were reported to authorities in time without the usual need for readjustment afterwards.

Industry
Healthcare & Pharma
Tool type
Forecasting
Project duration
3 months
d2i effort
60 MD
Data volume
Tools involved
Excel
PowerPoint
Access
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok