Implementasi Dashboard Kecelakaan Lalu Lintas Menggunakan Microsoft Excel untuk Monitoring Frekuensi Kecelakaan Tahunan

Abstract

Traffic accidents are a serious problem in the transportation sector that has a direct impact on human safety, material losses, and social and economic burdens. Designing a traffic accident dashboard using Microsoft Excel as a data visualization tool to present important information related to accidents that occurred over a five-year period, from 2018 to 2022. Implement a Microsoft Excel traffic accident dashboard that can be used to process data in a structured manner, and present it in the form of informative visualizations. This dashboard is designed to apply basic concepts of statistics so that users can more easily understand the causes of accident cases and can take more efficient policies. This research uses a descriptive quantitative approach, which is a common approach in the study of applied statistics. Involving VBA (Visual Basic for Applications) features allows automation of tasks and creation of a more interactive user interface. The interactive dashboard designed in this research is able to present traffic accident data in detail. Key information such as accident cases, fatalities, and material losses are displayed in a structured manner, making it easier for users to analyze. The dashboard successfully displays data visualization in the form of bar charts, pie charts, and interactive tables that assist users in analyzing accident data that occurs based on time period (year), and accident factors. The dashboard using Microsoft Excel shows that even simple tools, if utilized with the right approach, can provide great benefits in the data-based decision-making process.