210 likes | 410 Views
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.
E N D
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 • 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
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.
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
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
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
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
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
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
Fingertips - Comparators • England • Region/SHA • 20% most deprived vs. rest (within area) • Coming soon: • ONS cluster for lower tier LAs and PCTs
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
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
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