Brett Taylor PowerHealth Solutions 2008 Conference

1. Reporting Case Study Brett TaylorPowerHealth Solutions2008 Conference

2. Agenda • Organisational Overview/Requirements • What We Need • Previous State • Business Requirement • Business Solution • What Changed? • In-house Requirements/Costs • Process and Integration • Where to Next?

3. Organisational Overview • Australia’s largest specialist hospital dedicated to improving the health of all women and newborn babies • 220 beds • Over 30,000 admissions each year • 2,500 FTEs • Victorian Government recently split the Women’s and Children’s Hospital components which instigated an internal review of all reporting.

4. Requirements • As prescribed by the Health Services Act 2004, the RWH as a public health service is required to: • Develop financial and business plans, strategies and budgets to ensure accountable and efficient provision of health services by the public health service and the long-term financial viability of the public health service • Monitor the performance of the public health service.

5. Requirements • In performing its functions as a public health service must have regard to the need to ensure that: • The public health service uses its resources in an effective and efficient manner • Resources of the Victorian public health sector generally are used effectively and efficiently.

6. What We Need We need to improve performance/delivery strategy To do this we need: • Information not data • Information that is widely accessible • Information that is consistent area wide • Information that provides insight • Alignment of measurement to strategy.

7. Previous State • Some information, a lot of data • Inadequate reporting and business intelligence • High level of manual compilation • Emailed reports • Some inconsistent information leading to inconsistent conclusions • Willingness to develop, evolve, improve.

8. Business Requirement RWHFinancial & Workforce Information Reporting • Cost Centre Financials • Financials by Period • Actual vs Budget FTE • Cost Centre Payroll Enquiry • Employee payroll Enquiry • Monthly Payroll by pay run • Workforce Information Trend .

9. Business Requirement • Sort, group and total data • Users can insert columns & groupings with standard reports • Export results to Excel for further analysis & manipulation • Similar “look & feel” to existing RWH intranet applications • Drilldown capabilities ― doubleclick on a value to see what transactions make up the value • Centralised systems administration ― allocate access to specific information and reporting options • Flexible solution ― allow RWH staff to modify reports and the underlying data structures • Easy to learn.

10. Business Solution • Design and Specification • Data Source Creation • Report Development – Crystal Reports • Report Delivery – Executive Reporting

11. End Users Reporting Database Business Solution Project Scope OLAP Reporting Interactive Reporting Environment Receive & validate data Data Availability Existing Data Source ExecutiveReporting Historical payroll data Periodic financial reporting DigitalDashboard

12. Business Solution • Report AdministrationExecutive Reporting • User Management and SecurityCentral Reporting Services • Installation/Configuration • Training

13. Cost Centre Financials Report

14. What Changed? • Less processing • More time for analysis • Focus on key areas of improvement • Electronic notification of updates • More people able to access reports • Improved timeliness • Security of information.

15. Inhouse Requirements/Costs • Skills in crystal reporting and SQL • Dedicated server • Dedicated staff member to develop reporting suite for up to 12 months Offset by • Savings in staff time to process • Savings in report preparation & dissemination • Less likelihood of manual errors

16. Where to Next? • Further Report Development • Cube development and OLAP reporting • Digital Dashboard and KPIs

17. Questions Thank You