mbuguakevvz/green-energy-optimizer

End-to-end data engineering pipeline optimizing green energy deployment across East Africa using World Bank, Open-Meteo & UNHCR data — featuring dbt, Prophet forecasting, resilience scoring and an interactive Streamlit dashboard. # ⚡ Green Energy Access & Resilience Optimizer ### East Africa Energy Intelligence Platform An end-to-end data engineering pipeline that identifies where solar microgrid deployment will save the most lives per dollar invested across East Africa — combining real-time energy access, climate risk, and displacement data into an actionable resilience scoring engine. --- ## 🌍 Problem Statement Over **600 million people** in Sub-Saharan Africa lack access to electricity. Health clinics lose vaccine cold chains. Water pumps fail. Climate shocks knock out the diesel generators that vulnerable communities depend on. Solar microgrids are the proven solution — but deployment decisions are made without data. This platform changes that by giving NGOs, governments, and climate finance institutions a **data-driven map of where energy intervention saves the most lives**. --- ## 🎯 Target Countries | Country | Population | Electricity Access | Displaced Persons | |---|---|---|---| | Kenya | 55M | 76.2% | 833,704 | | Uganda | 48M | 51.5% | 1,806,881 | | Tanzania | 65M | 48.3% | N/A | | Ethiopia | 126M | 55.4% | 3,344,414 | | Rwanda | 14M | 63.9% | 143,061 | | Somalia | 18M | <30% | 3,900,000+ | --- ## 🏗️ Architecture--- ## 📊 Data Sources | Source | Data | Records | |---|---|---| | World Bank API | Electrification rate, poverty, population, GDP | 215 | | Open-Meteo API | Solar irradiance, temperature, precipitation, wind | 9,702 | | UNHCR API | Refugees, IDPs, asylum seekers, stateless persons | 75 | | Prophet Forecasts | Energy demand index through 2027 | 14,082 | --- ## 🧠 Resilience Scoring Methodology Each country receives a **Resilience Priority Score (0–100)** — higher means more urgent intervention needed:| Component | Description | |---|---| | Energy Vulnerability | Inverse of electricity access percentage | | Climate Stress | Heat exposure + drought risk index | | Displacement Pressure | Displaced population as % of total | | Solar Deficit | Inverse of solar …