Tableau Data Visualization and Analytics Questions and Answers

Question 1

An analyst has built a dashboard with a map showing sales by state and a bar chart showing sales by product category.
They want to enable users to click on a state on the map to filter the bar chart to show data for only that selected state.
Which of the following should the analyst configure?

Accepted Answer

A Filter Action

Answer

A URL Action

Answer

A Highlight Action

Answer

A Set Action

Question 2

You are creating a waterfall chart to visualize how different product sub-categories contribute to the total profit. After creating a running total of profit, what is the next essential step to transform the standard bars into the floating blocks characteristic of a waterfall chart?

Accepted Answer

Change the mark type to Gantt Bar.

Answer

Add a second axis and synchronize it.

Answer

Create a calculated field for negative profit.

Answer

Place the profit measure on the Color shelf.

Question 3

A financial analyst wants to compare the distribution of sales values for four different regions. They are particularly interested in identifying the median, interquartile range, and any potential outliers for each region side-by-side. Which chart type is most suitable for this analysis?

Accepted Answer

Box and Whisker Plot

Answer

Histogram

Answer

Scatter Plot

Answer

Bullet Graph

Question 4

Which of the following describes a primary functional difference between a Tableau Group and a Set?

Accepted Answer

Groups are static and manually defined, while Sets can be dynamic based on conditions.

Answer

Groups can be used as filters, whereas Sets cannot.

Answer

Groups create a new dimension field, while Sets create a new measure field.

Answer

Groups can be based on measures, but Sets can only be based on dimensions.

Question 5

An analyst is building a view to show the Top 10 customers by sales for each year. They place [Customer Name] on Rows, `SUM(Sales)` on Columns, and filter [Customer Name] to the 'Top 10 by SUM(Sales)'. They then add a dimension filter for `YEAR([Order Date])`. They notice that for some years, fewer than 10 customers are displayed. Why is this happening?

Accepted Answer

The dimension filter on year is being applied after the Top N filter is calculated.

Answer

The year filter is a measure filter and is processed last.

Answer

A FIXED LOD expression is needed to count the customers.

Answer

The Top N filter cannot be used with a date dimension.

Question 6

When using Tableau's built-in forecasting feature, which of the following is a key requirement for the view?

Accepted Answer

The view must contain at least one measure and one date dimension.

Answer

The view must contain at least one table calculation.

Answer

The view must use a Gantt bar chart type.

Answer

The view must not have any filters applied.

An analyst has built a dashboard with a map showing sales by state and a bar chart showing sales by product category.They want to enable users to click on a state on the map to filter the bar chart to show data for only that selected state.Which of the following should the analyst configure?

An analyst has built a dashboard with a map showing sales by state and a bar chart showing sales by product category.
They want to enable users to click on a state on the map to filter the bar chart to show data for only that selected state.
Which of the following should the analyst configure?