Transforming a construction company into the data driven world
Established visibility of hundreds of Global construction projects with the ability to drill through individual project spends, revenue, risks and status.
Established visibility of aggregation of the financial health of regions with rolled-up revenue, expenditure, wages and purchases.
Democratised actionable business insights for internal & external reporting
The customer is a multinational construction company with little global visibility of the health of both finances and building sites. The company was generating vast amounts of data regarding employees and contractors on work sites, but struggled in aggregation and joining siloed data across the globe.
The multinational construction company was looking to provide various teams and stakeholders across their global business a single centralised source for actionable information and insights. Relevant and timely metrics enable actionable, data driven decisions to be made which help drive operational and strategic direction.
Previously, data was extracted from various localised source systems and loaded into an on-prem data warehouse for each regional hub which in turn used their own BI/reporting solutions. In developing a global data insights strategy, the construction company wanted to first prove the capability by developing an initial use case – the Global Projects Insight Platform. This will provide executives and directors a consolidated global view of project status and metrics across their UK and Aus regional hubs.
The team worked closely with internal stakeholders and an internal PM using agile methodology to iterate on MVP’s. The project spanned across different time zones as part of the initial phase to understand the business in each region.
Old source systems and data silos would need careful consideration of extraction tooling so therefore we proposed using custom connectors to allow the client to control licensing costs as well as provide a lightweight extraction process.
In the end, we modernised the company’s data landscape in a very conservative and traditional industry to help the company become data driven.
- Designed and built a foundational Google Cloud data platform.
- A data pipeline was built of warehouse organisational data in a secure, reliable and cost efficient environment.
- Democratise actionable business insights for internal & external reporting
- Outlay a solid foundation for future applications of analytics and ML/AI on organisational data
Key Products/Services Used
- Cloud Run
- Compute Engine
- Cloud Build