Original vizz consists from interactive map which shows percentage of internet users in countries from 1960 to 2015.
I like the map vizz and possibility to select particular year. But it is difficult to :
- quickly see which countries are on the top or bottom
- understand how the situation changed during the time
So to reveal this insights was my goal for this week.
Exploring the data
The first thing I noticed were missing data for some Years. Therefore I decided to use only data from 2010 to 2015.
And data for some Countries was missing also.
In some cases not fully (only for some Years). But because I wanted to show difference between Years, I decided to filter out Countries with incomplete data.
I calculated number of null and zero records per Country and then filtered out Countries with count higher than 0.
My idea was to create vizz from this parts:
- map showing Number of internet user in individual Countries
- filter for Year
- bar charts with top and bottom 5 Countries
- bar chart shows Countries with the highest Increase of internet users
Map and filter for year
Create the map is easy task. But because I wanted to work with Year across all parts of vizz (even in text fields) I created the parameter for year.
I separated Number of users in particular Years.
And created calculation for Number of user in these Years.
Then I used this new measure to create the map.
Top and Bottom 5 countries
I used again the same calculated field. To show only 5 top (or bottom) I created set from Countries and used it in filter.
Countries with the highest increase of internet users
Because I decided to show Year to Year difference without table calculation, I created new calculated field which I used to create bar chart.
And after putting elements in one dashboard and some formatting, this is the result.