Lab 6: Data Joins

Goals

• Understand the basic reasoning behind relational databases
• Identify the differences between a inner, left, right, and full outer joins
• Build a dataset by joining several tables in Tableau
• Build a dataset by joining two tables on multiple variables

We downloaded the Population – Medium Variant and Period Indicators – Medium variant to be able to visualize the relationship between the overall population of a country and factors such as birth and death rates. We joined the tables by inner join and visualized it by filtering five countries to investigate the migration over the years in those countries.