Tableau Exploring & Analyzing Data 3

Question 1

A context filter in Tableau is applied at what point relative to other dimension filters?

Accepted Answer

Before regular dimension filters

Answer

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?

Accepted Answer

WINDOW_MAX

Answer

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?

Accepted Answer

Use a YEAR-based dimension on Columns

Answer

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?

Accepted Answer

It orders marks by computed rank within a partition

Answer

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?

Accepted Answer

Clustering

Answer

Tableau's clustering uses k-means to group marks into segments with similar characteristics.

Tableau Practice Test