Tableau Data Visualization and Analytics Questions and Answers 1 — 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?
- A URL Action
- A Filter Action (Correct answer)
- A Highlight Action
- A Set Action
Correct answer: A Filter Action
A Filter Action is the correct choice because it is designed to use the data from a selection in one sheet (the source sheet, in this case, the map) to filter the data in another sheet (the target sheet, the bar chart). This creates an interactive experience where users can dynamically explore relationships in the data.
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?
- Change the mark type to Gantt Bar. (Correct answer)
- Add a second axis and synchronize it.
- Create a calculated field for negative profit.
- Place the profit measure on the Color shelf.
Correct answer: Change the mark type to Gantt Bar.
The key to a waterfall chart in Tableau is using the Gantt Bar mark type. After calculating a running total, the Gantt Bar allows you to control the start and end point of each mark. You then use a separate field (typically the negative of the measure) on the Size shelf to control the length of each bar, creating the floating effect.
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?
- Histogram
- Scatter Plot
- Box and Whisker Plot (Correct answer)
- Bullet Graph
Correct answer: Box and Whisker Plot
A Box and Whisker Plot is specifically designed to show the distribution of a dataset through a five-number summary: minimum, first quartile, median, third quartile, and maximum. This makes it ideal for comparing distributions across different categories (like regions) and easily identifying key statistical measures like the median and interquartile range, as well as spotting outliers.
Question 4: Which of the following describes a primary functional difference between a Tableau Group and a Set?
- Groups can be used as filters, whereas Sets cannot.
- Groups are static and manually defined, while Sets can be dynamic based on conditions. (Correct answer)
- Groups create a new dimension field, while Sets create a new measure field.
- Groups can be based on measures, but Sets can only be based on dimensions.
Correct answer: Groups are static and manually defined, while Sets can be dynamic based on conditions.
The most significant difference is that Groups are always static; members are manually selected and do not change unless edited. Sets, however, can be dynamic. A dynamic set's members can automatically update based on a defined condition, such as 'Top 10 Customers by Sales', which will change as the underlying data refreshes.
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?
- The year filter is a measure filter and is processed last.
- A FIXED LOD expression is needed to count the customers.
- The dimension filter on year is being applied after the Top N filter is calculated. (Correct answer)
- The Top N filter cannot be used with a date dimension.
Correct answer: The dimension filter on year is being applied after the Top N filter is calculated.
According to Tableau's Order of Operations, Top N filters are computed before dimension filters. Tableau first identifies the overall Top 10 customers across all years in the dataset. Then, it applies the dimension filter for a specific year. If some of those overall top 10 customers had no sales in the selected year, they are filtered out of the view, resulting in fewer than 10 customers being shown. To fix this, the year filter should be added to context.
Question 6: When using Tableau's built-in forecasting feature, which of the following is a key requirement for the view?
- The view must contain at least one table calculation.
- The view must contain at least one measure and one date dimension. (Correct answer)
- The view must use a Gantt bar chart type.
- The view must not have any filters applied.
Correct answer: The view must contain at least one measure and one date dimension.
To enable forecasting in Tableau, the view must contain at least one measure (the value you want to forecast) and at least one date dimension (to provide the time series). While a dimension with integer values can sometimes be used instead of a date, the presence of a date dimension is the primary requirement.
Tableau Data Visualization and Analytics Questions and Answers 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?