Irish construction company Sisk relies on high and low-level reporting to monitor performance and progress across construction sites, teams, and the company as a whole. Sisk needed to reduce the manual preparation time required to produce the pack of monthly management reports, and to achieve ‘on demand’ reporting in certain areas of their business.
Codec provided a suite of services to Sisk, to assist with the development and implementation of its data strategy. This included formulation of data policies, specification of governance models, upskilling of Sisk personnel, and the design and implementation of a new data architecture.
Irish construction company Sisk relies on high and low-level reporting to monitor performance and progress across construction sites, teams, and the company as a whole. These reports are used to guide strategic decision-making at the board level. However, with increased scale and complexity in the business, the reporting preparation time had become onerous. Some of the key monthly management reports required 4 days of preparation, and Sisk needed to make these processes more efficient.
At the same time, Sisk believed its established processes for data aggregation and report analysis were integral to the organisation’s success. To transform its business analysis through digitised, automated and more timely reporting, the organisation understood this modern approach would be more efficient and valuable.
"Sisk leadership understood the importance and value of being a data-driven company, but Codec were instrumental in helping us set up and develop the infrastructure, governance and in-house capabilities that are the foundations to enable us to fully realise the value of data-driven decision making"
To determine the most beneficial approach to data reporting and aggregation, Codec’s consultants met with a wide range of teams across multiple levels within the business—including finance, health and safety and, pre-construction teams, as well as function leaders —with the purpose of understanding the diverse reporting needs faced by different units of the business.
Once those needs were understood, Codec began exploring different ways to address those data requirements within the capabilities of Azure Data. Along with a flexible data governance framework, Codec first designed a new data architecture for Sisk, and then proceeded with its implementation. Sisk wanted a high level of self-sufficiency for data management and data reporting, so Codec also assisted Sisk in developing their own capabilities and training their in-house data team.
Through the implementation of Azure Data Factory, Azure Data Lake, and Azure SQL Server for data warehousing purposes, Sisk is enabled to extract and model data with real-time visualisations and other reporting formats, resulting in reader-friendly KPI reports that can be quickly generated.
Through its partnership with Codec, Sisk was able to implement a defined data strategy that enhanced the organisation’s data reporting and analysis capabilities whilst providing a solid infrastructure for continued data project development into the future.
Other highlights of this transformation included:
"Codec has been our trusted adviser in this process. Their data consultants have experience from numerous projects, so they had the expertise to guide us on our data strategy, and they readily shared their knowledge to help with the upskilling of our internal team"
IT Enterprise Architect, Sisk Group