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.

Results

This review document provided an analysis of Current State incorporating a process flow analysis by working day and the proposed Future State which was predicated on replacing many of the spreadsheets and associated processes with an Oracle based solution comprising elements of the Hyperion suite together with Oracle’s business intelligence solution, Oracle Business Intelligence Enterprise Edition (OBIEE).