As a regular Tableau user by day, every time you see a visualisation out there, you would start to wonder how we can drill down into the data a bit better? And then one day I came across the latest world press freedom index visualisation from the Reporters Without Borders.
Well…not bad. And then I clicked through the tabs and find out there is an “Index details” page where you can actually download the data in csv.
Sounds like we have a visualisation coming in!
Preparing the data
While in the real world, 95% of the data is usually messy and needs some preparation, this time around the data is relatively simple can clean. All we have is list of countries, their scores and their ranking. There is only one small problem in this dataset, that is it only shows the country name but not the respective continents. I have found a region code dataset on Github that can be further linked to the world press freedom ranking dataset.
Visualising the data
While there is a lot to talk about, I would like to this visualisation into three parts:
- Maps
- Stats table
- Top and bottom tables
Maps
One of the big feature on Tableau is the ability to show maps graphs relatively easily. The data table already have the names of the country, and that would automatically be recognised with the right longitude and latitude. I added the rank progression as the text overlay as well as color coded rise and fall in ranking as green and red respectively.
Stats table
Another cool feature using Tableau is the ability to quickly calculate some stats to help one to have a basic understanding of what a datasets looks like. I have separated these stats data into different continents so that the ranking can be compared across them. Things like highest/lowest ranking, progression as well as the average and median rank and score that builds the ranking is included as well.
We can start to see some interesting things here now:
- The average and median ranking is more or less close to each other except for Europe, where there is a 13.07 rank difference
- The Net Progression Rank, which is the sum of the both positive and negative rank progression is dropping for Americas and Oceania, as much as -24 and -19 respectively
- While Africa and Asia lags behind, Africa actually has a better average (37 vs 44.52) and median (33 vs 42) score
And there is always more to find out, this is just a sneak peak!
Top and bottom tables
This is another cool things in Tableau that allows you to use calculated field and parameters to customise what you wanted to see on the dashboard.
With the help from the two filtering fields, customising the table to see would be much easier without having to see the whole table of data, for example, below is the top/bottom 2 of progression and rank of all Asian countries.
Tip of the iceberg?
I am sure up till now, you may noticed that seems my interpretation is a bit off and that could might just be true. Visualising the data is only one of the many steps in data. I can think of things top of my mind like:
- How does the data is complied in the first place? (What is the source?)
- Is there another other hidden trends in the data? (Can look at the individual scores as well apart from just the ranking)
- Grouping the data in another fashion? (Such as trade partnerships instead of continents)
The list goes on! And that is why drilling into data is such an interesting thing to do.