roadaccident

Creating a dashboard in excel on Road accidents

Road Accidents in India from 2017 to 2020, Power BI interactive dashboard

Rodity is a web-based application that leverages machine learning to predict and analyze road accident severity based on various real-world factors. It helps users understand how different conditions affect road safety, enabling proactive measures for accident prevention.

Our mission is to create a comprehensive UK Road Accident Excel Dashboard with the aim of providing actionable insights into road safety. Through this project, we aim to analyze and visualize road accident data, enabling stakeholders to make informed decisions for improving road safety measures and reducing accidents.

Developed an interactive Road Accident Analysis Dashboard in Microsoft Excel using Pivot Tables, Pivot Charts, and Slicers to analyze 896K+ casualties by severity, vehicle type, road conditions, and yearly trends. Enabled dynamic filtering and year-over-year comparison to support data-driven decision-making.