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