Let’s apply what we’ve learned so far

Your task for this week’s class is to create a Tableau version of the visualization in this Gapminder video, using data from the World Bank’s World Development Indicators (WDI):

(Source: BBC/Gapminder)

Rather than using the data from week 3, start from this version of the data, which lacks the variable giving life expectancy at birth.

How to proceed:

There are four types of join in Tableau:

Inner Join: Returns values from both tables that match on the selected variables. The rest of the data is discarded.
Left Join: Returns all the values from the left-hand table, plus those from the from the right-hand table that match on the selected variables. Where there is no match, values will be null.
Right Join: Returns all the values from the right-hand table, plus those from the from the left-hand table that match on the selected variables. Where there is no match, values will be null.
Full Outer Join: Returns all the values from the both tables, matching them on the selected variables where possible. Where there is no match, values will be null.

For this exercise, choose an inner join.

The joined data should look like this in a Tableau worksheet. You can see which variables came from which file:

At this point, I would rename value to Life expectancy at birth.

Assignment