NovaHB/africa-growth-lens
Domain:
socioeconomicRecord type:
software
Creator:
Nov
Host:
Full dbt pipeline on World Bank WDI data — staging, intermediate, and mart models for African economic indicators
# Africa Growth Lens
A dbt + BigQuery analytics pipeline that transforms World Bank development data
into clean, analysis-ready datasets on the economic, social, and digital growth
of African nations — surfaced through an interactive dashboard.
---
## 1. Project Overview
**Africa Growth Lens** turns the World Bank's World Development Indicators (WDI)
into a curated, queryable picture of how African economies are growing.
The raw WDI dataset is massive, sparse, and stored in a long "indicator code"
format that is hard to analyse directly. This project uses **dbt** to filter it
down to **69 African countries** (Sub-Saharan Africa and Middle East & North
Africa), a focused set of **15 development indicators**, and the years **2000
onwards** — then reshapes that data into purpose-built marts for GDP, inflation,
digital adoption, demographics, trade, human development, and cross-country
rankings.
**Why it was built:**
- To make African development data **accessible** — no SQL-on-raw-WDI required.
- To demonstrate a **layered analytics engineering workflow** (staging →
intermediate → marts) with tested, documented models.
- To power a **public dashboard** that tells the story of African growth through
clear, comparable metrics.
---
## 2. Architecture
```
┌─────────────────────────────────────────────────────────────────────┐
│ bigquery-public-data.world_bank_wdi │
│ (country_summary + indicators_data) │
└───────────────────────────────┬─────────────────────────────────────┘
│ source()
▼
┌─────────────────────────────────────────────────────────────────────┐
│ STAGING (views) │
│ stg_wdi_countries · stg_wdi_indicators │
│ clean + rename, filter to African countries / non-null values │
└───────────────────────────────┬─────────────────────────────────────┘
│ ref()
▼
┌─────────────────────────────────────── …