1 / 20

Overview of PHO web presentation workstream

Overview of PHO web presentation workstream. Jo Watson, Alison Hill South East Public Health Observatory. Thanks to Hannah Walford, Principal Analyst, ERPHO and Daniel Flint, Web Developer, ERPHO. Project Brief 2011/12.

damita
Download Presentation

Overview of PHO web presentation workstream

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview of PHO web presentation workstream Jo Watson, Alison Hill South East Public Health Observatory Thanks to Hannah Walford, Principal Analyst, ERPHO and Daniel Flint, Web Developer, ERPHO

  2. Project Brief 2011/12 • Develop a single database and web presentation platform bringing together erpho’s PHOLIO-based profile tools and the Compendium development • Review all PHO profiling outputs and establish a single portal to link them all • Increase efficiency of profile production by using common platforms

  3. Jargon busting: PHOLIO & Fingertips • PHOLIO is an SQL database designed by ERPHO to store indicator data, metadata and Fingertips configuration information • Fingertips is a software platform developed by ERPHO to drive web visualisations of almost any kind of indicator stored in PHOLIO using an array of display techniques and statistical methods.

  4. Project deliverables 2011/12 • General Practice Profiles delivered in Fingertips • Developed and improved Fingertips platform and development environment • Improvements to APHO website to aid discovery of all PHO profiles (imminent) • Engaged with several PHO project teams to work towards Fingertips delivery

  5. DRAFT project brief 2012/13 • Continue to develop PHOLIO and Fingertips to efficiently deliver a growing suite of PHO profiles • Work with PHE partners to secure Fingertips as a future platform for product delivery • Establish future licensing options for Instant Atlas and develop ways to effectively use IA alongside Fingertips

  6. Current activity (May 2012) • Development environment • Access to code and servers for PHO developers • Standards for development, testing, deployment etc • Data management module • Access to PHOLIO for all PHO analysts • Maps • Migration of existing PHO tools • Tobacco control profiles • Sexual Health Balanced Scorecard • New tool for publication of PHOF dataset

  7. Benefits of Fingertips • EfficiencyIndicator data can be used in multiple outputs with no further calculation or QA required • ConsistencyThe same indicator is guaranteed to display the same data in all tools • Dynamic updatesWeb tools are automatically updated when indicator data are refreshed • AdaptabilityIndicators can be added or removed from tools using simple PHOLIO updates – no further web developer input required • SpeedPerformance for users is faster than other web-based tools such as Instant Atlas

  8. Fingertips - Charts • Tartan Rug • Funnel plot • Bar chart with confidence intervals • Spine chart • Time series with RAG dots • Time series with confidence intervals • Time series with inequality gap • Scatter plot • Population pyramid • Coming soon: • Maps

  9. Fingertips - Statistical Methods • CIs overlapping reference value • Overlapping CIs • SPC for proportions (binomial) • SPC for DSRs and crude rates (poisson) • Coming soon: • SPC time series runs • SPC time series trends • Time series trend

  10. Fingertips - Comparators • England • Region/SHA • 20% most deprived vs. rest (within area) • Coming soon: • ONS cluster for lower tier LAs and PCTs

  11. Fingertips – tartan rug

  12. Fingertips – spine chart

  13. Fingertips – funnel plot

  14. Fingertips – time trend

  15. Fingertips – inequalities

  16. Fingertips – metadata

  17. Fingertips – Practice Profiles

  18. Fingertips – user feedback the most user-friendly way of finding out information about the population I have seen to date. it’s really brilliant! impressed by the fingertips work, and hope to see this model of excellence in the holistic assessment informing every local JSNA and CCG commissioning decisions really useful information looks great

  19. Links Web:www.erpho.org.uk http://fingertips.erpho.org.uk http://www.apho.org.uk/pracprof/ Further questions or feedback: jo.watson@sph.nhs.uk

  20. Techie stuff • All of the data is held in SQL (PHOLIO) • Data is extracted and calculations carried out using C# (c-sharp) • Resulting data array is passed to the web software in a JSON (Jason) array – JavaScript Object Notation • Web visualisation is based on JavaScript and written using ASP.NET • We use a JavaScript charting library called HighCharts

More Related