Femi-J/africa-energy-analytics

Data-driven analysis of energy access, solar potential, and sustainability across Africa — Python · SQL · Power BI # Africa Energy Analytics Portfolio > **Turning Africa's Energy Data into Decisions** A growing portfolio of data analysis projects exploring solar potential, electricity access, grid performance, and sustainability across Africa. Built by **Olufemi Akintunde** — Energy & Sustainability Data Analyst | Renewable Energy Expert | Python · Power BI · MySQL --- ## 🗂️ Projects ### 1. West Africa Electricity Access Analysis **Tools:** Python · Pandas · Matplotlib · Seaborn **Data:** World Bank Electricity Access Indicators (2020–2023) **Key Finding:** Rwanda improved electricity access by 18.7% in 3 years, the fastest in the region. South Africa is the only country going backwards (-0.77% avg YoY). 📓 Notebook | 📊 Charts --- ### 2. West Africa Solar Irradiance Analysis **Tools:** Python · NASA POWER API · Pandas · Matplotlib **Data:** NASA POWER satellite data (2014–2025) — 18 cities, 16 countries **Key Finding:** Kano receives 30% more solar irradiance than Lagos. The Harmattan effect enhances GHI in coastal zones while suppressing it in desert zones, a non-uniform regional effect. 📓 Notebook | 📊 Charts --- ### 3. Solar Irradiance Time Series Analysis **Tools:** Python · Pandas · Matplotlib · SciPy **Data:** NASA POWER (2014–2025) across 5 cities **Key Finding:** Lagos GHI stable over 11 years (no trend). Dakar and Lagos show near-zero correlation (0.020), completely independent solar patterns despite both being coastal cities. 📓 Notebook | 📊 Charts --- ### 4. Geospatial Energy Maps **Tools:** Python · Folium · GeoPandas **Data:** NASA POWER + World Bank **Deliverable:** 3 interactive HTML maps combining solar GHI and electricity access data across West Africa. 📓 Notebook | 🗺️ Interactive Map --- ### 5. MySQL Energy Database **Tools:** Python · MySQL 8.0 · mysql-connector-python **Data:** 2,574 solar records · 16 countries · 3 tables **Deliverable:** Fully queryable relational database with 5 analytical SQL queries answering real energy questions. 📓 No …