befree

Menu
Contact Sales
Menu

How we empowered a leading ESD consultation company to build a cohesive MIS

Client Overview

Our client is a leading Australian ESD consultancy based in Sydney with expertise in sustainability in the construction industry. They are working on some of the most exciting residential and commercial projects around the country.

Client Challenges

  • The client’s MIS was split in silos.
  • Consolidating and analyzing KPI data on a weekly basis across multiple departments was a manual and time-consuming process.

befree's Solution

  • befree’s database management expertise allowed swift consolidation of each data stream into a unified data model.
  • Raw data taken from the client’s preferred monitoring platform was put through an automated Extraction-Transformation-Loading process to generate the singular data model.
  • This meant that the employee payroll summary could now be downloaded and processed in groups pertaining to the relevant franchises that could easily be charged to the respective franchises as a unified transaction.
  • This made it possible to generate KPI reports from month-to-date through year-to-date across all departments in a dynamic and quick manner.
Greater Visibility due to consolidation and optimization of separate data streams into an MIS
Power to generate reports with running calculations across all departments.

70%

Reduction in processing time