Understanding performance drivers across urgent care pathways
Our Business Intelligence team in partnership with Herefordshire and Worcestershire Integrated Care Board, revolutionised data management and decision-making processes within the urgent care pathway, enhancing both efficiency and accuracy by developing a comprehensive, interactive dashboard.
The integrated care board (ICB) of Herefordshire and Worcestershire expressed a need for a dashboard. This tool was envisioned to illustrate the impact of each stage of the patient journey within the Urgent Care Pathway. This pathway encompasses various stages from the initial contact through dialling the NHS 111 service to the final stage of patient discharge.
To address this requirement, NHS Midlands and Lancashire CSU’s Business Intelligence (BI) team developed an interactive dashboard using Power BI, incorporating and modifying the National Health Service England (NHSE) Statistical Process Control (SPC) template to suit the specific needs of this project. This required deep collaboration both with the Urgent Care team and the ICB’s BI team working on data models and tools. Collaborating with the Urgent Care team, over 250 metrics were identified and included in the dashboard to describe various stages of the patient journey. These metrics covered a wide range of indicators, including but not limited to NHS 111 referrals to ambulances, primary care appointments, urgent community responses, ambulance response times, Accident & Emergency (A&E) department times, emergency admissions, patients spending over 14 days in a bed, average length of stay, and discharge details by pathway.
The dashboard design features SPC charts for core metrics, a data table displaying the last 12 months of data, year-on-year growth comparisons, and benchmarking elements to contextualise current performance. Non-core metrics are accessible via a dedicated metrics search tool. The dashboard also includes summary pages, an overview page, and a user-friendly menu to facilitate easy navigation.
The implementation of this dashboard is significantly influencing the understanding of the patient journey through the urgent care pathway. It is enabling the customer, in this case, the ICB, to discern the impact of each stage on the overall patient journey. The SPC charts are particularly beneficial, allowing the customer to quickly determine whether observed variations are significant or merely common cause/natural variations.
The dashboard serves as a vital resource for the Urgent & Emergency Care Programme Board, informing its operations and decision-making processes. It is proving instrumental in meeting urgent time-scale requests for NHSE reporting and meetings.
Furthermore, the availability of an online version of the dashboard aligns with a self-service model, granting on-demand access to the information to a wide audience. The transition to this dashboard has reduced the need for manual intervention, leading to more reproducible outputs and a significant reduction in processing time, thereby freeing up capacity for other analytical work.
“The dashboard provides all of the key metrics in one place, supporting a system-wide understanding of the performance and the interdependencies.” Jade Brooks | NHS Herefordshire & Worcestershire ICB
This work was led by Business Insight Lead, Nick Bryan. If you would like more information about this project, you can contact Nick via email on firstname.lastname@example.org.
News and views
Recorded live at the NHS ConfedExpo, join host Richard Caddy in an engaging dialogue with Kelly Bishop, Assistant…
Our Health Economics Unit (HEU), in a successful collaboration with the Midlands Decision Support Network, has marked a…
The Digital Innovation Unit (DIU), along with their commercial partner Citizen Communications, are hosting an event on the 31…
How we can help health systems
Developing health systems
Acting as an independent and trusted partner within the system to facilitate working across stakeholders and integrate elements of the provider system…Learn more about Developing health systems
Workforce resilience and transformation
Supporting systems to build a sustainable and integrated workforce, transforming systems, organisations and the workforce experience to improve resilience.Learn more about Workforce resilience and transformation
Communications and engagement
Supporting ICSs with approaches to design and deliver effective communication, engagement and behavioural insights as a key enabler for system change and…Learn more about Communications and engagement
Digitally enabled transformation and IT
Digitising care and partnering with systems for the transformation of digitally enabled service delivery (and other supporting processes) across vision, planning and…Learn more about Digitally enabled transformation and IT
PHM analytics and decision support
Applying intelligence-led understanding of the health of the population to support the redesign of care and improve patient and financial outcomes across…Learn more about PHM analytics and decision support
Place and primary care transformation
Supporting providers to work together at a place and neighbourhood level to manage common resources, integrate community teams, improve health and reduce…Learn more about Place and primary care transformation
Clinical redesign and provider collaboration
Redesigning how health and care works across England - placing people at the centre of their own health and care and utilising…Learn more about Clinical redesign and provider collaboration
Personalised healthcare commissioning services
Providing end-to-end funded care services, including patients as active partners in identifying their healthcare needs and then commissioning care to meet these.…Learn more about Personalised healthcare commissioning services
Business enabling services
Delivering a wide range of support functions through transactional services, business partnering and transformation that drives efficiencies and releases value and time…Learn more about Business enabling services