Proposta de um painel interativo para avaliação do cenário da sinistralidade viária de Aparecida de Goiânia-GO

Abstract

The work developed aimed to present road accident data in a visual and dynamic way for the city of Aparecida de Goiânia, through the creation of an interactive panel. The panel provides effective and intuitive data analysis, contributing to decision making. A bibliographical review was carried out on data management, indicators, databases, dashboard tools, seeking to understand which are the best options to be applied in this work. Different databases were used to apply the indicators most compatible with the data obtained and dynamically presented on the dashboard developed on the POWER BI platform. The panel developed is intuitive, simple for updating data, and which agrees with the planning sector, allowing the Municipality of Aparecida de Goiânia to carry out medium and long-termplanning, avoiding acting in a random manner, making it possible to carry out assessments of costs associated with the types of claims, whether by urban or rural area, being able to evaluate different databases is to identify similarities in the accident rate, in addition to the current scenario in which the municipality finds itself and its evolution as the panel is fed, making it possible to identify the pattern of victims, age, critical month, education, among other aspects.