UK Road Accident Analysis Dashboard

I developed a comprehensive dashboard for UK road accident data analysis using Microsoft Excel, focusing on deriving actionable insights to improve road safety measures. Through detailed data cleaning, processing, and visualization, I created KPI dashboards, pivot tables, and charts to showcase accident frequency, severity, and trends across various road types and months.

The analysis uncovered significant patterns, including peak accident periods and the impact of road conditions on accident rates. These insights led to targeted recommendations for improving road infrastructure and traffic management. I delivered a comprehensive report with strategic suggestions to reduce accident occurrences and enhance road safety initiatives across the UK.