Meet Tableau

Gallery is now Discover in the top navigation bar.

You can click the link below to follow along.

https://public.tableau.com/profile/grow.with.google#!/

Note: If you're not already logged in to Tableau Public, log in before you click the link. Or, copy the link and paste it into the address bar after you have logged in to Tableau Public. In either case, you will land on the Google Career Certificates page with access to the World Happiness data and workbooks used in this video.

Create a data visualization in Tableau

Important note

This is a companion tutorial. After you follow along with the instructor, you can practice again with the hands-on activity that comes next.

(Optional) If you prefer, you may skip this video tutorial and move on to the activity now. Link to activity: Hands-On Activity: Working with Tableau .

To follow along with the instructor in Tableau Public, download the matching Excel dataset and link below:

Click on the template preview link: CO2 Dataset

If you do not have a Google account, click on the attachment below to download the CO2 Dataset:

CO2 Dataset

Optimize the color palette in data visualization

Question: Fill in the blank: A diverging palette displays two ranges of values using color _____ to indicate magnitude.

A. value

B. spacing

C. intensity

D. balance

The correct answer is C. intensity. Explain: A diverging palette displays two ranges of values using color intensity to indicate magnitude. Intensity is a color’s brightness or dullness.

Getting creative

You can click the link below to follow along:

https://public.tableau.com/profile/grow.with.google#!/

Note: If you're not already logged in to Tableau Public, log in before you click the link. Or, copy the link and paste it into the address bar after you have logged in to Tableau Public. In either case, you will land on the Google Career Certificates page with access to the World Happiness data used in this video.

If you are following along with this video, click the Analytics tab to view the options the instructor selects from next.

The Analytics tab is located immediately to the right of the Data tab currently selected.

To view the menu of options shown which include Duplicate and Rename, right-click the tab for the worksheet at the bottom of your screen.

For example, if you didn't already rename your worksheet, right-click the tab named 'Sheet 2' by default.

If you are following along with the video, duplicate the Family sheet and create the charts and trend lines for the Health and Generosity measures. The instructor will use all four sheets (Economy, Family, Health, and Generosity) to create a dashboard later in the video.

1. Right-click the Family tab at the bottom of your screen and select Duplicate.
2. In the Columns section, drop the Health (Life Expectancy) data on top of Family to change the data displayed.
3. Right-click the tab for the duplicated sheet, select Rename, enter Health, and click OK.
4. Repeat steps 1 through 3 above, but drop the Generosity data on top of Family in step 2, and rename the sheet Generosity in step 3.

Linking data in Tableau

Important note

This is a companion tutorial. After you follow along with the instructor, you can practice again with the hands-on activity that comes next.

(Optional) If you prefer, you may skip this video tutorial and move on to the activity now. Link to activity: Hands-On Activity: Practice linking data in Tableau .

To follow along with the instructor in Tableau Public, click the links to the spreadsheet templates below and select "Use Template."

Links to datasets: CO2 , Energy , Population , and GDP

OR

If you don't have a Google account, you can download the spreadsheets directly from the attachments below:

CO2 Dataset

Energy Dataset

Population Dataset

GDP Dataset

Tableau has updated the way that users change data types. After changing Year (CO2 Data Cleaned) to a Date type, the data preview pane will no longer display properly.

To fix this, go to the column list in the lower left of the screen.

Tableau has updated the way that users change data types. After changing Year (CO2 Data Cleaned) to a Date type, the data preview pane will no longer display properly.

Do this for each dataset as you go:

1.) Go to the column list in the lower left of the screen.

2.) Select the # icon next to the Year1 (Energy) as you connect the dataset. Then, change the data type to Date.

3.) You may need to click Update Now in the preview pane to display the data properly.

4.) Make sure to repeat this step when you change more data types later on in this exercise, Year (Gdptotal) and Year (totalpopulation).