This repository contains an Excel-based interactive dashboard designed to visualize road accident data. The dashboard presents a comprehensive overview of various aspects of road accidents, including fatal, serious, and slight casualties, as well as detailed breakdowns by road type, surface condition, light condition, vehicle type, and geographical area.
Fatal Casualties: 7,135 (1.7%)
Serious Casualties: 59,312 (14.2%)
Slight Casualties: 351,436 (84.1%)
Car Casualties: 333,485 (79.8% of total casualties)
Dry Surface: 279,445 incidents
Wet Surface: 115,261 incidents
Snow/Ice: A small proportion of incidents
Single Carriageway: 309.7k incidents
Dual Carriageway: 67.4k incidents
Roundabout: 26.8k incidents
Urban: 162k incidents
Rural: 255.9k incidents
Daylight: 305k incidents
Darkness: 112.9k incidents
Cars: 333,485 incidents
Goods Vehicles: 33,472 incidents
Buses/Coaches: 12,798 incidents
Motorcycles: 33,672 incidents
Other Vehicles: Various counts
A comparison of casualties over the months of 2021 and 2022, showing trends in accident frequencies.
The dashboard allows for filtering by:
Accident Date: Select accidents from different years (2021, 2022, 2023).
Area Type: Filter by Rural or Urban areas.
Prerequisites Microsoft Excel (2016 or later recommended)
- Clone the repository to your local machine: git clone https://github.com/Profbla2020/Raod-Accident-Dashboard-.git
- Navigate to the project directory: cd road-accident-dashboard
- Open the Road_Accident_Dashboard.xlsx file using Microsoft Excel.
- Explore the dashboard by interacting with the filters and data visualizations directly within Excel.
Below is a screenshot of the dashboard for a quick preview:
Contributions are welcome! Please feel free to fork this repository, create a new branch, and submit a pull request with your changes.
For any questions or suggestions, please reach out to adeolbalogun54@gmail.com.