Adebayo-tech/Africa-Energy-Intelligence-Dashboard

# Africa Energy Intelligence Dashboard An Excel dashboard tracking electricity access, generation capacity, and clean-cooking deficits across 20 African countries, benchmarked against the African Union's 2030 renewable energy targets. ## What it covers Built entirely with PivotTables and PivotCharts on a 20-country, 30-metric dataset (World Bank, IEA, and AU sources): - **Energy Access** — electricity access %, people without electricity, urban vs. rural electrification gap, by country and region - **Energy Capacity** — total installed capacity, renewable vs. non-renewable split, generation mix (hydro, solar, wind, geothermal, coal, gas) - **Clean Cooking Deficit** — people without access to clean cooking, ranked by country - **AU 2030 Target Tracking** — each country's remaining capacity gap and required annual growth rate to hit the African Union's 2030 renewable energy target ## Key findings - ~356.5M people across the countries analyzed still lack electricity access (~33% of the combined population) - Renewable capacity totals 49.6 GW out of 212.2 GW installed (23.4%) — non-renewable capacity still makes up the majority at 76.6% - The Democratic Republic of Congo, Ethiopia, and Mozambique have the largest clean-cooking deficits ## Structure | Sheet | Purpose | |---|---| | `data` | Raw dataset — one row per country, 30 metrics | | `Energy_Access` | Access & electrification dashboard (charts) | | `Energy_Capacity` | Installed capacity & generation-mix dashboard (charts) | | `AU_2030_Target` | Progress-to-target dashboard (charts) | | `Sheet2`, `Sheet4`, `Sheet6`, `worksheet` | Supporting PivotTables behind the dashboards | ## Tech stack Excel · PivotTables · PivotCharts ## Getting started 1. Download `Energy_Data.xlsx` and open it in Excel or Google Sheets. 2. Browse the `Energy_Access`, `Energy_Capacity`, and `AU_2030_Target` sheets for the dashboard views. 3. Right-click any chart's underlying PivotTable to refresh, filter by region, or drill into …