In this assignment you are going to use an example data set and use the Visual Vocabulary to think about what kind of visualisations would be the best option to deliver different messages to your audience.

The data set you are going to work with is the “Acquisition of citizenship by age group, sex and former citizenship” from Eurostat (code MIGR_ACQ).

To simplify the data a little bit, and to limit the data file size, the data about age groups was left out of the table. You can download a compressed csv file or an Excel file with the data with the links below (both files contain the same data).

acquisition-citizenship.csv.zip

acquisition-citizenship.xlsx

The data contains the following columns:

• citizen: the former citizenship
• sex: “Females”, “Males” or “Total”
• geo: the country of which the citizenship was acquired
• time: the year the citizenship was acquired
• values: the number of people (males, females or total) that acquired the citizenship of geo from the former citizenship in citizen in the year in time

Source: Maarten Lambrechts, CC-BY 4.0

Expected output

First you should formulate at least 5 questions about the data that would be interesting to get insights from in the data. Examples of questions are:

• are there any differences in the total number of citizenships acquired between females and males?
• What is the country most new citizens in Slovakia are originating from?
• How is the number of Moroccans acquiring Belgian citizenship changing over time?
• In which countries did former Russian citizens acquire new citizenships in 2020?
• ...

After formulating your questions, navigate to the Visual Vocabulary and identify the column in the Vocabulary that would be the best to answer each of your questions. Then, look at the options in each column, and identify the chart type that seems to be the best chart type to use for answering your question.