TeresiahNjoroge/africa-gender-youth-data-project

M&E data analysis and reporting tracker for Africa gender & youth indicators | SQL · Python · Power BI # Africa Gender & Youth Data Project > M&E data analysis and reporting project for Africa gender & youth indicators | SQL · Python · Power BI --- ## Overview This project is an end-to-end **Monitoring, Evaluation & Learning (MEL)** data pipeline built to track gender and youth indicators across African countries. It demonstrates how raw survey and administrative data can be cleaned, loaded into an in-memory SQL database, queried with SQL, and visualised in Power BI to generate actionable insights for development programmes. --- ## Why This Project Exists Development organisations working on gender equity and youth empowerment in Africa face a recurring challenge: data exists in silos; different formats, different countries, different years. This makes it hard to track progress against indicators like: - Female labour force participation rate - Youth unemployment (ages 15-35) - Girls secondary school enrolment - Women in decision-making positions This tracker solves that by building a reproducible, auditable pipeline from raw data to a dashboard. --- ## Tools and Technologies | Tool | Purpose | |------|---------| | Python (pandas, numpy) | Data cleaning and analysis | | SQLite (via sqlite3) | In-memory SQL queries and analysis | | Jupyter Notebooks | Reproducible analysis documentation | | Power BI | Interactive dashboard and reporting | | GitHub | Version control| --- ## Project Structure ``` africa-gender-youth-data-project/ | |-- data/ | |-- raw/ # Original CSV files (retrieved from the World Bank Open Data API) | |-- cleaned/ # Processed, analysis-ready datasets | |-- notebooks/ | |-- 01_data_cleaning.ipynb # Data ingestion, cleaning, standardisation | |-- 02_indicator_analysis.ipynb # SQL queries via Python (sqlite3) | |-- 03_reporting_export.ipynb # Summary tables and export for Power BI | |-- sql/ | |-- analysis_queries.sql # Standalone SQL query reference | |-- dashboard/ | |-- 04_gende …