It's important, however, to draw a firm distinction between the collection of headline data, such as infection rates, hospitalisations, etc and the insight that can be revealed by analysing that data quickly and accurately.
For Suffolk County Council, moving from data to insight for a population of around 750,000 people required a rapid and innovative change in approach. As Rebecca Allen Head of C-19 Analytics, Knowledge & Intelligence, at Suffolk County Council explained, at the time, the information and communication capabilities of many local authority public health teams were not suited to the volume and complexity of data which now needed to be processed.
"In common with colleagues across the country, as the pandemic took hold, we were reliant on Excel-based data sets as the basis for data collection and analysis," she said. "Given the crisis situation, this presented us with a range of challenges, not least because it seriously impacted our ability to turn data into decisions."
Using this data to create a high-level dashboard, the Suffolk team were faced with the need to carry out ongoing and intensive manual upkeep to ensure datasets and the dashboard outputs remained accurate.
In response, the Council moved to develop what became known as their 'Coronawatch' dashboard, designed to provide not only public access to critical COVID-19 information, but also available in greater depth privately for key stakeholders, partners and decision-makers.
Visualised as a series of dashboards using Microsoft PowerBI, the solution – developed in close cooperation with IJYI – was designed to increase the stability and resilience of their infrastructure, reduce the need for manual data input and automate a range of key processes to deliver the agility required.
The service infrastructure was migrated to a secure cloud-based solution, and as a result, the Council now operates an agile, high-performance public and professional healthcare information and insight service offering access to vital data sources in an accessible and timely format.
Not only has this experience delivered a powerful set of capabilities to help address major public health issues, it has also helped inform the way the Council and colleagues from other local government organisations approach the collection, analysis, management and delivery of data and the vital guidance it can provide.
About the author