tripleaceme/afrofinance-pulse

A Bruin + DuckDB pipeline tracking Africa's fintech ecosystem — currency volatility, startup funding flows, and fintech readiness across 12 African countries. # AfroFinance Pulse **A data pipeline tracking Africa's fintech ecosystem — currency volatility, startup funding flows, and economic readiness — built with Bruin and DuckDB.** Africa has 6 of the world's 10 fastest-growing fintech ecosystems, but most data pipelines analyze Silicon Valley. This one doesn't. --- ## What This Pipeline Does AfroFinance Pulse ingests data from 3 sources, normalizes it through a staging layer, and produces 5 analytics assets that answer real questions about African fintech: | Analytics Asset | Question It Answers | |----------------|-------------------| | `naira_volatility` | How volatile has the Nigerian Naira been, and when were the worst weeks? | | `currency_corridors` | Which African currencies move together? (trade & remittance corridor insight) | | `fx_adjusted_funding` | That $250M raise — what's it actually worth in local currency terms? | | `fintech_readiness` | Which countries are most primed for fintech adoption? (composite score) | | `sector_funding_trends` | Where's the money going — payments, lending, neobanks? YoY trends. | ## Architecture ### Ingestion Methods Used - **Ingestr YAML** — Frankfurter API (ECB exchange rates), zero-code connector - **Python `materialize()`** — African FX rates from FloatRates + World Bank economic indicators - **CSV Seed** — 50 curated African fintech funding rounds (2018-2023) ### Data Quality Every asset includes column-level checks: `not_null`, `unique`, `positive`, `accepted_values`, `non_negative`. The pipeline validates data integrity at every layer. ## Data Sources | Source | Type | Coverage | |--------|------|----------| | Frankfurter API | ECB daily rates | ZAR + major currencies (USD, EUR, GBP, CNY) | | FloatRates | Free FX API | NGN, KES, GHS, EGP, MAD, TZS, UGX, ETB, XOF, RWF | | World Bank Open Data | Economic indicators | 12 African countries, 5 indicators, 2014-2023 | | Curated CSV | Funding rounds | 50 notable rounds from TechCrunch Africa, Disrupt Africa, The Big …