Day 4 of dashboard week involved curating our own data from the databank of worldbank.org, choosing the countries we want to look at in combination with the measures we want to analyze. These measures were all related to one of the 17 Sustainable Development Goals that were developed by the United Nations. I decided to focus on goal 8, which is to “promote sustained, inclusive and sustainable economic growth, full and productive employment and decent work for all”, and I wanted to look at the whole of Europe but split it up into the 4 different Subregions that are officially classified for identification purposes through the United Nation’s Geoscheme Classification system of Europe. Below is how the dashboard ended up looking like – the only data transformation that was required was pivoting the columns in power query and adding a column for subregion.

 

I very much based it off the form and feel of an academic paper (as both a positive and a negative), and while there’s still lots of exploratory features (you can drill through from any of the visualizations into a look at the different countries within the subregion for the desired measure), I tried to make this one more explanatory than anything else. The black buttons allow you to switch what measure is being looked at, and the text for each section explains what is going on with the data and how economic growth is affected in each subregion.

 

Nicholas Seah
Author: Nicholas Seah