singleme92/Nigeria_Road_Accidents
Domaine:
peace and securityCréateur:
sin
Hôte:
Data analytics project exploring Nigeria road accident patterns, fatalities, injuries, and accident severity using Microsoft Power BI.
# 👤 Author
**Babajide John Falowo**
**Certified Data Analyst**
### Skills
- Power BI
- SQL
- Python
- Microsoft Excel
- Data Visualization
- Dashboard Development
- Business Intelligence
# 🇳🇬 Nigeria Road Accident Analysis Dashboard
## 📌 Project Overview
Road traffic accidents remain one of Nigeria's major public safety challenges, leading to significant loss of lives, injuries, and economic costs each year.
This Power BI project analyzes road accident data across Nigerian states to uncover patterns, identify accident hotspots, compare accident severity, and provide actionable insights for road safety stakeholders.
The dashboard enables decision-makers to monitor accident trends and better understand casualty distribution across the country.
---
# 🎯 Objectives
The project aims to answer the following business questions:
- Which states recorded the highest number of road accidents?
- Which states recorded the highest number of deaths?
- How are accident severities distributed?
- What proportion of casualties resulted in fatalities?
- Which states require greater road safety intervention?
- What trends can be observed across reporting periods?
---
# 📊 Dataset Information
The dataset contains road accident records for Nigerian states with the following fields:
| Column | Description |
|---------|-------------|
| STATE ID | Unique State Identifier |
| STATE | Nigerian State |
| FATAL | Fatal Accident Cases |
| SERIOUS | Serious Accident Cases |
| MINOR | Minor Accident Cases |
| TOTAL CASES | Total Recorded Accident Cases |
| NUMBER INJURED | Total Persons Injured |
| NUMBER KILLED | Total Deaths |
| TOTAL CASUALTY | Total Casualties |
| PEOPLE INVOLVED | Total People Involved |
| PERIOD | Reporting Period |
---
# 🛠 Tools Used
- Microsoft Power BI
- Power Query
- DAX (Data Analysis Expressions)
- Microsoft Excel / CSV
- GitHub
---
# 📈 Dashboard Features
The dashboa …