The Spectrum of Analytical Tools: SSRS to PowerBI Monica Jones TRFT Presentation to Apha Workshop Associate Director of Information Wed 21 March 2018 Services
Rotherham Health Informatics A fully co-terminus health and social care • community with a population of c260,000 „Medium‟ DGH + community. 4,200 staff, • £240M pa Rural with Industrial Centre • Lowest internet usage - ONS 2016 • Shared Health Informatics Service •
The NHS information management and technology (digital) strategic landscape has shifted: • The focus in digital planning has shifted from trusts to the local health community, Sustainability and Transformation Partnerships (STPs) leading to Integrated Care Systems (ICS) • The national agenda has changed from technology to „ digitisa tion‟ • The Wachter Report to NHS England endorsed this and led to 12 Trusts being appointed „ Global Digitisation Champions ‟ attracting matched funding up to £10m • Trust-based systems are still critical in driving a paper-lite NHS agenda for the 2020 ‟ s • There is an increased awareness of CyberSecurity threats to the NHS Over the past 10 years the Trust has implemented and developed core mission-critical patient systems around Meditech (Acute) and SystmOne (Community). TRFT has implemented SNOMED CT. The Trust has also developed a successful Rotherham-wide information sharing system in the Rotherham Health Record . There are experienced and innovative individuals in the IM&T function and the Trust has invested in digital leadership and technology. The vision for Informatics is to be ‘digital by default’ and be a lead in providing integrated digital services for the Trust, supporting integrated care in the local health community and beyond. Strategic Digital Roadmap 3 February 2017
Strategic Digital Roadmap People The Strategic Digital Roadmap sets out a nine-point Address „shared servic es‟ and refocus IM&T plan for realising our ambitions. organisation around supporting users. Embed clinical This includes a five year plan to deliver: experience and data analytics to support service improvements (net headcount increase approx +10%) • Optimisation of Meditech and SystmOne to enhance integrated patient administration, clinical documentation, order communications, Financials ePrescribing and scheduling • NHS operational pay spend benchmarks • Pilot integration of acute and community records • Shared clinical records using Rotherham Health indicates that at c1% we are spending less than norm Record • The TRFT LDR submission already includes • Shared visual dashboards and reporting • Information management and analytics additional £12.3m of projects • Therefore total additional spend of c£16m • New long-term clinical systems contracts (sustain or required (incl LDR projects) replace Meditech/SystmOne) • There are central matched funds available which • Improved infrastructure („in frastructure as a servic e‟ – IAAS) and user-oriented organisation should be accessed • There are long-term financial deal available from suppliers 4
What is so difficult? " “Good Morning!" said Bilbo, and he meant it. The sun was shining, and the grass was very green. But Gandalf looked at him from under long bushy eyebrows that stuck out further than the brim of his shady hat. "What do you mean?" he said. "Do you wish me a good morning, or mean that it is a good morning whether I want it or not; or that you feel good this morning; or that it is a morning to be good on?" "All of them at once," said Bilbo ” The Hobbit – An Unexpected Journey (J.R.R. Tolkien) 5
TRFT Priorities Optimize our Electronic Patient Record(s) Enhance Rotherham Health Record Infrastructure Information Financial Sustainability
Who we are and what we do … 1 • Healthcare Systems generate a huge amount of data. This needs to be captured, processed, stored, checked, updated, reported and analysed. This takes a lot „data wrangling‟ to turn into the „right information, for the right purpose at the right time‟ Statutory Returns – The Trust is required to report to the Centre (DH, NHS • Digital, NHS England and NHS Improvement) all our monthly activity returns. These are called Commissioning Datasets (CDS) and take approx. one week every month to generate, check, update and submit National Outcomes Framework – there are many mandatory care and • quality standards that must be submitted such as 4 hour A&E, 18 week RRT, Cancer waits and many more (over 370 individual UNIFY returns!)
Who we are, what we do … 2 Things we do for our TRFT and other NHS colleagues – we produce bespoke • reports and dashboards for internal decision making such as the Integrated Performance Report (IPR) for board, divisional reports, service reports, CQUINs and other commissioning / contractual reports Things we do to keep the information machines running – Working closely with • other Health Informatics colleagues we have to keep all the systems up to date at all times. This requires full service line support and change control Data quality – as we have an Electronic Patient Record (EPR) we rely on the • correct information being recorded by clinical colleagues. This is their professional duty as defined by Royal Colleges / Societies. They don‟t always get it right so this must be checked and updated through the DQ process.
Making information, data and insights available Excel & • Pre-prepared reports (SRSS) Power BI • Self Service via MS Excel + CUBEs Sharepoint (catalog, index, • ED, Outpatient, Inpatients IPR etc. etc.) Data warehouse – single • Theatres version of the “truth” with pre-built measures and • Community calculations Information input, quality, validation & assurance • Visualisation using PowerBI
Our move from Information to Analytics to Insight
Our move from Information to Analytics to Insight Visualisation (http://www.storytellingwithdata.com/ - Cole Nussbaumer Knaflic) Data Sources including access to live systems Platform agnostic Business fit Auditability Anytime, Anywhere „Martini‟ access Affordability £££…
Our move from Information to Analytics to Insight Office 365 AD Connector Information Governance and Security PBI Desktop deployment Super Users – Service and Clinical Licensing ... PBI Pro / Free trial / Premium Partner to operationalise
Our move from Information to Analytics to Insight Ease of use & setup (admin and users) Everyone is an analyst Speed of development Instant share in / out Price v value Mobility and Accessibility
Our move from Information to Analytics to Insight Informatics adoption + Culture Not everyone wants to be an analyst Expectation bar has been raised Pro licenses for everyone … Data warehouse – shift from OLAP to Tabular (significant improvement in performance)
Our move from Information to analytics to insight
Our move from Information to analytics to insight PBI Introduced
Our move from Information to analytics to insight
Any questions or feedback? Monica Jones – Associate Director of Information Services monica.jones@nhs.net +44 (0) 7876 403693
Recommend
More recommend
