NadiaHirwa/rwanda-indicators-pipeline

# 🇷🇼 Rwanda Development Indicators Pipeline **Project 1 of 3 — Data Engineering Portfolio** **Analyst:** Nadia Iradukunda Hirwa **Dataset:** World Bank Open Data API **Track:** Data Engineering — AmaliTech Apprenticeship & Masters Applications --- ## 📋 Project Overview A fully automated ETL pipeline that extracts development indicators for **6 East African countries** from the World Bank API, transforms and validates the data, loads it into **Supabase PostgreSQL**, and visualizes insights in a **Looker Studio dashboard**. The project answers the question: **How has East Africa developed economically and socially since 2000?** --- ## 🏗️ Architecture ``` World Bank API ↓ Extract (Python/requests) Raw Data (Parquet — local + Supabase Storage) ↓ Transform (Python/Pandas) Clean Data (138 rows × 12 columns) ↓ Load (SQLAlchemy → Supabase PostgreSQL) Looker Studio Dashboard ``` --- ## 📊 Data ### Countries Covered | Code | Country | |------|---------| | RW | Rwanda | | KE | Kenya | | UG | Uganda | | TZ | Tanzania | | ET | Ethiopia | | BI | Burundi | ### Indicators Extracted | Indicator | Column | Source | |-----------|--------|--------| | GDP (current USD) | `gdp_usd` | World Bank — NY.GDP.MKTP.CD | | Total Population | `population` | World Bank — SP.POP.TOTL | | Adult Literacy Rate | `literacy_rate_pct` | World Bank — SE.ADT.LITR.ZS | | Child Mortality | `child_mortality_per_1000` | World Bank — SH.DYN.MORT | | Urban Population % | `urban_population_pct` | World Bank — SP.URB.TOTL.IN.ZS | | Poverty Rate | `poverty_rate_pct` | World Bank — SI.POV.DDAY | ### Derived Metrics (calculated in transform) - `gdp_per_capita_usd` = GDP / Population - `gdp_yoy_growth_pct` = Year-over-year GDP growth % - `pop_yoy_growth_pct` = Year-over-year population growth % --- ## 🔗 Project Links | Deliverable | Link | |-------------|------| | 📊 Dashboard (Looker Studio) | *[not done yet]* | | 🗄️ Database (Supabase) | Supabase PostgreSQL — `east_africa_indicators` table | | 📓 Source …