Exploring & Analyzing Data Flashcards

Which type of filter restricts data at the row level before aggregation in a calculation context?

Answer: Dimension filter

Dimension filters operate on individual rows of data prior to aggregation, unlike measure filters which act after.

What does the LOD expression FIXED ignore unless explicitly added back?

Answer: Dimensions in the view

A FIXED LOD computes using only the dimensions in its expression, ignoring other dimensions in the view.

Which Show Me chart requires exactly one measure and is ideal for part-to-whole of a single dimension?

Answer: Pie chart

A pie chart shows part-to-whole relationships using a single measure split by one dimension.

To highlight values above a threshold automatically, which Analytics pane object should you drag in?

Answer: Reference line

A reference line marks a specific threshold or constant value against which marks can be visually compared.

A scatter plot in Tableau most commonly requires what placement of measures?

Answer: One measure on Columns and one on Rows

Scatter plots plot one continuous measure on each axis to reveal correlation between two variables.

What does the 'Keep Only' option do when you select marks in a view?

Answer: Filters the view to only the selected marks

Keep Only adds a filter retaining just the selected marks and removing all others from the view.

Which calculation type is computed across the entire table after the view is built, depending on layout?

Answer: Table calculation

Table calculations run on the aggregated results in the view and depend on the table's structure and addressing.