2025-10-302025-10-302024-04-22https://repositorio.ifal.edu.br/handle/123456789/1301This 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.ptAttribution-NonCommercial-NoDerivs 3.0 BrazilSistemas de InformaçãoRodovias federais - AcidentesPainel interativoETLInterface de linha de comandoAccidents on federal highwaysInteractive panelCommand line interfaceTrabalho de Conclusão de CursoCIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::METODOLOGIA E TECNICAS DA COMPUTACAO::SISTEMAS DE INFORMACAO