MillicentOdoh/Nigeria-out-of-school-primary-children-analysis
Domain:
educationRecord type:
dataset
Creator:
Mil
Host:
Power BI dashboard analyzing out-of-school children and education enrollment across regions and states in Nigeria.
# 📊 Out-of-School Primary-Age Children in Nigeria: Region Analysis
## 📌 Project Overview
This Power BI project analyzes the distribution of out-of-school primary school children across Nigeria's 36 states and the Federal Capital Territory (FCT). The dashboard provides insights into regional disparities, state-level trends, school-age population, enrolment, and Net Enrolment Rate (NER), helping identify areas that require targeted educational interventions.
---
## 🎯 Project Objectives
- Analyze the distribution of out-of-school primary school children across Nigeria.
- Compare out-of-school children across the six geopolitical regions.
- Identify states with the highest number of out-of-school children.
- Examine school-age population and enrolment figures.
- Assess Net Enrolment Rate (NER) and each state's contribution to the national out-of-school population.
---
## 🛠 Tools Used
- Microsoft Power BI
- Power Query
- DAX
- Microsoft Excel
---
## 📂 Dataset
The dataset contains information for all 36 Nigerian states and the Federal Capital Territory (FCT), including:
- State
- Region
- School-Age Population
- Enrolled Children
- Out-of-School Children
- Net Enrolment Rate (NER)
- National Share (%)
- Risk Level
---
## 📈 Dashboard Features
- KPI Cards
- States Covered
- Total Out-of-School Children
- Highest Out-of-School Children
- Average Out-of-School Children per State
- Interactive slicers
- Region
- Risk Level
- State
- Visualizations
- Out-of-School Children by Region
- Out-of-School Children by State
- Treemap showing state distribution
- Detailed performance matrix
---
## 🔍 Key Insights
- A total of **10.65 million** primary school children are out of school across Nigeria.
- The **South South** region records the highest number of out-of-school children.
- **Rivers State** has the highest number of out-of-school children, with approximately **922,217**.
- Significant disparities exist between states, indicating unequal access to primary edu …
Similar
Children out of school, primary | Africa (World Bank — Gender Statistics)Children out of school (% of primary school age) | Africa (World Bank — Gender Statistics)Children out of school, primary, female | Africa (World Bank — Gender Statistics)Children out of school, primary, male | Africa (World Bank — Gender Statistics)DHS: Typology of out-of-school children. Primary. Dropped out. Female | Africa (World Bank — Education Statistics)DHS: Typology of out-of-school children. Primary. Dropped out. Male | Africa (World Bank — Education Statistics)