Abstract BackgroundWorcestershire Directorate of Public Health constantly processes, analyses, visualises and presents data, information and evidence. This is an extremely important, yet often time consuming aspect of our work.In recent years, there has been a step change in the way that public health information can be retrieved, analysed, visualised and consumed through automation. ‘R studio' is becoming more commonly used as an analysis and visualisation platform. However, Worcestershire Public Health had a specific need to provide regular refreshes of data to various Boards, and Microsoft PowerBI provided a good automated solution for this need.MethodAn API link from PHE Fingertips was used to automatically import data directly into PowerBI. The 1st dashboard to be built was a County and District-level PowerBI Health and Wellbeing Board dashboard to support HWBB priorities.A scheduled refresh was created ensuring data remained synchronised with the latest Fingertips data.The dashboard was published to Worcestershire County Council's JSNA site (http://www.worcestershire.gov.uk/jsnapublications).
Results
A number of dashboards have now been developed and published, including a ‘Children and Young People' and ‘population projections' dashboards. Published dashboards link to the host server and automatically refresh on a set schedule. All dashboards are being frequently accessed by professionals and the public.
Conclusion
We are monitoring the use of dashboards, and have received positive feedback to date. PowerBI is an extremely useful tool to ensure the presentation of public health data is accessible, whilst freeing up analyst time for more complex analysis rather than repetitive tasks. External funding details NONE