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
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
By clicking “Accept Terms & all Cookies” or by continuing to browse, you agree to the storing of third-party cookies on your device to enhance your user experience and agree to the user terms and conditions of this learning management system (LMS). USER TERMS AND CONDITIONS | PRIVACY POLICY
Cookie Settings
Accept Terms & all Cookies
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.