27.1. Tableau Part 3¶
27.1.1. Reading¶
This chapter has been broken up into 2 main sections. Part 1 will cover Dashboard Finesse while Part 2 will cover Tableau concepts involving calculations and parameters.
27.1.1.1. Part 1: Dashboard Finesse¶
Please watch the following videos (13:42 min total).
To complete this assignment, you are going to continue coding on the viz you worked on in Chapter 25, using the World Bank CO2 dataset.
Video |
Name of Video |
---|---|
Video 1: |
|
Video 2: |
|
Video 3: |
27.1.1.2. Part 2: Tableau Calculations & Parameters¶
Read the following documentation.
Basic Calculations:
Get Started with Calculations in Tableau.
Formatting Calculations in Tableau.
Understanding Calculations in Tableau.
Table Calculations:
Transform Values with Table Calculations.
Parameters:
Videos:
Watch the following videos to help you learn about Tableau calculations functionality and syntax, as well as parameters.
The calculation videos are part of a larger calculations playlist. We suggest you explore more videos in this playlist to learn more about calculations with certain data types and in specific situations. Keep in mind that we will not be covering LOD (Level of Detail) calculations in this class, so you may skip over those.
Note
Each of these learning videos has a workbook that you can download to and code-along with. You are not required to complete any of these workbooks, but it is suggested that you practice them to become more familiar with Tableau.
Video |
Name of Video |
---|---|
Video 1: |
|
Video 2: |
|
Video 3: |
|
Video 4: |
|
Video 5: |
27.1.1.3. Suggested Resources (not required reading)¶
Calculations
Good resource for specific functions.
Tips for Working with Calculated Fields in tableau.
Keep this as a resource for how to create and edit calculations.
Table Calculation
Defines and offers examples for each of the pre-set quick table calculations.
Parameter Resources
Resource for creating interactive vizzes.
27.1.2. Check Your Understanding¶
Question
Match the following calculation types to their definitions.
Basic calculation |
Computed values at the data source level as well as the visualization level with additional control over the granularity. |
Table Calculations |
Allows transformation at both the data source and visualization level of detail, without any significant granularity. |
Level of Detail (LOD) Calculation |
Allows transformation at the visualization level only. |
Question
Which of the following is NOT one of the four basic components of a Tableau calculation?
Functions
Level of Detail
Fields
Operations
Question
When would you use a calculation? (Select all that apply)
Segment data
Pivot a table
Convert data type
Aggregate data
Drop a table
No answer text provided.
Question
A parameter can accept values that you specify. This could include all, a list of possible values, or a range of values. What determines the availability of these options?
Basic Calculations
Table Calculations
Length of Data
Data Type
Question
Match the definitions with their correct terms:
Table Calculation |
Calculations that are part of the query and executed in the data source |
Basic or Regular Calculation |
Local calculations that only occur in your Tableau workbook after any basic calculations have been completed |
Question
Parameters must be incorporated into something else such as a filter, reference line or calculation field in order to be useful.
True
False