Challenges

• Consolidate financial and nonfinancial 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 nonclinical expenses, such as administration, catering, cleaning, utilities, and estate management, and enable analyzing multiperiod 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 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 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

Why Oracle

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,” said Robert Angel, Assistant Director of Finance, Leeds Teaching Hospitals NHS Trust.

Resources

• Oracle BI Delivers Insight at Leeds Teaching Hospital