Free Tableau Exploring & Analyzing Data Questions and Answers 1 — 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?
- Forecast
- Trend Line
- Reference Line (Correct answer)
- Constant Line
Correct answer: Reference Line
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?
- Add the filter to a dashboard
- Add the filter to context (Correct answer)
- Change the filter to a measure filter
- Use a table calculation filter
Correct answer: Add the filter to context
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?
- Group
- Hierarchy
- Combined Field
- Set (Correct answer)
Correct answer: Set
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?
- Row-Level Calculation
- Aggregate Calculation
- Table Calculation (Correct answer)
- Level of Detail (LOD) Expression
Correct answer: Table Calculation
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?
- Computed sort
- Nested sort
- Manual sort (Correct answer)
- Field sort
Correct answer: Manual sort
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.
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?
- Create a FIXED LOD expression for total sales and then a new calculated field for the percentage.
- Add Sales to the view again and apply a Quick Table Calculation for 'Percent of Total'. (Correct answer)
- Use the FORECAST feature from the Analytics pane.
- Manually export the data to Excel, calculate percentages, and re-import it as a new data source.
Correct answer: Add Sales to the view again and apply a Quick Table Calculation for 'Percent of Total'.
Quick Table Calculations provide a fast and efficient way to perform common computations like 'Percent of Total', 'Running Total', or 'Difference' on a measure that is already in the view. This is the most direct method that doesn't require writing a complex calculated field from scratch.
