Use of Business Intelligence to measure road accidents through the Federal Highway Police database

• Lucca Carnaúba Federal Institute of Alagoas (IFAL)
• Mayson Medeiros Federal Institute of Alagoas (IFAL)
• Edison Camilo Federal Institute of Alagoas (IFAL)
• Jailton Cardoso Federal Institute of Alagoas (IFAL)
• Flávio Medeiros Federal Institute of Alagoas (IFAL)

DOI: https://doi.org/10.5753/sbbd_estendido.2024.243786

Abstract

This study analyzes accidents on Brazilian federal highways with data from the DPRF (2019-2023) with the aim of answering four research questions. The methodology used was exploratory and quantitative research using Business Intelligence techniques. The results indicate that weather conditions have little influence on the occurrence of traffic accidents. However, a significant increase in the number of accidents was observed during weekends and after 5 pm.

Keywords: accidents on highways, business intelligence, Datatran PRF, accidents on federal highway, BI, Federal Highway Police database, open data PRF accidents

References

Detoni Junior, W., Oening, A. P., and Marcilio, D. C. (2019). Business intelligence: Uma revisão de literatura. [link]. Acesso em: 28 ago. 2024.

Ipea (2023). Estudo aponta aumento de 13,5% em mortes no trânsito. [link] Acesso em: 11 fev. 2024.

Kimball, R. and Ross, M. (2011). The data warehouse toolkit: the complete guide to dimensional modeling. John Wiley & Sons.

Microsoft (2024). Power bi desktop. Acesso em: 31 ago. 2024.

Pinto, M. V. (2020). Processo de Data Warehousing. Marcus Vinicius Pinto.

PostgreSQL (2024). Postgresql: License. [link]. Acesso em: 29 ago. 2024.

PRF (2024). Dados abertos da prf. [link]. Acesso em: 11 jul. 2024.

Rocha, G. d. S. (2009). Caracterização dos acidentes de trânsito e vítimas no município de Rio Branco-Acre. PhD thesis, Universidade de São Paulo.