Capstone project analyzing GDP and food security in Sub-Saharan Africa using World Bank data and Power BI
# Economic Growth & Food Security Analysis: Sub-Saharan Africa
## Project Overview
This capstone project analyzes the correlation between GDP growth and food security outcomes across 50 Sub-Saharan African countries using World Bank development indicators (1960–2023).
**Prepared by:** Ndubuisi Favour Adaku
**Date:** July 2026
**Internship:** AnalystLab Africa, Batch B
---
## Research Question
To what extent does macroeconomic growth (GDP) translate into improvements in food security and agricultural productivity in Sub-Saharan Africa?
---
## Dataset
- **Source:** World Bank World Development Indicators (WDI)
- **Countries:** 50 Sub-Saharan African nations
- **Time Period:** 1960–2023
- **Records:** 15,225 data points
- **Indicators:** 7 core development metrics
### Key Indicators
1. GDP (current US$)
2. GDP per capita (current US$)
3. Agriculture, forestry, and fishing (% of GDP)
4. Food production index (2014-2016=100)
5. Prevalence of moderate or severe food insecurity (%)
6. Poverty headcount ratio at $1.90 a day (%)
7. Life expectancy at birth (years)
---
## Key Findings
### KPI Summary (2023)
- **Life Expectancy:** 64.80 years
- **Food Insecurity:** 58.32% of population
- **Agriculture % GDP:** 19.25% average
- **Total SSA GDP:** $47.02 billion
### Main Insights
1. **Strong positive correlation** between GDP growth and development outcomes
2. **Persistent food insecurity** despite 63 years of economic growth
3. **Varied agricultural dependence:** Niger (highest) vs. Djibouti (lowest)
4. **Accelerated growth** from 1990s onwards
5. **Economic growth is necessary but not sufficient** for food security
---
## Recommendations
### For Development Organizations (FAO, WFP)
- Prioritize smallholder agriculture investment in countries with >50% food insecurity
- Use GDP-to-food-security correlation to target interventions effectively
- Establish multi-country programs combining growth support with food security initiatives
### For National Governments
- L …