Skip to content

shakeer7/Road_Accident_Dashboard_Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 

Repository files navigation

Road_Accident_Dashboard_Excel

image

📝 TO COMPARE THE ROAD ACCIDENTS THAT OCCURRED IN 2021 AND 2022 🔔 Requirements: ➡ Make a dashboard for road accidents for the years 2021 and 2022. ➡ Show the total number of casualties. ➡Total fatalities and their percentages according to accident severity, ➡ Casualties per type of vehicle ➡Comparison of the monthly trends in casualties for 2021 & 2022 ➡Maximum casualties by type of road ➡Total casualty distribution by road surface relationship between casualties by area, location, and day/night

♻ Analysis of the Dataset: ✔ Cleaning of Data ✔Processing of Data ✔Analysis of Data ✔Dashboard for data visualization

🔰 Outcomes: 📍 417883 total casualties 📍 Other casualties have the highest accident record rate, with the majority of accidents occurring in urban areas. 📍The proportion of car accident casualties that occur during the day as compared to at night, when it is at its highest. 📍The majority of accidents occur on single-carriageway roads. 📍When compared to other types of roads, dry surface roads experience the highest number of accidents

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors