Dashboard week is one of the most signature sessions in The Data School training. In this session, the cohort will be given one or several specific datasets and create a corresponding dashboard. The aiming of dashboard week is to develop excellent time management and data visualisation skills.



Today is the fourth day of dashboard week and the topic is The Legatum Prosperity Index. This is a tool for transformation, offering a unique insight into how prosperity is forming and changing across the world. The dataset contains the Legatum Prosperity Index of 147 countries and across 12 pillars, 67 elements and 300 indicators. The time range is from 2007 to 2021.


Data Preparation

The original data set is not in a proper structure for Tableau. Each year has two separated attributes, representing the rank and score. In this case, the data set has a big number of columns, which can not be inputted into Tableau directly. The first task I did is restructure the data, expanding rows and reducing columns. Then I calculated the average of scores and maximum of scores for each area group.



Below is the screenshot of my dashboard:

The story I tell is about the countries raised or fallen most in the past decade. On the left-hand side is a big map that shows how the rank change in each country. Users can switch between all countries or only focus on the top 30 countries that raised or fell most. The heat map on the right-hand side shows the tendencies of 12 pillars. Moreover, the last bar chart with two marks is the score of the selected country compared to the average and maximum in area. Based on this dashboard, we can figure out how these countries raised or fell, and what positions they are in their area groups.

Chen Zhang
Author: Chen Zhang