Exploring & Analyzing Data Flashcards

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

Answer: Before regular dimension filters

Context filters execute first, creating a temporary subset of data that all other filters then operate on.

Which function returns the highest value of an expression across the partition in a table calculation?

Answer: WINDOW_MAX

WINDOW_MAX returns the maximum of an expression within the window defined by the table calculation partition.

To compare two date periods side by side, such as this year vs last year, which approach is most direct?

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.

What is the effect of adding a quick table calculation 'Rank' to a measure?

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.

Which Tableau analytic feature groups marks into segments based on similarity of their values?

Answer: Clustering

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

A dual-axis chart in Tableau is created by doing what with two measures?

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.

What does synchronizing axes on a dual-axis chart ensure?

Answer: Both axes use the same scale

Synchronizing axes forces both measures onto an identical scale so comparisons are not misleading.