SSRS to PowerBI Monica Jones TRFT Presentation to Apha Workshop - - PowerPoint PPT Presentation

▶

Sep 27, 2022 679 likes •925 views

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

SLIDE 1

The Spectrum of Analytical Tools: SSRS to PowerBI

TRFT Presentation to Apha Workshop Wed 21 March 2018

Monica Jones

Associate Director of Information Services

SLIDE 2

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

SLIDE 3

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 „digitisation‟
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

SLIDE 4

Strategic Digital Roadmap

The Strategic Digital Roadmap sets out a nine-point plan for realising our ambitions. This includes a five year plan to deliver:

Optimisation of Meditech and SystmOne to

enhance integrated patient administration, clinical documentation, order communications, ePrescribing and scheduling

Pilot integration of acute and community records
Shared clinical records using Rotherham Health

Record

Shared visual dashboards and reporting
Information management and analytics
New long-term clinical systems contracts (sustain or

replace Meditech/SystmOne)

Improved infrastructure („infrastructure as a service‟

– IAAS) and user-oriented organisation People Address „shared services‟ and refocus IM&T

rganisation around supporting users. Embed clinical

experience and data analytics to support service improvements (net headcount increase approx +10%) Financials

NHS operational pay spend benchmarks

indicates that at c1% we are spending less than norm

The TRFT LDR submission already includes

additional £12.3m of projects

Therefore total additional spend of c£16m

required (incl LDR projects)

There are central matched funds available which

should be accessed

There are long-term financial deal available from

suppliers

SLIDE 5

What is so difficult?

The Hobbit – An Unexpected Journey (J.R.R. Tolkien)

" “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;

r that it is a morning to be good on?"

"All of them at once," said Bilbo”

SLIDE 6

TRFT Priorities

 Optimize our Electronic Patient Record(s)  Enhance Rotherham Health Record  Infrastructure  Information  Financial Sustainability

SLIDE 7

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.
ne 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!)

SLIDE 8

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
ther 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.

SLIDE 9

Making information, data and insights available

Pre-prepared reports (SRSS)
Self Service via MS Excel + CUBEs
ED, Outpatient, Inpatients
Theatres
Community
Visualisation using PowerBI

Excel & Power BI Sharepoint (catalog, index, IPR etc. etc.) Data warehouse – single version of the “truth” with pre-built measures and calculations Information input, quality, validation & assurance

SLIDE 10

SLIDE 11

SLIDE 12

SLIDE 13