Internet Users – #MM22

vizz of internet users 2010 - 2015

This week in #MakeoverMonday I worked with data about internet penetration. This dataset is from interesting source of public data called Knoema.

Original vizz consists from interactive map which shows percentage of internet users in countries from 1960 to 2015.

Original map

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.

Missing data

And data for some Countries was missing also.

Missing data vizz

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.

Missing data per country calculation

Creating vizz

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.

Parameter for year

I separated Number of users in particular Years.

Number of users in particular year

And created calculation for Number of user in these Years.

calculation for number of user in selected year

Then I used this new measure to create the map.

Map o internet users

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.

set for top 5 users

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.

year over year difference

And after putting elements in one dashboard and some formatting, this is the result.

vizz of internet users 2010 - 2015


Radar chart: Secret of success – #MM 13

Radar chart

This week I decided to take Makeover Monday little different than usual. The goal of this regular activity is to improve skills in data visualization by trying to retell the story of the original visualization more effectively or to find a new story in data.

This week was little bit different to me. When I saw the original chart, I couldn´t help myself but I wanted to create the same type of visualization in Tableau. I have never before created a radar chart combined with the background picture, so it was challenge I couldn’t refuse.

The dataset was simple, 2 dimensions (Social strata and Reason) and 1 measure (Rate). At first I had to find some clue how to create radar chart. Luckily I found a nice article on Tableau blog by Jonathan Trajkovic.

Calculation of X axis and Y axis

Thanks to trigonometry I can find formulas how to calculate values for both axes. Because I have 8 dimension values, I selected the appropriate formulas.

Unit circle angles color


Y axis calculation

Before I started with the calculations above, I created calculation reason number to make my axes calculation easier (no need to write whole Reason name, but only use one digit number + then I can also sort the reasons).


Creating visualization

  • Put calculation for X into columns and Y into rows
  • In Analysis menu unmark Aggregated measures
  • Show each social segment separately – put “Social Strata” into Colour


  • Create the area between peaks – in Marks select Polygon
  • Tell Tableau in which order to connect the peaks – put “reason number” into Path


Formatting visualization

When I finished the basic version of radar chart, I needed to polish it a little bit to make it understandable for the others.

  • Make the areas for each segment visible – reduce Colour opacity to 50%
  • Prepare some space for labels – set Fixed range for axes from -0,45 to 0,45
  • Remove axis marks from the visualization – hide Header for axis
  • Remove lines – set Grid line and Zero line for Sheet to None
  • Format tooltip – put “Social Strata”, “Reason” and “Rate” into Tooltip and format it little bit (as shown in picture)


Adding the radar lines and dimensions labels

The last thing I needed, was to add background image with radar lines and dimensions labels.

  • With some drawing tool create an background image
  • In Map menu select Background image and click on Add image
  • Locate my background image and set values for axes


At the end I put the Sheet into Dashboard, added Legend and Headline and it was done.

Radar Chart