PhilipOklu/ROAD-TRANSPORT-CRASHES-ANALYTICS

Excel dashboard analyzing road traffic crash data in Nigeria from 2020–2024 # 🚗 Road Transport Crash Data Dashboard (Nigeria) An interactive Excel dashboard analyzing road traffic crash data in Nigeria from Q4 2020 to Q3 2024. The dashboard visualizes crash frequency, causative factors, vehicle types, and gender-based injury/fatality statistics, helping uncover insights for improving road safety. --- ## 📌 Project Overview This project demonstrates my ability to clean, analyze, and visualize real-world transport data using Microsoft Excel. It was built to show trends in traffic crashes across different years, quarters, and demographic categories. --- ## 🎯 Objectives - Analyze trends in road traffic crashes from 2020–2024 - Identify key causative factors and vehicle types involved - Visualize gender-based distributions of injuries and fatalities - Build a clean, interactive Excel dashboard with slicers and pivot charts --- ## 📊 Tools Used - **Microsoft Excel** – Data cleaning, pivot tables, slicers, dashboard creation - **Power Query** – (if used) for data preprocessing --- ## 📁 Dataset - **Source**: nigerianstat.gov.ng - **Structure**: Multiple tables for crashes, vehicles, causes, injured, and fatalities - **Time Range**: 2020 to 2024 (by year and quarter) --- ## 📈 Dashboard Preview --- ## 🔍 Key Insights - 🚦 **Crash Frequency**: Highest crashes recorded in Q3 across most years - 🚘 **Vehicle Involvement**: Commercial vehicles were involved in the majority of incidents - ⚠️ **Causative Factors**: Speeding and mechanical failure were top contributors - 👨‍👩‍👧‍👦 **Demographics**: Males were more affected in both injuries and fatalities --- ## 🗂️ Files Included | File Name | Description | |-----------|-------------| | `Road_Transport_Data_(Project).xlsx` | Full Excel workobook with dataset, EDA, slicers and pivot charts | | `dashboard.png` | Screenshot of the dashboard | | home.png` | Key Summary of the Analysis | | `README.md` | Project description | --- ## 👨‍💻 Author Philip Oklu Data Analyst | Excel | Powe …