Lancashire County Council


Written by:
Maisie Hockings,
Practice Director

The Problem

Our engagement began with a focused initiative on Covid reporting, leveraging data to provide timely and accurate insights into the evolving situation. This involved the creation of comprehensive reports, presentations, and dashboard products that were instrumental in monitoring and communicating crucial information related to the pandemic. The success of this initial endeavour laid the foundation for an expanded scope of work, extending beyond the urgent needs of Covid reporting to encompass business-as-usual tasks and other specialised projects.

As the Public Health landscape transitioned from the acute phase of the pandemic, our collaboration seamlessly shifted towards addressing business-as-usual tasks. This involved an array of ongoing public health initiatives, including a dedicated project on substance misuse. The substance misuse project required a nuanced and targeted approach, incorporating data analysis to understand patterns, identify areas of concern, and inform evidence-based interventions.

In response to these evolving needs, our team continued to deliver a range of communication materials. Presentations served as a means to distil complex data into comprehensible insights, facilitating effective communication with stakeholders. Reports offered in-depth analyses, delving into the intricacies of various Public Health projects and providing valuable recommendations for decision-makers. Meanwhile, dashboard products provided a dynamic and visual representation of key performance indicators, offering a real-time overview of project progress and outcomes.

The Solution

During the challenging times of the pandemic, our collaboration with the Director of Public Health (DPH), Public Health team, and the broader community was characterised by a commitment to keeping all stakeholders fully informed. We played a crucial role in delivering regular updates on Covid-19 cases, patient information, and the impact of the virus on the community. This involved the meticulous analysis and reporting of data to provide a comprehensive understanding of the evolving situation, contributing to informed decision-making and strategic planning.

One notable achievement was our involvement in the targeted, effective, and efficient planning for the vaccination delivery across Lancashire’s vast population, exceeding 1.2 million residents. Leveraging data-driven insights, we worked closely with the Public Health team to develop vaccination strategies that were not only responsive to the immediate needs of the community but also designed to adapt to the evolving dynamics of the pandemic. This collaborative effort contributed to the successful rollout of vaccination programs, ensuring that a significant portion of the population was inoculated against the virus in a timely and organised manner.

In addition to our contributions during the pandemic, our collaboration extended to a comprehensive review and re-commissioning of substance misuse services. We facilitated this process through the development and implementation of a Quality Assurance Framework product. This tool played a pivotal role in guiding lead commissioners and service heads in evaluating the effectiveness, timeliness, and equity of substance misuse services. By providing a systematic approach to quality assurance, our product enabled stakeholders to identify areas of improvement, ensure efficient service delivery, and uphold the principles of equity and timeliness for clients seeking support. The Quality Assurance Framework product helped lead commissioners and service heads ensure that the service was (and continued to be) timely, efficient and equitable for clients.

The Result

Covid Reporting and Analysis: In response to the unprecedented challenges posed by Covid, our team played a pivotal role in establishing robust automated reporting systems using PowerBi. These systems were designed to extract real-time data, providing up-to-the-minute information on Covid cases, patient details, and fatalities. The implementation of these systems not only ensured accuracy and timeliness but also facilitated a dynamic and responsive approach to the evolving situation.

Regular Situational Report (sit-rep) meetings were conducted where our team presented the latest findings, both verbally and in written reports. These presentations offered a comprehensive overview of the current state of Covid within the community, helping stakeholders make informed decisions. The collaboration extended to setting up vaccine uptake monitoring for the Health Protection team, ensuring that vaccination efforts were targeted and effective in the broader public health strategy.

Substance Misuse Analysis and Quality Assurance: In the realm of substance misuse, our team utilised a combination of published indicators and National Drug Treatment Monitoring System (NDTMS) data for a comprehensive analysis of client trends and profiles. This data-driven approach allowed us to identify key patterns, challenges, and opportunities within substance misuse services.

Building upon this foundation, we collaborated on the development of a bespoke Quality Assurance Framework for Drug and Alcohol services. Drawing from our expertise and the insights gleaned from data analysis, we selected and incorporated relevant metrics into the framework. This framework became a cornerstone for reshaping and monitoring substance misuse services. By establishing clear metrics and performance indicators, it facilitated a systematic evaluation of service effectiveness, timeliness, and equity.

The implementation of the Quality Assurance Framework not only ensured that services were aligned with best practices but also allowed for continuous improvement. Monitoring and adapting services based on the framework’s metrics ensured that substance misuse programs were responsive to the evolving needs of the community and consistently delivered high-quality care.

Get in touch