Teabay7/Nigeria_Education_Dashboard

A comprehensive Power BI analyses of Nigeria's education sector across 24 indicators from 1999 to 2023. # Nigeria_Education_Dashboard A comprehensive Power BI analyses of Nigeria's education sector across 24 indicators from 1999 to 2023. --- ## 📌 Project Overview This project examines Nigeria's education performance across six thematic areas using publicly available World Bank Education Statistics data. The dashboard was built as part of a structured data analytics portfolio development initiative to demonstrate end-to-end analytical skills — from raw data sourcing to interactive dashboard delivery. **Period Covered:** 1999 – 2023 **Total Indicators Analysed:** 24 **Dashboard Pages:** 6 **Tools Used:** Microsoft Excel | Power BI Desktop **Data Source:** World Bank Education Statistics — Nigeria (NGA) via HDX --- ## 📊 Dashboard Pages | Page | Title | Description | |------|-------|-------------| | 1 | Enrolment Trends | School enrolment across pre-primary, primary, secondary & tertiary levels | | 2 | Gender Gap Analysis | Male vs female enrolment share with parity benchmarking | | 3 | Out of School & Completion | OOS children, gender exclusion rates, dropout analysis | | 4 | Teacher Supply | Teaching workforce growth & gender representation | | 5 | Funding & Literacy | Education spending vs GDP and adult literacy trends | | 6 | Key Findings & Insights | Executive summary of all findings | --- ## 🔍 Key Findings - 📈 **Primary enrolment grew 87%** — from 17.9M (1999) to 33.4M (2023) - ♀️ **Gender parity never achieved** — female primary enrolment stands at 47.5%, below the 50% benchmark throughout the entire period - 🚸 **9 million children** out of school in 2023 — girls face a 12 percentage point higher exclusion rate than boys - 🎓 **Only 44%** of children complete lower secondary school — over half drop out before finishing junior secondary - 👨‍🏫 **Teacher workforce grew** from under 200K to over 900K — female primary teachers now exceed parity at 55% - 💰 **Nigeria spends just 0.32% of GDP** on education — far below UNESCO's recommended 4% minimum --- ## …