Application of Business Intelligence and Analytics in civil construction: a case study in a development company in Goiânia-GO

Authors

  • Weflly Silva Cavalcanti Graduando em Engenharia Civil pela Universidade Federal de Viçosa Campus Rio Paranaíba
  • Vitor Luís Amorim Fonseca Professor Substituto do curso de Engenharia Civil pela Universidade Federal de Viçosa Campus Rio Paranaíba
  • Bianca de Melo Soares Leão Mestranda em Engenharia Civil pela Universidade Federal de Ouro Preto

Keywords:

Análise de dados, Ferramentas Computacionais, Gestão de projetos, Planejamento e controle de obras.

Abstract

The main challenges faced by the construction industry are related to the improvement of management and decision-making processes. Thus, the Business Intelligence and Analytics (BI&A) tools are presented as a solution to the management demands of this sector. This study presents the evaluation of the Power BI implementation, a Microsoft tool, which uses the concepts of BI&A. For this purpose, a case study was conducted in a real estate developer in Goiânia, capital of Goiás state, in which sales, costs and project schedule data were analyzed, in order to generate reports to support decision making using the tool. In addition, 4 contributors tested Power BI as users, and then evaluated the usability of the system. According to users, the tool has good usability, providing quality information, with a great interface. In this sense, it became clear that a BI&A tool contributes significantly so that projects can be better and more easily managed, as decision makers can have access to important information on the works in a clear and timely manner.

References

ALALOUL, W. S., LIEW, M. S., ZAWAWI, N. A. W. A., MOHAMMED, B. S. Industry revolution IR 4.0: future opportunities and challenges in construction industry. In: International conference on civil, offshore & environmental engineering - ICCOEE 2018, Kuala Lumpur, Malaysia, 2018. Proceedings: MATEC Web of Conferences, EDP Sciences, 2018, Vol. 203, p. 02010.

BORGES, J. F. B. Gestão de Projetos na Construção Civil. Revista Especialize On-line IPOG - Goiânia - 5ª Edição nº 005 Vol.01/2013 – julho/2013.

ÇELIK, U. 4D and 5D BIM: A system for automation of planning and integrated cost management. Communications in Computer and Information Science, v. 1188, p. 57–69, 2020.

CHAU, K. W., CAO, Y., ANSON, M., & ZHANG, J. (2003). Application of data warehouse and decision support system in construction management. Automation in Construction,12 (2), 213–224. DOI: 10.1016/S0926-5805(02)00087-0.

GIL, A. C. Métodos e técnicas de pesquisa social. 6. ed. São Paulo: Atlas, 2008.

GIRSANG, A. S.; ISA, S. M.; SAPUTRA, H.; NURIAWAN, M. A.; GHOZALI, R. P.; KABURUAN, E. R. Business Intelligence for Construction Company Acknowledgement Reporting System. 1st 2018 Indonesian Association for Pattern Recognition International Conference, INAPR 2018 - Proceedings. Anais [...] 2018.

HAITO, R. O.; MORATTI, T.; CARDOSO, F. FERREIRA. Desafios da gestão da produção na construção 4.0. XI Simpósio Brasileiro de Gestão e Economia da Construção. Anais [...] 2019.

LAZAR, J.; FENG, J. H.; HOCHHEISER, H. Research methods in human-computer interaction. John Wiley& Sons. (2010).

LEITÃO, C. F., & PRATES, R. O. (2017) A Aplicação de Métodos Qualitativos em Computação. In Flávia C. Delicato, Paulo F. Pires e Ismar Frango Silveira (Eds). Jornadas de Atualização em Informática 2017. Porto Alegre. – Sociedade Brasileira de Computação – SBC. pp. 43-90

LEWIS, J. R. (2002). Psychometric Evaluation of the PSSUQ Using Data from Five Years of Usability Studies. International Journal of Human-Computer Interaction, 14(3-4), 463–488. DOI:10.1080/10447318.2002.9669130

LOPES, A. B.; BOSCARIOLI, C.; PEREIRA, E. N. & BEZERRA, R. C. Business Intelligence para apoio à gestão na construção civil: uma revisão sistemática da literatura. AtoZ Novas práticas em informação e conhecimento, 2020.

LOPES, A. B. (2020). Aplicações analíticas na construção civil: Investigações e um estudo de caso na gestão de custos. Dissertação de Mestrado – Programa de Pós-Graduação em Tecnologias, Gestão e Sustentabilidade - PPGTGS, Universidade Estadual do Oeste do Paraná – UNIOESTE, Foz do Iguaçu, Paraná, Brasil.

MARTÍNEZ-ROJAS, M.; MARÍN, N.; MIRANDA, M. A. V. An inteligente system for the acquisition and management of information from bill of quantities in building projects. Expert Systems with Applications, v. 63, p. 84–294, 2016.

MICROSOFT. Comparando o Power BI Desktop e o serviço do Power BI. 2020. Disponível em: <https://docs.microsoft.com/pt-br/power-bi/fundamentals/service-service-vs-desktop>. Acesso em: 02 de abr. 2021.

MICROSOFT. Introdução a dashboards para designers do Power BI. 2021a. Disponível em: < https://docs.microsoft.com/pt-br/power-bi/create-reports/service-dashboards >. Acesso em: 02 de abr. 2021.

MICROSOFT. O que é Power BI?. 2021b. Disponível em: <https://docs.microsoft.com/pt-br/power-bi/fundamentals/power-bi-overview>. Acesso em: 02 de abr. 2021.

MICROSOFT. O que é Power BI Desktop?. 2021c. Disponível em: <https://docs.microsoft.com/pt-br/power-bi/fundamentals/desktop-what-is-desktop>. Acesso em: 02 de abr. 2021.

MICROSOFT. O que é o serviço do Power BI?. 2019. Disponível em: <https://docs.microsoft.com/pt-br/power-bi/fundamentals/power-bi-service-overview>. Acesso em: 02 de abr. 2021.

MUNTEAN, M., & SURCEL, T. (2013). Agile BI: The future of BI. Informatica Economica, 17 (3), 114–124. doi: 10.12948/issn14531305/17.3.2013.10.

NOWOTARSKI, P., PASLAWSKI, J. Industry 4.0 concept introduction into construction SMEs. IOP Conference Series: Materials Science and Engineering, vol. 245, n. 5, p. 052043. 2017.

PROJECT MANAGEMENT INSTITUTE - PMI. Um Guia do Conhecimento em Gerenciamento de Projetos (Guia PMBOK). 6ª Edição – EUA: Project Management Institute. 2017.

RATAJCZAK, J.; SCHIMANSKI, C. P.; MARCHER, C.; RIEDL, M.; MATT, D. T. Collaborative Tool for the Construction Site to Enhance Lean Project Delivery. International Conference on Cooperative Design, Visualization and Engineering. Anais [...] 2018.

ROSA, A. F.; MARTINS, A. I.; COSTA, V.; QUEIRÓS, A.; SILVA, A.; ROCHA, N. P. Validação para Português Europeu do Post-Study System Usability Questionnaire (PSSUQ). 10th Iberian Conference on Information Systems and Technologies. Anais [...] 2015.

RÜßMANN, M.; LORENZ, M.; GERBERT, P.; WALDNER, M.; JUSTUS, J.; ENGEL, P.; HARNISCH, M. Industry 4.0, The Future of Productivity and Growth in Manufacturing Industries. The Boston Consulting Group, abril, 2015.

SHARDA, R.; SURSUN, D.; TURBAN, E. Business intelligence and analytics: Systems for decision support. 10a ed. Pearson, 2014.

YIN, R. K. Estudo de caso: planejamento e métodos. 2. ed. Porto Alegre: Bookman, 2001

Downloads

Published

2021-09-29

Issue

Vol. 6 No. 4 (2021)

Section

Artigos

License

The Journal reserves the right to make normative, spelling and grammatical changes in the published article, aiming at maintaining the proper standard of the language, while respecting the personal style of the authors.
Author (s) are fully responsible for the published article. Journal of Lean Systems is not responsible for any violations of Copyright.
Journal of Lean Systems allows the author to retain the copyright of articles accepted for publication without restriction.
Plagiarism constitutes unethical behavior and is inconceivable. This journal reserves the right to use any methods of detecting plagiarism to analyze the submitted works.

This journal is licensed under a Creative Commons License.