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

Forecast

Answer

Trend Line

Answer

Constant Line

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

Add the filter to a dashboard

Answer

Change the filter to a measure filter

Answer

Use a table calculation filter

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

Group

Answer

Hierarchy

Answer

Combined Field

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

Row-Level Calculation

Answer

Aggregate Calculation

Answer

Level of Detail (LOD) Expression

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

Computed sort

Answer

Nested sort

Answer

Field sort

Question 6

An analyst has a bar chart showing Sales by State. They want to quickly see the percentage contribution of each state to the total sales across all states shown in the view. What is the most efficient way to add this information?

Accepted Answer

Add Sales to the view again and apply a Quick Table Calculation for 'Percent of Total'.

Answer

Create a FIXED LOD expression for total sales and then a new calculated field for the percentage.

Answer

Use the FORECAST feature from the Analytics pane.

Answer

Manually export the data to Excel, calculate percentages, and re-import it as a new data source.

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?

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?