CONSULTING
SOLUTIONS
PARTNERS
RESOURCES
CORPORATE
Twitter Facebook LinkedIn
Email [email protected]
Phone +1 713.457.7474

Oracle BI Enterprise edition solution for UK Based Leeds Teaching Hospitals

NWS

Leeds Teaching Hospitals NHS Trust Builds Budget Reports Six Times Faster, Achieves 100% ROI in 12 Months

CUSTOMER:

Leeds Teaching Hospitals National Health Service (NHS) Trust is one of the largest hospital systems in the United Kingdom and includes Europe’s largest teaching hospital. The trust provides acute services for the population of Leeds; is a regional center for specialist services, including cancer and cardiac surgery; and treats more than 1 million patients each year.

CUSTOMER QUOTE:

“Oracle Business Intelligence Enterprise Edition enabled us to move to a balanced scorecard approach for strategy management and planning. The insights it provides will be critical to our ability to identify where we can make operational savings of US$33 million each year for the next four years while continuing to deliver excellent quality healthcare to the public”

Robert Angel, Assistant Director of Finance, Leeds Teaching Hospitals NHS Trust

CHALLENGES

Consolidate financial and non-financial clinical and corporate data from all hospital departments into balanced scorecards to monitor performance against national and local indicators, deliver timely and accurate statistical returns to the Department of Health and central NHS, and achieve near 100% accuracy for strategic planning

Allow senior clinicians in radiology, neurology, oncology, trauma, orthopedics, pathology and analysts to access and interrogate real-time cost and performance statistics for the medical procedures carried out by their departments, identify the cost of each patient episode, and compare costs and outcomes between departments

Enable hospital managers to drill down into financial data on both clinical spend and non-clinical expenses, such as administration, catering, cleaning, utilities, and estate management, and enable analyzing multi period extracts of expenses in each area and identifying variances against the plan

Minimize training requirements for nontechnical medical and administrative staff and deliver new analytical and reporting capabilities at the speed of user and business demand

Meet government target of saving US$33 million for the next four years without negatively impacting critical factors, such as the availability of beds, wait times for appointments with consultants, timeliness of operations, and the quality of patient care

Solutions

Used Oracle Business Intelligence Enterprise Edition to deliver personalized budget and Leeds Teaching Hospitals NHS Trust

Nominal roll reports via monthly dashboard e-mails, delivering extensive management reports to 750 clinical and nonclinical cost center managers from all disciplines

Enabled Corporate Finance to see individual transactions in just a few clicks, using Oracle Business Intelligence Answers to drill down from high-level summary to journal and subledger details, accessing scanned-in invoices from links embedded in the dashboard e-mail

Enabled all budget holders to render up to eight reports simultaneously on a single page in approximately three seconds, a process that took up to six minutes with the legacy system and involved opening multiple workbooks Gained immediate adoption from previously resistant users who gained competency with minimal training

Leveraged Oracle Business Intelligence Enterprise Edition’s intuitive development tools so key users could build new reports, meeting rapidly expanding user demand in 5 to 30 minutes instead of three to four hours using legacy tools

Used drag-and-drop functionality to feed quarterly balance sheet statements and statistics from the enterprise resource planning (ERP) system and other sources into Oracle Business Intelligence Enterprise Edition

Conducted rapid modeling of complex data to compile balanced scorecards

Benefited from Oracle Business Intelligence Answers to shift the focus from extracting data to gaining timely business knowledge

Studied period-on-period comparisons and analyzed price and volume element variances to assist forecasting and future planning with 99.9% accuracy for outturn projections based

Benefited from Oracle Business Intelligence Answers to shift the focus from extracting data to gaining timely business knowledge

Studied period-on-period comparisons and analyzed price and volume element variances to assist forecasting and future planning with 99.9% accuracy for outturn projections based on half yearly figures when tested on historic data over a three-year period

Conducted detailed spend analyses to determine how best to achieve US$33 million annual savings while minimizing impact on front-line services

Gained 100% payback on investment in Oracle Business Intelligence Enterprise Edition within 12 months, an outstanding achievement for a complex and large-scale solution

Progressed with Oracle Business Intelligence Delivers roll out to provide budget holders with automated e-mail alerts if KPI thresholds were being exceeded, facilitating exception-based management

Committed to further roll out of Oracle Business Intelligence Enterprise Edition to all hospital departments within two years

Leeds Teaching Hospitals National Health Service Trust chose Oracle over alternative business intelligence solutions for its unrivalled functionality and scalability and because it could extract data from multiple sources without manual intervention.

“The leading competitor tools that we evaluated could not offer automated data extraction. It would have taken an IT team member around one-and-a-half days per month to manually extract the data into spreadsheets and load it into the solution for analysis with alternative solutions. Or we would have been looking at solutions where revenue costs increased with each step change in functionality or data refresh,” Robert Angel, Assistant Director of Finance, Leeds Teaching Hospitals NHS Trust.

email [email protected]
phone +1 713.457.7474
Twitter Facebook LinkedIn
© PREDICTif Solutions. All rights reserved.