1 / 17

Brett Taylor PowerHealth Solutions 2008 Conference

Reporting Case Study. Brett Taylor PowerHealth Solutions 2008 Conference. 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?.

torgny
Download Presentation

Brett Taylor PowerHealth Solutions 2008 Conference

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related