NovaHB/africa-growth-lens

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() ▼ ┌─────────────────────────────────────── …