Hi and welcome back. In this video, we're going to use Tableau to create a data viz, a great way to share insights with others. To begin, you'll need to download the dataset we'll use for this activity. Click the link to create a copy of the dataset and download it. If you don't have a google account, download the dataset directly from the attachment. As we go through the steps, you can put this video on one side of the screen and follow along in another window. You might notice your screen is slightly different from what you see here. Tableau might have updated its interface but the steps should be pretty much the same. First, log in to Tableau public. If you haven't created an account, go back to the reading about logging into Tableau public. Okay, now go to the circle in the upper right corner of the window and select my profile. From there, choose Create a Viz. This will open the Tableau public interface. From the connect to data window, go to the files tab and upload the CO2 dataset we downloaded earlier. Or you can navigate to the data tab at the top of the Tableau public interface. Under the dropdown, click new data source. Then open the CO2 dataset. After the data uploads, the screen will show the data source interface. Underneath connections, double click on the sheet's CO2 data cleaned to load that data into the main part of the screen. You can also drag and drop the sheet into the area where it says drag tables here. Click update now to preview the data you opened in the bottom portion of the screen. By default, Tableau will only show the first 1000 rows in the table, but you can increase the number of rows in the setting above the data view. Each row corresponds to a single data point and each column represents a different feature. Tableau interprets the type of data in each column. Each icon represents a different type of data. For example, a number sign represents numerical data while an abc represents string data. A globe represents geographic data and so on. Tableau is interpreted the first 2 columns as geographic data. The third column is string data and the last three columns as numeric data. All right, let's make a database that demonstrates the amount of CO2 emissions that come from each country. To do this, choose the sheet 1 tab in the lower left of the display. On the far left of the screen is a banner with column names above a grey line. In tableau, these are called the dimensions of the data. Below this line are the different measures that you can track for these dimensions. To create a chart that displays the CO2 emissions per country, we're going to start by double clicking the country name dimension. The main display will show a map of the countries on the planet with dots indicating which countries are represented in the data. The dots are all the same size because with no measure selected. Tableau defaults to scale each country equally. If you want to scale by CO2 emissions, we'll need to include a specific measure. Double click or drag and drop onto the sheet the measures CO2 kilotons. This will change the size of the dots to be proportional to the amount of CO2 emitted. Tableau has a wide selection of options for depicting the measures for a given dimension. Most of these options are contained in the middle column between the main display and the columns with dimensions and measures. Now, let's customize the look of our chart to better communicate trends in the data. If we drag and drop a measure on one of the marks such as color, size and label, we can change that aspect of the measures visualization on the chart. For instance, say we want to change the color of the CO2 measure. We would drag the measure CO2 kilotons to the box with the color label. Then we can select this box to pull up a list of color options. Feel free to pause this video and play around with the different options. Get creative, if you ever want to reverse a change that you make to a tableau sheet, just use the back arrow. There it is. We just created our first chart using tableau. But what if we wanted to change the dimensions or measures? Instead of visualizing the CO2 per country, maybe we want to chart the CO2 per capita per region. To do this, we could double click on the dimension region and then do the same for the measure CO2 per capita. This builds a new chart. We can edit the title by hovering the cursor over the title box and clicking on the arrow to bring up a drop down menu. Then we'll choose edit title. Let's give it the name global CO2 emissions. Or if we wanted to delete a chart, we could select the clear sheet button in the toolbar. This will wipe out the chart and bring us back to an empty sheet. Don't worry if you do this by accident or change your mind. The back button introduced earlier will bring the chart back. To delete a sheet entirely, right click on the sheets tab at the bottom of the screen and select delete. We won't be able to delete a sheet if it's the only sheet in our file, but be careful. Unlike clearing a sheet, deleting a sheet altogether cannot be undone. Make sure to save your progress by clicking the save icon or hovering over the file tab and selecting save. If you are asked to create an extract, return to the data source tab and click, create extract, then click save again. Congratulations. Now you're ready to start visualizing your data. This is far from the end of the story though. Soon you will explore even more advanced tools in tableau.
