yordanos-ketema/ethiopia-east-africa-analysis
Domain:
socioeconomicRecord type:
project
Creator:
yor
Host:
Ethiopia & East Africa economic analysis - self-sourced World Bank data, SQL/Excel/Python/Power BI, with a population forecast and a real GDP-per-capita insight
# Ethiopia and East Africa Macroeconomic Analysis
An end-to-end macroeconomic data analysis portfolio project evaluating development indicators, demographic trends, and economic output across East Africa: Ethiopia, Kenya, Uganda, Tanzania, and Rwanda, benchmarked against Sub-Saharan Africa and global averages.
The project models multi-source World Bank datasets across SQL, Python, Excel, and Power BI, focusing on data reconciliation, window function transformations, demographic forecasting, and multi-fact BI modeling.
---
## Verified Headline Findings
All headline metrics have been verified for consistency across SQL queries, the Python notebook, the Excel dashboard, and Power BI DAX calculations:
| Indicator | Ethiopia | Kenya | Tanzania | Uganda | Rwanda | Regional Context |
| :--- | :--- | :--- | :--- | :--- | :--- | :--- |
| **Population (2024)** | **~132.1M** | ~55.1M | ~68.6M | ~49.9M | ~14.1M | Ethiopia represents >40% of the combined 5-country population |
| **Nominal GDP (2023)** | **~$163.7B** | ~$107.4B | ~$79.2B | ~$49.3B | ~$14.1B | Ethiopia leads total economic output across East Africa |
| **GDP Per Capita (2023)** | **~$1,272** | **~$1,942** | ~$1,154 | ~$988 | ~$1,000 | Kenya leads in per capita productivity despite smaller total GDP |
| **14-Yr Population Growth** | **+46.0%** | +35.7% | +48.8% | +47.6% | +38.2% | Ethiopia grew from 90.5M (2010) to 132.1M (2024) |
---
## Data Architecture and Integrity
### Data Provenance
* **Source:** World Bank World Development Indicators (WDI) bulk data exports
* **Geographic Coverage:** East Africa (Ethiopia, Kenya, Tanzania, Uganda, Rwanda) plus Sub-Saharan Africa and World aggregates
* **Primary Datasets:**
* `wb_population.csv`: Annual population records (1960 to 2024)
* `wb_gdp_current_usd.csv`: Nominal gross domestic product in current USD (1960 to 2023)
* `wb_wdi_indicators.csv`: Broad development indicators including life expectancy, inflation (CPI), unemployment, and poverty metrics
### …