FREE Tableau Exploring & Analyzing Data Questions and Answers

Question 1

An analyst is visualizing monthly sales data for different product categories. To see how each category's sales compare to the overall monthly average, they want to add a dynamic line across the chart. Which feature should be used to accomplish this?

Accepted Answer

Reference Line

Answer

A Reference Line is used to mark a specific value or computation on an axis, such as an average, constant, or total. This allows for easy comparison of the marks in the view against that value. A trend line shows the trend in the data, a forecast predicts future values, and a constant line is a type of reference line but 'Reference Line' is the broader, correct feature name for this scenario.

Question 2

You are creating a view that shows the Top 10 customers by sales. You also have a dimension filter for 'Region'. You notice that when you filter by a specific region, the view shows fewer than 10 customers. You want the view to always show the Top 10 customers within the selected region. What should you do to the 'Region' filter to achieve this result?

Accepted Answer

Add the filter to context

Answer

According to Tableau's order of operations, dimension filters are processed after Top N filters. By adding the 'Region' dimension filter to context, you elevate its position in the order of operations. This forces the 'Region' filter to be applied first, creating a temporary subset of the data, and then the Top 10 customer filter is applied to that subset, ensuring the result is specific to the selected context.

Question 3

An analyst wants to group 'Product Sub-Categories' into 'High-Profit' and 'Low-Profit' based on a calculated field that checks if SUM([Profit]) > $50,000. The business requirements state that this grouping must automatically update if the underlying data changes (e.g., after a data refresh, a sub-category that was previously 'Low-Profit' could become 'High-Profit'). Which Tableau feature is most suitable for this requirement?

Accepted Answer

Set

Answer

Sets are the ideal choice because they can be dynamic. A dynamic set can be created based on a condition, such as a profit threshold. When the data is refreshed, the members of the set will automatically update based on that condition. In contrast, a Group is a static collection of members that must be updated manually.

Question 4

A data analyst is working with a view and creates a calculation using the `WINDOW_SUM()` function. This calculation is an example of which type of calculation in Tableau?

Accepted Answer

Table Calculation

Answer

Table calculations are transformations applied to the values in a visualization. They operate on the 'table' of aggregated data in the current view. Functions like `WINDOW_SUM()`, `RANK()`, and `INDEX()` are specific to table calculations, which compute based on the local data in the visualization.

Question 5

Which of the following sorting options is applied directly to a dimension pill on a shelf and is independent of any measures in the view?

Accepted Answer

Manual sort

Answer

A manual sort allows the user to directly rearrange the order of the dimension members by dragging them in the view's header or in the sort dialog box. This type of sort is static and does not depend on a measure or another field's value.

Tableau Practice Test

Tableau Practice Test

FREE Tableau Exploring & Analyzing Data Questions and Answers