ajisefiniprecious-rgb/electricity-usage-africa-powerbi

# Electricity Usage in Africa — Power BI Dashboard An interactive Power BI dashboard analyzing electricity access rates across African countries and subregions from 2009 to 2023, highlighting which countries have improved the most and which are lagging behind. ## Overview This dashboard tracks the percentage of population with access to electricity across 54+ African countries, comparing progress over four key years (2009, 2014, 2019, 2023). It breaks the data down by country and by subregion (Northern, Southern, Eastern, Western, and Middle Africa) to surface both individual country stories and broader regional trends. ## Dashboard Pages ### Page 1 — Country Overview - KPI cards showing Avg / Max / Min electricity access for 2009 and 2023 - Country-level comparison of 2009 vs 2023 access rates, sorted highest to lowest - A multi-year line chart (2009 → 2023) showing each country's trajectory over time - Interactive slicers for country name and subregion ### Page 2 — Top & Bottom Performers - Top 10 and Bottom 10 countries ranked by overall progress - 2023 snapshot of the top 10 and bottom 10 countries by access rate ### Page 3 — Regional Analysis - Country progress rate, ranked - Average progress score by subregion - Regional average electricity access, 2009 vs 2023 - Regional progress trends across all four years ## Key Insights - **Northern Africa leads** with the highest average electricity access in both 2009 and 2023, and Algeria, Egypt, Mauritius, Morocco, Seychelles, and Tunisia all sit near 100% access by 2023. - **Kenya, Rwanda, Eswatini, Uganda, and Lesotho** show the largest gains in progress score, reflecting significant infrastructure expansion over the period. - **South Sudan, Burundi, Chad, Malawi, and the Central African Republic** remain the lowest-ranked countries for 2023 access, pointing to where investment gaps are most acute. - **Southern Africa** has the highest average progress score by subregion, while **Northern Africa**, de …