Desarrollo de un dashboard interactivo para la consulta y visualización de información de siniestros de tránsito en Ecuador con datos abiertos de 2014 a 2024

Abstract

In this project we developed an interactive visual tool that allows the analysis of Open Data on traffic accidents in Ecuador in the period 2014 and 2024. This proposal arises in response to the need of citizens to have access to this information, helping to identify the most common causes of accidents. For this purpose, a methodology structured in three stages was applied. Data Collection and Processing, Exploration and Query Model and Dashboard Development. In its initial stage the data collected from different official sources such as the National Traffic Agency (ANT), the National Institute of Statistics and Census (INEC) and datosabiertos.gob.ec The dashboard was designed in Power BI, based on interactivity and clarity in the visual representation of Open Data. For this purpose, visualization techniques such as thematic maps and graphics that were understandable to citizens were considered. This project seeks to provide a tool for citizens, researchers, government institutions and students, promoting the use of Open Data and an informed citizenship.