Using Power BI for quantitative analysis of architectural BIM modeling
um estudo de caso
DOI:
https://doi.org/10.46421/entac.v20i1.6234Keywords:
Cost Management, Information Management, ProjectAbstract
Budgeting is an important indicator for predicting the execution of a project. In this sense, there is a need to have reliable data for assertive application. When looking for ways to analyze these quantities effectively, it is possible to use business intelligence tools, such as Power BI. This article aims to propose an efficient dashboard to analyze quantities of an architectural BIM modeling, relating the data with the graphical appearance of the model. To this end, a case study was used with data from a model from the project sector of a construction company. After choosing this project, a study of the current panorama of difficulties in carrying out analyzes of this information was carried out. With this, the extracted quantities were processed and imported into Power BI to produce the dashboard. Finally, the proposed product resolved the difficult points of the initial panorama, facilitating data validation and communication between those involved.
References
BIM Fórum Brasil. Resultados da Pesquisa sobre Digitalização das Engenharias no Brasil. BIM Fórum Brasil, 2022. Disponível em:
https://www.bimforum.org.br/post/pesquisa-sobre-digitaliza%C3%A7%C3%A3o-das-engenharias-no-brasil
SACKS, R.; EASTMAN, C.; LEE, G.; TEICHOLZ, P. Manual de BIM: Um Guia de Modelagem da Informação da Construção para
Arquitetos, Engenheiros, Gerentes, Construtores e Incorporadores. 3ª Edição. Poto Algre: Bookman, 2021.
MATTOS, A.D. Como preparar orçamentos de Obras. 3ª Edição. São Paulo: Oficina de Textos, 2019.
CASTANHEIRAS, R. Custos e Orçamentos em BIM. São Paulo: Editora Senac São Paulo, 2024.
VALINEJADSHOUBI, M.; MOSELHI, O.; IORDANOVA, I.; VALDIVIESO, F.; BAGCHI, A. Automated system for high-
accuracyquantitytakeoffusing BIM. Automation in Construction, v. 157, 2023.
RODRIGUES, F.; DINIS, A. A.; MATOS, R. Construction Management Supportedby BIM and a Business Intelligence Tool.Energies, v.
, 2022.
ARAGÓ, A. B.; HERNANDO, J. R.; SAEZ, F. J. L.; BERTRAN, J. C. Quantitysurveyingand BIM 5D. Its implementationandanalysisbasedon
a case study approach in Spain, Journalof Building Engineering, v. 44, p. 103234, 2021. DOI: 10.1016/j.jobe.2021.103234.
SANTOS, R. L.; CAMPELO, C. R. F.; VASCONCELOS, B. M. Otimização da extração de quantitativos para orçamento de obras por
meio de software BIM: uma proposta de matriz de parâmetros. Gestão & Tecnologia de Projetos, São Carlos, v. 18, n. 1, p. 151–172,
DOI: 10.11606/gtp.v18i1.204175. Disponível em: https://www.revistas.usp.br/gestaodeprojetos/article/view/204175. Acesso
em: 1 maio. 2024.
AGÊNCIA BRASILEIRA DE DESENVOLVIMENTO INDUSTRIAL (ABDI). BIM na Quantificação, orçamentação, planejamento e gestão
de serviços da construção: Coletânea Guias BIM ABDI-MDI. Agência Brasileira de Desenvolvimento Industrial. Brasília, DF: ABDI,
GRUPO TÉCNICO BIM. Estruturação do escritório de projeto para a implantação do BIM. Guia AsBea em boas práticas em BIM.
CAU/BR, 2015. Disponível em: https://caubr.gov.br/boaspraticasembim/.
PANTELI, C.; KYLILI, A.; FOKAIDES, P. A. Building informationmodellingapplications in smartbuildings: From design
tocommissioningandbeyond A critical review. JournalofCleanerProduction, v. 265, 2020.
MORET-COLOMER, S. Power BI como herramienta gratuita para presentación de información de modelos BIM. In: BIM
INTERNATIONAL CONFERENCE, 12., 2023, Valência. Espanha: Editorial UniversitatPolitècnica de València,17-20 maio 2023. p. 87-95.
KADCHA, Y.; LEGMOUZ, D.; HAJJI, R. Anintegrated BIM-Power BI approach for data extractionandvisualization. The
InternationalArchivesofthePhotogrammetry, Remote SensingandSpatialInformationSciences, p. 67-73, 2022.
PRAT, J.; ROMERO, A.; RODRIGUEZ, S. Optimizationofthecontrolprocess in residentialbuildingsusingtechnological tools. In:
CONGRESO INTERNACIONAL DE INNOVACIÓN Y TENDENCIAS EN INGENIERÍA (CONIITI), 2020, Bogota. Anais[...]. Colombia: IEEE,
ALZRAIEE, H. Costestimate system usingstructured query language in BIM. InternationalJournalofConstruction Management,
DOI: 10.1080/15623599.2020.1823061.
YIN, Robert K. Estudo de caso: planejamento e métodos. 2. ed. Porto Alegre: Bookman, 1994. 240 p.
Project Management Institute (PMI). A Guide to the Project Management Body of Knowledge (Pmbok(r) Guide). 7. ed. EUA:
Project Management Institute, 2021.
ZHONG, B.; XU, Y.; DING, L. Utilizing BIM as an integrated database for project management. Journal of Construction Engineering
and Management, v. 146, n. 8, 2020.
LUO, H. Informatics, v. 46, 2021.
ZHANG, L.; WANG, X.; ZHAO, Z. Real-time data integrity and collaboration in BIM. Journal of Computing in Civil Engineering, v. 34,
n. 5, 2020.
LI, Y.; ZHANG, X.; SUN, Y. Ensuring data integrity in collaborative BIM environments. Automation in Construction, v. 123, 2021.
KIM, H.; LEE, J.; CHO, Y. Enhancing data traceability and usability in BIM environments through dynamic linking. Journal of
Construction Engineering and Management, v. 147, n. 4, 2021.
PARK, M.; KWON, H.; SHIN, J. Improving project data management through BIM and dynamic dashboards. Journal of Information
Technology in Construction, v. 27, p. 98-110, 2022.
WANG, Y.; CHEN, P.; LIU, Q. Visual data analytics in BIM for construction management. Journal of Management in Engineering, v.
, n. 3, 2020.
CHEN, L.; GAO, Z.; WANG, J. Application of interactive visualization tools in BIM for construction projects. Construction
Management and Economics, v. 40, n. 2, p. 123-136, 2022.
HU, Y.; WANG, Y.; DENG, X.; ZHU, L. Integrating BIM and real-time data for better construction project management: a review and
future directions. Automation in Construction, v. 123, p. 103543, 2021.
XU, X.; MAO, C.; HUANG, Q.; WANG, X.; ZHANG, Y. Data management in Building Information Modeling (BIM) projects: Trends,
approaches, and tools. Journal of Construction Engineering and Management, v. 146, n. 6, p. 04020061, 2020.
ZUO, J.; ZHANG, Z.; ZHANG, Y.; NG, S. T. The impact of BIM implementation on the performance of construction projects: A
bibliometric analysis. Journal of Cleaner Production, v. 281, p. 124441, 2021.
