Grafik 13
013 The more tools, the more efficient the business
10 June 2025
image63
015 Duplication, and lack of data quality as a consequence of disunity
10 June 2025

014 Data silos and their impact on company performance

Imagine that you are building a residential complex, but each team has its own project. Some are building walls, others are laying communications, and others are paving roads without checking with each other. As a result, the pipes do not match the openings in the walls, the elevator shafts do not correspond to the storeys, and the roads have to be dismantled and re-laid.

This situation is not just a hypothetical scenario, but a reality of many modern construction projects. Due to the large number of general and subcontractors working with different systems and without a single coordinating center, the process turns into a series of endless approvals, rework and conflicts. All of this leads to significant delays and multiple project costs.

A classic situation on a construction site is a simple one: the formwork is ready, but the delivery of reinforcement has not arrived on time. When checking information in various systems, the communication is roughly as follows:

The foreman at the construction site on the 20th writes to the project manager, “We finished setting the formwork, where are the rebar?”

Project Manager (PMIS) to the Procurement Department: – “The formwork is ready. In my [PMIS] system, the rebar was supposed to arrive on the 18th. Where are the rebar?”

Supply Chain Specialist (ERP): – “Our ERP says delivery will be on the 25th”

Data Engineer or IT (responsible for integrations): – “In PMIS the date is on the 18th, in ERP it is on the 25th. There is no OrderID link between ERP and PMIS, so the data is not synchronized. This is a typical example of an information gap“.

Project manager to general director – “The delivery of fittings is delayed, the site is standing, and who is responsible is unclear”.

The cause of the incident was the isolation of data in disparate systems. By integrating and unifying data sources, creating a single repository of information, and automating through ETL – tools (Apache NiFi, Airflow, or n8n), the silos between systems can be eliminated. These and other methods and tools will be discussed in detail in later sections of the book.

Рисунок 6
Fig. 2.1-3 Comparison of planned and actual costs of major infrastructure projects in Germany.

It’s the same with enterprise systems: first you create isolated solutions, and then you have to spend huge budgets to integrate and harmonize them. If data and communication models had been thought through from the start, there would be no need for integration at all. Siloed data creates chaos in the digital world, like an uncoordinated construction process.

According to KPMG’s 2023 study “Cue construction 4.0: Time to make or break”, only 36% of companies share data effectively across departments, while 61% face serious problems due to isolated data “silos” (KPMG, “Cue Construction 4.0: Make-or-Break Time,” 1 Jan. 2023).

Рисунок 6
Fig. 2.1-4 Years of hard-to-collect data accumulate in isolated storage “silos” at the risk of never being used.

Company data is stored in isolated systems, like individual trees scattered across the landscape. Each contains valuable information, but the lack of connections between them prevents the creation of a single, interconnected ecosystem. This siloing hinders the flow of data and limits the organization’s ability to see the full picture. Connecting these silos is an extremely long and complex process of growing mushroom mycelium at the management level to learn how to transfer individual pieces of information between systems.

According to a 2016 WEF study, one of the main barriers to digital transformation is the lack of common data standards and fragmentation.

The construction industry is one of the most fragmented in the world and depends on the smooth interaction of all participants in the value chain (W. E. Forum, “Forum Shaping the Future of Construction – A Landscape in Transformation:,” January 1, 2016).

– World Economic Forum Report “Shaping the Future of Construction”

Designers, managers, coordinators and developers often prefer to work autonomously, avoiding the complexities of coordination. This natural inclination leads to the creation of information “silos” in which data is isolated within separate systems. The more such isolated systems there are, the more difficult it is to get them to work together. Over time, each system gets its own database and a specialized support department of managers (Fig. 1.2-4), further complicating integration.

Рисунок 7
Fig. 2.1-5 Each system aims to create its own unique silo of data that needs to be processed by suitable tools (И. Deininger, B. Koch, R. Bauknecht, and M. Langhans, “Using digital models for decarbonizing a production site: An example of connecting a building model, a production model, and an energy model,” 2024).

The vicious circle in corporate systems looks like this: companies invest in complex iso customized solutions, then face high costs for their integration, and developers, realizing the complexity of combining systems, prefer to work in their closed ecosystems. All this increases the fragmentation of the IT landscape and makes it more difficult to migrate to new solutions (Fig. 2.1-5). Managers end up criticizing data silos, but rarely analyze their causes and how to prevent them. Managers complain about outdated IT systems, but replacing them requires significant investment and rarely yields the expected results. As a result, even attempts to combat the problem often make matters worse.

The main reason for the disconnect is the prioritization of applications over data. Companies first develop separate systems or buy off-the-shelf solutions from vendors, and then try to unify them by creating duplicate and incompatible storage and databases.

Overcoming the problem of fragmentation requires a radical new approach – prioritizing data over applications. Companies must first develop data management strategies and data models, and then build systems or purchase solutions that work with a single set of information rather than creating new barriers.

We are entering a new world where data may be more important than software.

– Tim O’Reilly, CEO of O’Reilly Media, Inc.

McKinsey Global Institute’s study “Rethinking Construction: the path to improved productivity” (2016) demonstrates that the construction industry lags behind other sectors in digital transformation (McKinsey, “REINVENTING CONSTRUCTION: A ROUTE TO HIGHER PRODUCTIVITY,” February 1, 2017). According to the report, the adoption of automated data management and digital platforms can significantly improve productivity and reduce losses associated with process inconsistency. This need for digital transformation is also emphasized by Egan’s (UK, 1998) report (Construction Task Force to the Deputy Prime Minister, “Rethinking Construction,” 1 October 2014), which highlights the key role of integrated processes and a collaborative approach in construction.

As a result, while in the last 10,000 years the main problem for data managers has been a lack of data, with the avalanche of data and data management systems, users and managers are faced with a problem – an overabundance of data, making it difficult to find legally correct and quality information.

Disparate data silos inevitably lead to the serious problem of reduced data quality. With multiple independent systems, the same data can exist in different versions, often with conflicting values, creating additional complexity for users who need to determine which information is relevant and reliable.

.

Leave a Reply

Change language

Post's Highlights

Stay updated: news and insights



We’re Here to Help

Fresh solutions are released through our social channels

UNLOCK THE POWER OF DATA
 IN CONSTRUCTION

Dive into the world of data-driven construction with this accessible guide, perfect for professionals and novices alike.
From the basics of data management to cutting-edge trends in digital transformation, this book
will be your comprehensive guide to using data in the construction industry.

Related posts 

Focus Areas

navigate
  • ALL THE CHAPTERS IN THIS PART
  • A PRACTICAL GUIDE TO IMPLEMENTING A DATA-DRIVEN APPROACH (8)
  • CLASSIFICATION AND INTEGRATION: A COMMON LANGUAGE FOR CONSTRUCTION DATA (8)
  • DATA FLOW WITHOUT MANUAL EFFORT: WHY ETL (8)
  • DATA INFRASTRUCTURE: FROM STORAGE FORMATS TO DIGITAL REPOSITORIES (8)
  • DATA UNIFICATION AND STRUCTURING (7)
  • SYSTEMATIZATION OF REQUIREMENTS AND VALIDATION OF INFORMATION (7)
  • COST CALCULATIONS AND ESTIMATES FOR CONSTRUCTION PROJECTS (6)
  • EMERGENCE OF BIM-CONCEPTS IN THE CONSTRUCTION INDUSTRY (6)
  • MACHINE LEARNING AND PREDICTIONS (6)
  • BIG DATA AND ITS ANALYSIS (5)
  • DATA ANALYTICS AND DATA-DRIVEN DECISION-MAKING (5)
  • DATA CONVERSION INTO A STRUCTURED FORM (5)
  • DESIGN PARAMETERIZATION AND USE OF LLM FOR CAD OPERATION (5)
  • GEOMETRY IN CONSTRUCTION: FROM LINES TO CUBIC METERS (5)
  • LLM AND THEIR ROLE IN DATA PROCESSING AND BUSINESS PROCESSES (5)
  • ORCHESTRATION OF ETL AND WORKFLOWS: PRACTICAL SOLUTIONS (5)
  • SURVIVAL STRATEGIES: BUILDING COMPETITIVE ADVANTAGE (5)
  • 4D-6D and Calculation of Carbon Dioxide Emissions (4)
  • CONSTRUCTION ERP AND PMIS SYSTEMS (4)
  • COST AND SCHEDULE FORECASTING USING MACHINE LEARNING (4)
  • DATA WAREHOUSE MANAGEMENT AND CHAOS PREVENTION (4)
  • EVOLUTION OF DATA USE IN THE CONSTRUCTION INDUSTRY (4)
  • IDE WITH LLM SUPPORT AND FUTURE PROGRAMMING CHANGES (4)
  • QUANTITY TAKE-OFF AND AUTOMATIC CREATION OF ESTIMATES AND SCHEDULES (4)
  • THE DIGITAL REVOLUTION AND THE EXPLOSION OF DATA (4)
  • Uncategorized (4)
  • CLOSED PROJECT FORMATS AND INTEROPERABILITY ISSUES (3)
  • MANAGEMENT SYSTEMS IN CONSTRUCTION (3)
  • AUTOMATIC ETL CONVEYOR (PIPELINE) (2)

Search

Search

057 Speed of decision making depends on data quality

Today’s design data architecture is undergoing fundamental changes. The industry is moving away from bulky, isolated models and closed formats towards more flexible, machine-readable structures focused on analytics, integration and process automation. However, the transition...

060 A common language of construction the role of classifiers in digital transformation

In the context of digitalization and automation of inspection and processing processes, a special role is played by classification systems elements – a kind of “digital dictionaries” that ensure uniformity in the description and parameterization...

061 Masterformat, OmniClass, Uniclass and CoClass the evolution of classification systems

Historically, construction element and work classifiers have evolved in three generations, each reflecting the level of available technology and the current needs of the industry in a particular time period (Fig. 4.2-8): First generation (early...

Don't miss the new solutions

 

 

Linux

macOS

Looking for the Linux or MAC version? Send us a quick message using the button below, and we’ll guide you through the process!


📥 Download OnePager

Welcome to DataDrivenConstruction—where data meets innovation in the construction industry. Our One-Pager offers a concise overview of how our data-driven solutions can transform your projects, enhance efficiency, and drive sustainable growth. 

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DDC terms of use 

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

DataDrivenConstruction offers workshops tested and practiced on global leaders in the construction industry to help your team navigate and leverage the power of data and artificial intelligence in your company's decision making.

Reserve your spot now to rethink your
approach to decision making!

Please enable JavaScript in your browser to complete this form.

 

🚀 Welcome to the future of data in construction!

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

Have a question or need more information? Reach out to us directly!
Schedule a time to discuss your needs with our team.
Tailored sessions to help your team grow — let's plan together!
Have you attended one of our workshops, read our book, or used our solutions? Share your thoughts with us!
Please enable JavaScript in your browser to complete this form.
Name
Data Maturity Diagnostics

🧰 Data-Driven Readiness Check

This short assessment will help you identify your company's data management pain points and offer solutions to improve project efficiency. It takes only 1–2 minutes to complete and you will receive personalized recommendations tailored to your needs.

🚀 Goals and Pain Points

What are your biggest obstacles today — and your goals for the next 6 months? We’ll use your answers to build a personalized roadmap.

Build your automation pipeline

 Understand and organize your data

Automate your key process

Define a digital strategy

Move from CAD (BIM) to databases and analytics

Combine BIM, ERP and Excel

Convince leadership to invest in data

📘  What to Read in Data-Driven Construction Guidebook

Chapters 1.2, 4.1–4.3 – Technologies, Data Conversion, Structuring, Modeling:

  • Centralized vs fragmented data

  • Principles of data structure

  • Roles of Excel, DWH, and databases

Chapters 5.2, 7.2 – QTO Automation, ETL with Python:

  • Data filtering and grouping

  • Automating QTO and quantity takeoff

  • Python scripts and ETL logic

Chapter 10.2 – Roadmap for Digital Transformation:

  • Strategic stages of digital change

  • Organizational setup

  • Prioritization and execution paths

Chapters 4.1, 8.1–8.2 – From CAD (BIM) to Storage & Analytics:

  • Translating Revit/IFC to structured tables

  • BIM as a database

  • Building analytical backends

Chapters 7.3, 10.2 – Building ETL Pipelines + Strategic Integration:

  • Combining Excel, BIM, ERP

  • Automating flows between tools

  • Connecting scattered data sources

Chapters 7.3, 7.4 – ETL Pipelines and Orchestration (Airflow, n8n):

  • Building pipelines

  • Scheduling jobs

  • Using tools like Airflow or n8n to control the flow 

Chapters 2.1, 10.1 – Fragmentation, ROI, Survival Strategy:

  • Hidden costs of bad data

  • Risk of inaction

  • ROI of data initiatives

  • Convincing stakeholders

Download the DDC Guidebook for Free

 

 

🎯 DDC Workshop That Solves Your Puzzle

Module 1 – Data Automation and Workflows in Construction:
  • Overview of data sources
  • Excel vs systems
  • Typical data flows in construction
  • Foundational data logic

Module 3 – Automated Data Processing Workflow:
  • Setting up ETL workflows
  • CAD/BIM extraction
  • Automation in Excel/PDF reporting

Module 8 – Converting Unstructured CAD into Structured Formats 
  • From IFC/Revit to tables
  • Geometric vs semantic data
  • Tools for parsing and transforming CAD models

Module 13 – Key Stages of Transformation 
  • Transformation roadmap
  • Change management
  • Roles and responsibilities
  • KPIs and success metrics

Module 8 – Integrating Diverse Data Systems and Formats
  • Excel, ERP, BIM integration
  • Data connection and file exchange
  • Structuring hybrid pipelines

Module 7 – Automating Data Quality Assurance Processes 
  • Rules and checks
  • Dashboards
  • Report validation
  • Automated exception handling

Module 10 – Challenges of Digitalization in the Industry 
  • How to justify investment in data
  • Stakeholder concerns
  • ROI examples
  • Failure risks

💬 Individual Consultation – What We'll Discuss

Audit of your data landscape 

We'll review how data is stored and shared in your company and identify key improvement areas.

Select a process for automation 

We'll pick one process in your company that can be automated and outline a step-by-step plan.

Strategic roadmap planning 

Together we’ll map your digital transformation priorities and build a realistic roadmap.

CAD (BIM) - IFC/Revit model review 

We'll review your Revit/IFC/DWG data and show how to convert it into clean, structured datasets.

Mapping integrations across tools 

We’ll identify your main data sources and define how they could be connected into one workflow.

Plan a pilot pipeline (PoC) 

We'll plan a pilot pipeline: where to start, what tools to use, and what benefits to expect.

ROI and stakeholder alignment 

📬 Get Your Personalized Report and Next Steps

You’ve just taken the first step toward clarity. But here’s the uncomfortable truth: 🚨 Most companies lose time and money every week because they don't know what their data is hiding. Missed deadlines, incorrect reports, disconnected teams — all symptoms of a silent data chaos that gets worse the longer it's ignored.

Please enter your contact details so we can send you your customized recommendations and next-step options tailored to your goals.

💡 What you’ll get next:

  • A tailored action plan based on your answers

  • A list of tools and strategies to fix what’s slowing you down

  • An invite to a free 1:1 session to discuss your case

  • And if you choose: a prototype (PoC) to show how your process could be automated — fast.

Clean & Organized Data

Theoretical Chapters:

Practical Chapters:

What You'll Find on
DDC Solutions:

  • CAD/BIM to spreadsheet/database converters (Revit, AutoCAD, IFC, Microstation)
  • Ready-to-deploy n8n workflows for construction processes
  • ETL pipelines for data synchronization between systems
  • Customizable Python scripts for repetitive tasks
  • Intelligent data validation and error detection
  • Real-time dashboard connectors
  • Automated reporting systems

Connect Everything

Theoretical Chapters:

Practical Chapters:

What You'll Find on
DDC Solutions:

  • CAD/BIM to spreadsheet/database converters (Revit, AutoCAD, IFC, Microstation)
  • Ready-to-deploy n8n workflows for construction processes
  • ETL pipelines for data synchronization between systems
  • Customizable Python scripts for repetitive tasks
  • Intelligent data validation and error detection
  • Real-time dashboard connectors
  • Automated reporting systems

Add AI & LLM Brain

Theoretical Chapters:

Practical Chapters:

What You'll Find on
DDC Solutions:

  • CAD/BIM to spreadsheet/database converters (Revit, AutoCAD, IFC, Microstation)
  • Ready-to-deploy n8n workflows for construction processes
  • ETL pipelines for data synchronization between systems
  • Customizable Python scripts for repetitive tasks
  • Intelligent data validation and error detection
  • Real-time dashboard connectors
  • Automated reporting systems
014 Data silos and their impact on company performance
This website uses cookies to improve your experience. By using this website you agree to our Data Protection Policy.
Read more
×