NadiaHirwa/rwanda-indicators-pipeline
Domaine:
socioeconomicType de record:
project
Créateur:
Nad
Hôte:
# 🇷🇼 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 …