The Department develops and manages policy areas of health service delivery, to ensure various health bodies across the state provide consistent, efficient and effective services.
Challenges and Business Objectives
The Department was producing a monthly dashboard report which was distributed to the Area Health Units and Health Corporate Executives. The report contained key financial and operational metrics by Budget Holder providing a comprehensive variance analysis of budget vs. actual together with the latest reforecast which were represented by a combination of tables and charts. The effort necessary to produce this document was considerable, the process was fragmented and largely manual involving a considerable number of spreadsheets, reports, many data extractions from multiple sources and a considerable amount of emailing of information between participants involved in the process.
I&A were subcontracted by Oracle Consulting Services to undertake a review of this process which set out the current state and a proposed a future state.