![]() To build a relationship between the two tables, we need to specify the field names we wish to join from the datasets. ![]() We drag the table containing the continents to the canvas. Once they are available in your file system, we can join the datasets. Then, download the CSV file containing the population of each country here. Start by downloading the dataset containing all countries and their corresponding continents from Our World in Data. Next, we press the Sheet 1 button, and latitude and longitude appear as additional fields. This is possible by changing the geographic role of the 'Country Name' field from 'None' to 'Country/Region'. We'll also need to have the latitude and the longitude to build an interactive geographical map later. Here, we don’t need to change the data type, since Tableau automatically recognizes the type of field. First, we'll modify the names of the first two fields into ‘Country Name’ and ‘Country Code’. Many of Tableau's operations are similar to those used in Excel, such as renaming, changing the data type, or adding new fields. Each row corresponds to a different country and to a different year. We can see that we have four fields and 640 rows. The new page shows the data preview and the corresponding fields of the dataset. Click ‘Text File’ in the left menu and open your text file. You can view which file types you can load on the Start Page. You’ll need to first download the CSV file, and then save it as a text file, as Tableau Public can only load certain file types. We’ll be using Tableau to visualize these disparities between countries. ![]() As you probably know from the current news cycle, there is a large variability in the available quantity of freshwater across the world. For context, water withdrawal refers to the quantity of freshwater taken from surface water, such as rivers, lakes, and groundwater, and used for agriculture, industry, and domestic purposes. In this tutorial, we are going to use the dataset of water withdrawals per capita from Our World in Data. Once you’ve installed Tableau Public, we can open it and load the data. For this tutorial, we’ll focus on the free version of Tableau, Tableau Public. While Tableau Public is free, all other versions are paid and can be found on the official website. The difference from Tableau Online is that it’s not fully hosted by Tableau, but rather on public cloud platforms like AWS, Google Cloud Platform, and Microsoft Azure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |