About The Department
This Government department relies heavily on data to support its members and provide public services, but its data management system was prone to human error.
Planning was limited to large scale budget and forecast cycles, as repetitive and mundane tasks took the department’s staff away from more regular, high-value work.
The Requirement
- The department’s data models were based in Excel, which created issues with version control
- Sharing files over email and network share drives created security concerns and potential for file corruption
- Data sources for the models were not integrated, meaning manual updates and re-importing whenever source data changed
- Significant time was spent creating the data, which left little time to analyse it
“Reporting using systems that require the compilation of data from multiple sources that are not integrated is frustrating and challenging for financial close teams. Financial systems are always active with changing values, and the review process is constant. Updates and adjustments to systems that use offline reporting mechanisms such as Excel are a real headache, particularly during pivotal reporting cycles.”
Tony ButlerManaging Director, Decision Inc. Australia