Navegando por Autor "Santos, Leonardo Henrique dos Anjos"

Agora exibindo 1 - 1 de 1
  • Imagem de Miniatura
    Item
    Especificação técnica de ferramenta que auxilia na análise dos acidentes de trânsito nas rodovias federais brasileiras por meio de ETL
    (2024-04-22) Gomes Filho, José Carlos; Moraes Júnior, Edison Camilo de; http://lattes.cnpq.br/8234380347792761; Cruz, Jailton Cardoso da; http://lattes.cnpq.br/9366016044068759; Medeiros, Flavio Mota; http://lattes.cnpq.br/1874496667181567
    This work presents a technical approach to address the issue of traffic accidents in Brazil, proposing the development of a command-line interface (CLI) in Python for the extraction, transformation, and loading (ETL) of data from federal highway accidents. Business Intelligence (BI) architecture is employed, with emphasis on the star schema in data modeling. The CLI allows for customized execution of the ETL process, including selection of data sets and temporal dimensions. Processed data can be used to feed an interactive Dashboard, built with PowerBI, offering detailed data visualizations and filters by road type and weather conditions. The article aims to provide a robust technical solution for the analysis and prevention of traffic accidents, with the potential to support more effective public policies in this field.