BIM2BI: An ETL Architecture Based on openBIM Standards for Integrating BIM Data into Business Intelligence Environments

The construction (AEC) industry has consolidated Building Information Modelling (BIM) as the standard for producing and managing project information, yet its analytical exploitation in Business Intelligence (BI) environments remains manual, ad hoc and dependent on proprietary platforms. Existing literature addresses partial aspects of the problem—IFC extraction, dashboards, semantic approaches, and data quality—without articulating a coherent architecture that integrates dimensional modelling, open-standard-based ETL, granular lineage and pre-ingestion validation. This work proposes BIM2BI, a BIM-BI integration architecture organised into four functional layers (data sources, transformation and orchestration, analytical storage and exploitation) that formalises a separation of responsibilities, explicit data contracts between layers and an extensibility-without-redesign principle. The architecture is grounded in the openBIM standards IFC, IDS and BCF, adopts the IfcGlobalId as a technical key for end-to-end lineage and uses IDS as a pre-ETL quality gate with a staged three-level validation strategy. The proposal is validated empirically through an open-source reference implementation (MIT licence) applied to ten representative real-world use cases from projects in Spain and Chile, comprising 69 IFC files and approximately 4.5 GB of input data grouped in three complexity profiles, with end-to-end execution times ranging from under a minute for single-discipline deliveries to under fifteen minutes for the most demanding infrastructure case. The results demonstrate the viability of the architecture in terms of data quality, traceability, reproducibility and scalability, and document empirical findings on the real behaviour of openBIM standards within automated analytical workflows. The proposal targets BIM Managers, AEC consultants and contractors, and Data Engineers seeking auditable, vendor-independent BIM analytics aligned with ISO 19650.