Tableau Exploring & Analyzing Data 3 — Questions and Answers
Question 1: A context filter in Tableau is applied at what point relative to other dimension filters?
- Before regular dimension filters (Correct answer)
- After all other filters
- Only on measures
- Only on calculated fields
Correct answer: Before regular dimension filters
Context filters execute first, creating a temporary subset of data that all other filters then operate on.
Question 2: Which function returns the highest value of an expression across the partition in a table calculation?
- WINDOW_MAX (Correct answer)
- MAX
- RUNNING_MAX
- TOTAL
Correct answer: WINDOW_MAX
WINDOW_MAX returns the maximum of an expression within the window defined by the table calculation partition.
Question 3: To compare two date periods side by side, such as this year vs last year, which approach is most direct?
- Use a YEAR-based dimension on Columns (Correct answer)
- Use a histogram
- Use the Pages shelf only
- Use a treemap
Correct answer: Use a YEAR-based dimension on Columns
Placing a YEAR date part on Columns separates the data into year-based panes for direct comparison.
Question 4: What is the effect of adding a quick table calculation 'Rank' to a measure?
- It orders marks by computed rank within a partition (Correct answer)
- It removes null values
- It changes the data source
- It creates a parameter
Correct answer: It orders marks by computed rank within a partition
The Rank table calculation assigns an ordinal position to each mark based on the measure within its partition.
Question 5: Which Tableau analytic feature groups marks into segments based on similarity of their values?
- Clustering (Correct answer)
- Trend lines
- Reference bands
- Forecasting
Correct answer: Clustering
Tableau's clustering uses k-means to group marks into segments with similar characteristics.
Question 6: A dual-axis chart in Tableau is created by doing what with two measures?
- Placing both on Rows/Columns then choosing Dual Axis (Correct answer)
- Adding both to Color
- Dragging both to Detail
- Using two separate worksheets
Correct answer: Placing both on Rows/Columns then choosing Dual Axis
Dual-axis charts are made by adding a second measure to an axis and selecting Dual Axis to overlay them.
Question 7: What does synchronizing axes on a dual-axis chart ensure?
- Both axes use the same scale (Correct answer)
- Both measures use the same color
- The chart becomes a map
- Filters are shared
Correct answer: Both axes use the same scale
Synchronizing axes forces both measures onto an identical scale so comparisons are not misleading.
Tableau Exploring & Analyzing Data 3
A context filter in Tableau is applied at what point relative to other dimension filters?