Esmel-data/worldbank-education-youth-unemployment
Domain:
socioeconomiceducationRecord type:
project
Creator:
Esm
Host:
End-to-end data analytics project exploring the relationship between secondary school enrollment and youth unemployment across 9 African countries (2000–2023) | Python → SQL → Power BI
# worldbank-education-youth-unemployment
End-to-end data analytics project exploring the relationship between secondary school enrollment and youth unemployment across 9 African countries (2000–2023) | Python → SQL → Power BI
# 📊 Education & Youth Unemployment — World Bank Analytics
> Does secondary school enrollment predict youth unemployment?
> An end-to-end data analytics project across 9 African countries (2000–2023)
## 1. Project Overview
Governments and international institutions invest heavily in secondary education
with the assumption that higher enrollment reduces youth unemployment.
This project tests that assumption using real World Bank data across
9 countries in Sub-Saharan Africa and North Africa over 23 years.
The final deliverable is a 3-page Power BI decision dashboard designed
for non-technical managers and executives, supported by Python data preparation
and SQL analytical queries.
## 2. Dataset
| Attribute | Details |
|------------------|------------------------------------------------------|
| Source | World Bank Open Data (manually downloaded by indicator and merged) |
| Rows | 18,448 |
| Columns | 5 raw → 11 after feature engineering |
| Period | 2000 – 2023 |
| Countries | Egypt, Ethiopia, Ghana, Kenya, Morocco, Nigeria, Senegal, Tanzania, Tunisia |
> ⚠️ The World Bank does not provide a single consolidated file.
> Each indicator was downloaded separately and merged manually using Python.
## 3. Tools & Technologies
| Tool | Role in the pipeline |
|-----------------------|-----------------------------------------------------------|
| Python (pandas) | Data loading, quality audit, cleaning, feature engineering, CSV export |
| SQL (MySQL Workbench) | 10 analytical queries cover …
Similar
Esmel-data/education-investment-africaPumlani/Youth-unemployment-data-cleanerEsmel-data/african-media-intelligence-aiAddressing Youth Unemployment in Nigeria: Do Remittances and Education Matter?Poor Education and Unemployment Implications for Youth Crimes in NigeriaEsmel-data/africa-economic-investment-analysis-1980