Construction Case Study: Nordic’s Leading Construction Company

Nordic’s Leading Construction Company

Use Case

Hazard Identification

Geography

Nordic Region

Problem

Challenges in managing Hazard Identification and Risk Assessment

Industry

Manufacture

Hazard Identification and Risk Assessment with GenAI (HIRA)

Migrating 500+ Legacy pipelines under a Tight Deadline

In the construction industry, ensuring workplace safety is paramount. A leading Nordic construction company faced challenges in managing Hazard Identification and Risk Assessment (HIRA) data across multiple sites. The data was dispersed across numerous Excel spreadsheets, leading to difficulties in navigation and effective analysis.

30%

More transparency in the sites’ risks

25%

Time was reduced to search for data within a single factory

50%

More safety measure against high-risks situations

Technology

Before Databricks Implementation

The company struggled with fragmented HIRA data stored in various spreadsheets, hindering efficient data analysis and risk assessment.

After Databricks Implementation

By leveraging the Databricks Lakehouse Platform, the company developed a robust methodology to gather, consolidate, and transform HIRA data from numerous spreadsheets, ensuring seamless analytics and improved decision-making capabilities. This unified approach enabled real-time data processing and analysis, enhancing the accuracy and efficiency of risk assessments.

Business Challenge

Calibrating risk scores became a formidable challenge due to the dispersion of data across multiple sites, complicating the process of risk assessments. Furthermore, the lack of strategic allocation of capital expenditure investments for hazard control eroded confidence in decision-making processes.

Impact

The implementation of Databricks led to significant improvements:

30% Increase in Transparency:Enhanced visibility into site-specific risks allowed for more proactive management and mitigation strategies.
25% Reduction in Data Search Time:Streamlined data consolidation reduced the time required to locate and analyse information within a single factory.
50% Enhancement in Safety Measures:Improved data analysis facilitated the identification of high-risk situations, leading to more effective safety interventions.

Moreover, the company benefited from implementing mitigation actions gleaned from other plants, fostering a culture of continuous improvement throughout the organization. The enhanced capability to search for data within individual factories and across multiple facilities not only bolstered efficiency but also promoted collaboration among teams.

By integrating Databricks into their operations, the company transformed its HIRA processes, leading to a safer and more efficient working environment.

Logistics Case Study: Transitioning from Legacy Systems to Databricks Lakehouse Architecture