Our business intelligence experts helped the Lancashire and South Cumbria COVID-19 Vaccination Programme to provide an efficient and equitable service.

Background
The Lancashire and South Cumbria COVID-19 vaccination programme worked with a wide range of partners, including our business intelligence team, to make an efficient and equitable offer of vaccination to the population.

We helped the programme overcome challenges including:

• Understanding the profile of the area’s population, particularly age, location and clinical vulnerabilities prior to the vaccination rollout
• Modelling detailed delivery plans both prior to and during rollout and its various phases
• Utilising available data sources to extract, analyse and present vaccination activity and related data to a range of stakeholders
• Timely and effective monitoring of performance to aid key decision-making processes
• Supporting responses to queries at a local, regional and national level, as well as sharing examples of good practice in business intelligence.

Action
We worked with the vaccination programme and associated stakeholders to implement solutions including:

• Utilising both local GP systems and national sources of data to fashion datasets providing maximum analytical value to the system
• Constructing detailed planning tools to permit complex scenario modelling with clear and actionable outputs
• Creating and maintaining operational and performance reports relating to various aspects of the programme, including demand, activity, bookings and stocks
• Providing swift and effective responses to queries at a local, regional and national level, as well as sharing best practice in business intelligence, to support a robust and adaptive programme delivery.

Impact
We helped stakeholders make data-driven decisions in key areas of operational delivery throughout the rollout. Access to detailed and highly adaptive insight contributed to achieving many of the vaccination programme’s core objectives.

In particular, the daily Situation Report provided unparalleled access to information on site activity and population uptake across the health system. It enabled leaders to closely monitor programme delivery and the impact of their decisions, and to respond proactively to operational challenges as and when they arose.

Similarly, we used data on GP systems and existing data on our established business intelligence platform to produce reports which were invaluable tools in facilitating ad hoc deep-dive analyses of vaccination uptake across a diverse geography. They also supported wider system work around population health management and the reduction of health inequalities.