There are so many untold stories that lie hidden in data that can be useful to us in one way or another. I worked on the Africa Energy Project, which is a data extraction project that involves getting data on energy indicators for all African countries.
The project goes beyond data extraction into visualization which is am important aspect. Data visualization helps others understand the data and in this case, it is useful in policy making for such an important sector.
I recommend you start here which contains web scrapping before making your way to visualization.
The Process...
Before getting into visualization, there were several questions that became points of interest that could be answered by the data..
i. How does the performance across indicator topics look like?
ii. How do the energy scores across regions differ?
iii. Which are the best performing countries and the worst performing countries?
iv. How does the trend in scores across the years look like?
v. What is the performance for individual countries?
The Visualizations
The report contains slicers, KPI cards, pie chart, bar chart and column charts.
The slicers are meant to provide an interactive way for the user to filter data.
The year slicer in in form of a slider which enables the user to view the different trends between selected years.
The second one is for the indicator topic, one can select multiple indicator topics and see how the visuals change with each selection.
The last slicer is for the units. This one in particular is important because the scores are measured in different units. Filtering out scores by unit gives a more informed picture of what is happening.
The pie chart is used to represent the share by region. It reveals that North Africa is more developed when it comes to electricity access, supply and technical aspects as compared to other parts of Africa.
The bar chart is used to represent the top and bottom (n) countries and is responsive to the slicers. This gives shines a light on high performing and low performing countries which informs policy making.
The column chart shows the trend in total and average scores over the years.
The report has a second page which is used to filter further for individual countries and the indicator topics. It uses a table to show the sum and average score for all indicators under a specific indicator topic for a chosen country.
The visualization process paints a clear picture of the information once hidden in the data. There are various recommendations that are reached by policy makers as a result of visualization.
You can view the full report here and interact with the visuals!
Top comments (0)