Robust data are essential to planning future healthcare services. When we know the demand on a current service, we can make an informed prediction of future demand. Without easily accessible data, demand and capacity modelling for service plans can be difficult. The challenge therefore is to get healthcare teams the data they need to effectively plan for the future.  

We started by understanding what data were currently available for different departments for example Cancer and Trauma. Once the baseline data were established, filtered and validated, we manipulated it using a software programme called Power BI. From there, data were tracked and traced through the hospital system. This allowed us to demonstrate the demand on other services for example radiology and laboratory.

Using Power BI, we were able to create a visual of the data in the form of an interactive dashboard. These dashboards have been used live at workshop
planning events.