Our client is a residential property developer that has built homes for thousands of people across Australia. Careful cost management of the construction process is essential to ensure profitable and timely delivery of each of their clients’ dream homes.
Gaining visibility over costs was challenging in an environment which was not traditionally data-centric, with multiple source systems that presented the same information in different ways. This made it difficult to understand the full cost of a job, the final margin on each sale and the impact on profitability due to changes made during the build process. Working with the data was very manual and significant effort was required to produce reporting, often with inconsistent results.
The client was using a number of technologies for reporting such as SQL Server Reporting Services (SSRS), QlikView and Power BI along with a SQL Server Integration Services (SSIS) and Database engine backend to try to attain the needed visibility. Over the years the data sources and reports had been developed on an ad-hoc basis without an overarching structure and strategy. This lead to a Data platform that was struggling to meet its intended objectives. We engaged with our client to review, recommend and then implement best practices for the entire process.