For today’s Day 4 of the dashboard week, we were given the task of choosing our own dataset from the World Data Bank World Data Bank SDGs for an SDG goal we were interested in. I was immediately drawn to Goal 7: Ensure access to affordable, reliable, sustainable, and modern energy for all. As someone passionate about renewable energy and conservation, this goal resonated with me deeply.

Among the targets for Goal 7, the first target is: Target 7.1: By 2030, ensure universal access to affordable, reliable, and modern energy services.The indicator for this target is: Indicator 7.1.1: Proportion of the population with access to electricity.

I downloaded the necessary data for this indicator, including datasets on the percentage of the population with access to electricity, GDP information, population data, regional statistics, and population growth rate estimates from 2000 to 2020. The data was pretty much clean and only some transformation was required which was easily achieved in Alteryx.

I had an ambitious vision for the visualization but was more familiar with achieving such results in Tableau. This presented a bit of a challenge in replicating the same level of sophistication in Power BI, but I did my best, and you can see the report below. I experimented with new charts, like a vertical barbell chart, which was more challenging to implement horizontally in Power BI. Additionally, I incorporated a map that required obtaining a JSON file to display a global view.

What I found out was that the percentage of the population with access to electricity has been increasing steadily. In 2000, only 76% of the global population had access, which has now risen to 87%. However, this still leaves about 0.7 billion people without access to electricity.Africa, particularly Sub-Saharan Africa, stands out as the region with the most significant lack of electricity access. Looking ahead, the population growth rate estimates for Sub-Saharan Africa suggest that the number of people without electricity will remain a significant challenge. This poses a critical obstacle to achieving the SDG target by 2030.

Dashbaord Week is coming to end and can’t believe I survived it with being ill and all. Crazy how this week went on.

Prerana Amatya
Author: Prerana Amatya