elsie-le/Analystlab-Week-8-Capstone-project.-

AnalystLab Africa Capstone Project — Education & Literacy trends across 6 East African countries using World Bank WDI data. # Education and Literacy Trends in East Africa **AnalystLab Africa — Data Analytics Internship (Batch B, June–August 2026)** **Capstone Project — Week 8 Final Submission** **Prepared by:** Elizabeth Muthoni# Analystlab-Week-8-Capstone-project. --- ## Project Overview This project analyzes government investment in education and literacy outcomes across six East African countries — **Kenya, Ethiopia, Ghana, Uganda, Tanzania, and Rwanda** — using the World Bank's World Development Indicators (WDI) dataset. It applies the full data analytics workflow: data cleaning, analysis, dashboard development, and insight generation. ## Objective To examine how government spending on tertiary education and literacy outcomes have evolved over time in the selected countries, and to surface insights that can support decisions by governments, education ministries, and development partners. ## Dataset - **Source:** World Bank World Development Indicators (WDI) - **Indicators used:** - Government Expenditure on Tertiary Education (% of government expenditure) - Adult Literacy Rate (% of people ages 15+) - Youth Literacy Rate (% of people ages 15–24) - Children Out of School, Primary - Lower Secondary Completion Rate (% of relevant age group) - **Countries:** Kenya, Ethiopia, Ghana, Uganda, Tanzania, Rwanda ## Data Cleaning Performed in Power BI's Power Query Editor: - Filtered the global WDI dataset down to selected countries and indicators - Handled missing values to avoid skewed averages - Removed duplicate country-indicator-year records - Standardized country names and data types - Created calculated measures for KPI cards - Applied all transformations via Close & Apply ## Analysis & Dashboard Built in **Power BI Desktop**, the dashboard includes: - KPI card (average government expenditure on tertiary education) - Trend line chart (expenditure over years) - Bar chart comparing adult vs. youth literacy rates - Country and indicator slicers for interactive filtering ## Key …