Understanding vaccine uptake in healthcare workers and at-risk groups in England

Research and development of a comprehensive data analysis and visualisation tool for simple and effective value communication


The challenge

Our client had supplied an intradermal vaccine in the UK since 2010. As part of their ongoing lifecycle management and to inform future strategy for increased market access of their product, they approached us to conduct a review of local level uptake of this vaccine for at-risk groups and healthcare workers (HCWs) in England.

Although the client already had access to some information, there were a number of questions regarding the robustness of their identified data sources including:

  • Numerical errors and formatting errors in the source data.
  • Inconsistency in the type and quantity of data collected between seasons, particularly in older data sets.
  • Changes in organisational structures / regional boundaries in England, 2004-2015.

The solution

A detailed project plan was developed, aligned with our client’s needs. Published real world data on vaccines uptake over the previous 10 years was researched and identified, primarily from government agencies (e.g. Health Protection Agency, Public Health England, and the Department of Health), and we developed a comprehensive Excel workbook tool detailing the vaccine uptake patterns for both at-risk groups and HCWs.

Key results

Following extensive data cleaning to ensure accurate and robust data, the workbook provided easy access and analysis of national, regional and organisational-level data split over ten seasons (2004/05 to 2014/15), allowing for changes in organisational structures.

The following graph is an example of the visualisation of uptake patterns in a specific group and region.

Value to the client

The user-friendly Excel tool was particularly valuable for our client to use internally. The inclusion of visuals allowed for easy interpretation of the data by end users and impactful value communication of the vaccine uptake patterns in England.

Related categories

Case Studies