Hii Everyone, I have created this Road Accident Analytics dashboard using Excel. Requirements and KPIs: Clients want to create a road accident dashboard for the years 2021 and 2022 so that they can have insight into the requirements. 📌 Total Casualties took place after the accident 📌 Total Casualties & percentage of total with respect to accident severity and maximum casualties by type of vehicle 📌 Total Casualties with respect to vehicle type 📌Monthly trend showing a comparison of casualties for the current year and the previous year 📌 Maximum Casualties by Road type 📌 Distribution of total casualties by road surface 📌 Relation between Casualties by Area/ Location & by Day/ Night Steps Follow These are some steps that I followed during the project: Data Cleaning: In this step includes removing inconsistencies in data, errors, and duplicates and ensuring that the data with which I worked is accurate and reliable for further analysis. Data Processing: Creating some new columns that involved organizing, sorting, and filtering the data to extract meaningful insights. Data Analysis: Used various statistical methods to get valuable insights from the data. Data Visualization: Used Excel as a visualization tool. With the help of this, I have created attractive charts, graphs, and interactive visuals to present the data in an easy way. Dashboard Making: Finally, I built a dashboard in Excel by inserting slicers and timelines that allow users to interact with the data. Key insights : ✅ Total Casualties that took place after the accident is 417878 ✅ Maximum Casualties happened by Car (333480) which is 79.8% of total Casualties and minimum by others 3424 ✅ Total Casualties that took place in the Year 2021 & 2022 is 222146 and 195737. ✅ Maximum Casualties happened in the month of November 2021 and Minimum in February 2021. ✅ Maximum Casualties happened in the month of November 2022 and Minimum in January 2022. ✅ Maximum Casualties by Single Carriageway road type and Minimum by Slip road. ✅ Highest Distribution of total casualties on Dry road surfaces. hashtag #Road_Accident_Dashboard hashtag #Excel hashtag #Excelproject hashtag #dataanalysis hashtag #datavisualization hashtag #excelskills hashtag #dashboard