Automation of public health dashboards using Microsoft PowerBI in Worcestershire
PHE ePoster Library. Fung M. 09/12/19; 274487; 48
Mr. Matthew Fung
Mr. Matthew Fung
Login now to access Regular content available to all registered users.

You may also access this content "anytime, anywhere" with the Free MULTILEARNING App for iOS and Android
Rate & Comment (0)
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 (
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.
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
    This eLearning portal is powered by:
    This eLearning portal is powered by MULTIEPORTAL
Anonymous User Privacy Preferences

Strictly Necessary Cookies (Always Active)

MULTILEARNING platforms and tools hereinafter referred as “MLG SOFTWARE” are provided to you as pure educational platforms/services requiring cookies to operate. In the case of the MLG SOFTWARE, cookies are essential for the Platform to function properly for the provision of education. If these cookies are disabled, a large subset of the functionality provided by the Platform will either be unavailable or cease to work as expected. The MLG SOFTWARE do not capture non-essential activities such as menu items and listings you click on or pages viewed.

Performance Cookies

Performance cookies are used to analyse how visitors use a website in order to provide a better user experience.

Save Settings