Gbadet/-West-Africa-Security-Incident-Analytics-Dashboard-1974-2020-
Domaine:
peace and securityCréateur:
Gba
Hôte:
This project presents an interactive Power BI dashboard analyzing security incidents across West Africa from 1974 to 2020. It visualizes trends in incidents, fatalities, injuries, attack types, weapon types, and perpetrator groups, offering deep insights into regional security patterns.
# -West-Africa-Security-Incident-Analytics-Dashboard-1974-2020-
This project presents an interactive Power BI dashboard analyzing security incidents across West Africa from 1974 to 2020. It visualizes trends in incidents, fatalities, injuries, attack types, weapon types, and perpetrator groups, offering deep insights into regional security patterns.
---
## 📂 Project Overview
The dashboard helps answer critical security-related questions:
- How have **incidents, fatalities, and injuries** changed over time?
- Which **countries** experience the highest number of incidents?
- Who are the **deadliest perpetrator groups**?
- What are the most common **attack and weapon types**?
- How have yearly security patterns evolved across decades?
---
## Data Source
Download here
---
## 📊 Key Metrics (Overall)
| Metric | Value |
|-------|--------|
| **Total Incidents**| 7,000+ |
| **Active Perpetrators** | 190 |
| **Total Fatalities** | 36,000+ |
| **Total Injuries** | 17,000+ |
---
## 🛠 Tools Used
- Power BI Desktop – Dashboard design & modeling
- Excel / CSV – Data ingestion
- DAX – Custom measures for aggregation, filtering, and time trends
---
## 🧹 Data Preparation Steps
✔ Cleaned missing values and ambiguous perpetrator entries
✔ Standardized attack types, weapon types, and country names
✔ Created a time dimension (1974–2020)
✔ Modeled relationships for efficient filtering
✔ Built DAX measures for:
- Total Incidents
- Total Fatalities
- Total Injuries
- Year-over-Year incident trends
- Perpetrator group aggregation
- Country-level comparisons
---
## 🔍 Dashboard Insights
📈 Incidents & Fatalities Over Time
The dashboard displays long-term trends (1974–2020), revealing periodic spikes in both incidents and fatalities, especially after the 2000s.
West Africa Security Dashboard
________________________________________
### 🗺 Top Countries (Incidents & Fatalities)
According to the visual breakdown:
1. Nigeria
2. Cameroon
3. Niger
4. Chad
5. Ghana
6. Benin
Nigeria overwhelmi …