Highlights
- Designed and built a foundational Google Cloud data platform.
- Created a data pipeline of warehouse organisational data in a secure, reliable, and cost-efficient environment.
- Democratised actionable business insights for internal & external reporting.
- Laid a solid foundation for future applications of analytics and ML/AI on organisational data.
The Problem
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 Opportunity
The construction company saw an opportunity to develop a global data insights strategy that would provide them with a distinct competitive edge in a typically conservative industry. They wanted to first prove the capability by developing an initial use case – the Global Projects Insight Platform. This platform would provide executives and directors a consolidated global view of project status and metrics across their UK and Aus regional hubs.
The Solution
The solution was a comprehensive, centralised data platform built on Google Cloud.
This platform served as a single source of actionable information and insights for various teams and stakeholders across the multinational construction company’s global business. It provided a consolidated global view of project status and metrics across their UK and Australian regional hubs, enabling data-driven decision-making that could help drive operational and strategic direction.
The solution also included a secure and reliable data pipeline for organising the company’s data. As a result, it democratised actionable business insights for internal and external reporting, making important information more accessible. The platform laid a solid foundation for future applications of analytics and machine learning/artificial intelligence on organisational data, opening up opportunities for further innovation and efficiency in the company’s operations.
The benefits of this solution are as follows:
- Centralised Data Source: The solution provided a single, centralised source for actionable information and insights, enabling various teams and stakeholders across the global business to make data-driven decisions. This improved the operational and strategic direction of the company.
- Global Visibility: The Global Projects Insight Platform provided executives and directors a consolidated global view of project status and metrics across their UK and Aus regional hubs. This increased visibility helped in better project management and decision-making.
- Cost Efficiency: The use of custom connectors allowed the client to control licensing costs and provided a lightweight extraction process, making the solution cost-efficient.
- Foundation for Future Applications: The solution laid a solid foundation for future applications of analytics and machine learning/artificial intelligence on organisational data. This opens up opportunities for further innovation and efficiency in the company’s operations.
As a result, the subscription program’s new brand and associated benefits were successfully established in a frictionless and intentional manner, effectively encouraging users to sign up without compromising the current user experience of each individual retail brand.
Our Approach
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 Mantel Group proposed using custom connectors to allow the client to control licensing costs as well as provide a lightweight extraction process.
In the end, Mantel Group modernised the company’s data landscape in a very conservative and traditional industry to help the company become data driven.
