Esmel-data/education-investment-africa

Analytical dashboard exploring the relationship between public education spending and school life expectancy across 54 African countries (2010–2023) — Python · SQL · Power BI # education-investment-africa Analytical dashboard exploring the relationship between public education spending and school life expectancy across 54 African countries (2010–2023) — Python · SQL · Power BI # 🎓 Education Investment & School Life Expectancy in Africa (2010–2023) > Analytical project exploring how public education investment drives school life > expectancy across 54 African countries — built as a end-to-end data analyst portfolio piece. ## 1. Project Overview African governments allocate public resources to education in highly variable proportions, yet the link between investment levels and educational outcomes remains rarely documented in a decision-ready format. This project analyzes 54 African countries over 2010–2023 to answer one central business question: > To what extent does public investment in education — measured in absolute > volume (USD) and as a share of GDP — determine school life expectancy, and > how does this effect vary by country, education level, and gender?** The deliverable is a 3-page interactive Power BI dashboard supported by a full Python cleaning pipeline and 10 SQL analytical queries, designed for non-technical decision-makers and education policy stakeholders. ## 2. Dataset | Parameter | Detail | |------------------|-----------------------------------------------------| | Source | World Bank — World Development Indicators | | File | `Education_in_General.csv` | | Rows | 757 observations | | Columns | 11 raw → 20 final (after feature engineering) | | Period | 2010 – 2023 (14 years) | | Countries | 54 African countries | | Missing data | Structural (~40–65% on some columns) — kept as NaN | Variable categories: - `Identifiers` — country code, country name - `Temporal` — year, period (Phase 1 …