Astrochuks/African-Union-central-reporting-system

Data intelligence platform for the African Union — tracks Agenda 2063 progress across 55 member states with automated insights engine, gender & youth analytics, and executive reporting. FastAPI + Supabase + Plotly.js # African Union Central Reporting System **A data intelligence platform that transforms fragmented continental data into actionable insights for evidence-based decision-making across the African Union.** Built to address the AU's core data challenge: **55 member states, 20 Agenda 2063 goals, thousands of indicators -- but no centralized system to collect, clean, analyze, and report on them in real time.** --- ## The Problem The African Union tracks progress across **7 aspirations and 20 goals** under Agenda 2063, spanning 55 member states. Today, this data lives in: - PDF reports published annually with 1-2 year data lags - Scattered Excel files across departments (ODG, WGYD, ICD, MIS) - External partner databases (World Bank, UNECA, AfDB) with no unified access layer - Manual spreadsheet-based analysis that takes weeks to compile before major meetings **The result:** Decision-makers in the Director General's Office wait days or weeks for basic continental metrics. Gender and youth indicators are tracked inconsistently. No automated alerts when indicators deteriorate. No system to tell the data story automatically. ## The Solution This platform provides the **complete data lifecycle** -- not just dashboards, but the entire pipeline from data collection to automated insight generation: ``` Data Sources (World Bank, UN SDG, Manual Uploads) ↓ ETL Pipeline (Extract, Clean, Validate, Load) ↓ PostgreSQL Database (Supabase) -- 55 countries × 24 indicators × 25 years (23,100+ records) ↓ Insights Engine (Auto-generates findings, alerts, trends, recommendations) ↓ REST API (FastAPI -- 35+ endpoints with Swagger docs) ↓ AU-Branded Dashboard (Real-time KPIs, charts, executive reports) ``` ### Key Capabilities | Capability | What It Does | Who It Serves | |-----------|-------------|---------------| | **Agenda 2063 Goal Tracker** | Progress monitoring across all 20 goals with regional breakdowns | Office of the Director General | | **Gender & Youth Analytics** | Gende …