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, 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 use cases grouped in three complexity profiles. 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.