dashboard by excel

Created an interactive accident analysis tool that cut data processing time by 75% through automated

pivot tables and slicers. The dashboard’s identification of 4 high-risk locations (32% of total accidents)

led to its adoption by the local transportation department, reducing their reporting workload by 50%.

Analyzed casualties, vehicle involvement, and road conditions to support safety improvements.