Análisis y visualización de datos aplicados a la gestión de tráfico para mejorar la gestión vial en ciudades inteligentes

Abstract

Abstract: In smart cities, mobility and road safety require solutions based on data analysis. Therefore, the objective of this research was to develop an interactive traffic data analysis system capable of identifying high-risk areas and supporting strategic decision-making in urban planning. To achieve this objective, a methodological guide for data preparation, analysis, and visualization was applied to two public datasets: US Accidents (United States) and UK Road Safety (United Kingdom). The development of this work included cleaning and preparing the data through exploratory analysis and handling missing and outlier values. In addition, climate, severity, and temporal variables were standardized to ensure comparability between the two countries. As a result, an interactive dashboard was developed in Power BI that allowed for the identification of areas with a high concentration of accidents, higher incidence rates, and the relationship between adverse weather conditions and greater accident severity. The system facilitates cross-country comparisons and supports decision-making to prioritize road safety actions.