TABLEAU DESKTOP SPECIALIST REVIEW EXAMS
ACTUAL QUESTIONS AND ANSWERS SURE A+
✔✔Full join - ✔✔Returns all rows from both tables
✔✔When would you use blending? (4) - ✔✔1. when cross database joins are not
supported
2. Tables are at a different granularity
3. Joins create duplicate data or data cleaning is required
4. If there is a lot of data and it just takes time to run
✔✔In which resource, group or set, can you create a parameter? - ✔✔set
✔✔What is a static/fixed set? - ✔✔The members of a fixed set do not change, even if
the underlying data changes. A fixed set can be based on a single dimension or multiple
dimensions.
✔✔What is a dynamic set? - ✔✔it can automatically change when the underlying data
changes. These can only be based on a single dimension
✔✔How is a group different from a set? - ✔✔Grouping in Tableau is grouping multiple
members/values into several groups which will create a higher category of the
dimension.
, Creating a set in Tableau is putting multiple values IN my a single set depending on a
condition or by manually picking them. In a set you have two options, you are either in
my set or out my set.
✔✔How do you create a hierarchy? - ✔✔A. Drag the subordinate field onto the primary
field
B. Right click and select "create hierarchy"
✔✔What are context filters? - ✔✔These are filters that are executed before normal
filters. If you want to add a value to these context filter, just right click and select "add to
context"
Normal filters are practiced independently on the whole data source. Use context filters
if you want to find "top 10 products by state"
✔✔Manual Sort - ✔✔by using the color legend, you can drag and drop dimensions to
be able to order the values
✔✔Automatic Sort - ✔✔Right click on the value and select sort
✔✔P Value - ✔✔The probability level which forms basis for deciding if results are
statistically significant (not due to chance). < 0.05 is considered significant
✔✔R^2 - ✔✔How the model fits into the data. A right R^2 is considered "better"
✔✔how to add reference line to the view? - ✔✔A. Click on analyst tab, pull reference
line to table
B. Right click on the axis and select reference line
✔✔How to find % of total? - ✔✔This is done within the table calculations, it is an option
available for a quick table calculation
✔✔How to determine the rank? - ✔✔This is an option under "quick table calculation"
✔✔What is the only thing you need to create a histogram? - ✔✔a continuous measure
✔✔How do you create a group? - ✔✔1. Right click on the field you want to group, click
"create group".
2. Select the fields you want to add in your group, click the group button
✔✔How to create two sets and find values (aggregations) - ✔✔right click on one of the
sets and select "combined set" this will allow you select members and start the process
ACTUAL QUESTIONS AND ANSWERS SURE A+
✔✔Full join - ✔✔Returns all rows from both tables
✔✔When would you use blending? (4) - ✔✔1. when cross database joins are not
supported
2. Tables are at a different granularity
3. Joins create duplicate data or data cleaning is required
4. If there is a lot of data and it just takes time to run
✔✔In which resource, group or set, can you create a parameter? - ✔✔set
✔✔What is a static/fixed set? - ✔✔The members of a fixed set do not change, even if
the underlying data changes. A fixed set can be based on a single dimension or multiple
dimensions.
✔✔What is a dynamic set? - ✔✔it can automatically change when the underlying data
changes. These can only be based on a single dimension
✔✔How is a group different from a set? - ✔✔Grouping in Tableau is grouping multiple
members/values into several groups which will create a higher category of the
dimension.
, Creating a set in Tableau is putting multiple values IN my a single set depending on a
condition or by manually picking them. In a set you have two options, you are either in
my set or out my set.
✔✔How do you create a hierarchy? - ✔✔A. Drag the subordinate field onto the primary
field
B. Right click and select "create hierarchy"
✔✔What are context filters? - ✔✔These are filters that are executed before normal
filters. If you want to add a value to these context filter, just right click and select "add to
context"
Normal filters are practiced independently on the whole data source. Use context filters
if you want to find "top 10 products by state"
✔✔Manual Sort - ✔✔by using the color legend, you can drag and drop dimensions to
be able to order the values
✔✔Automatic Sort - ✔✔Right click on the value and select sort
✔✔P Value - ✔✔The probability level which forms basis for deciding if results are
statistically significant (not due to chance). < 0.05 is considered significant
✔✔R^2 - ✔✔How the model fits into the data. A right R^2 is considered "better"
✔✔how to add reference line to the view? - ✔✔A. Click on analyst tab, pull reference
line to table
B. Right click on the axis and select reference line
✔✔How to find % of total? - ✔✔This is done within the table calculations, it is an option
available for a quick table calculation
✔✔How to determine the rank? - ✔✔This is an option under "quick table calculation"
✔✔What is the only thing you need to create a histogram? - ✔✔a continuous measure
✔✔How do you create a group? - ✔✔1. Right click on the field you want to group, click
"create group".
2. Select the fields you want to add in your group, click the group button
✔✔How to create two sets and find values (aggregations) - ✔✔right click on one of the
sets and select "combined set" this will allow you select members and start the process
