Analytics-101 Tableau Desktop Foundations Practice Questions
Prepare for Analytics-101 with more than an answer.
- 1
Which of the following describes a valid use case for a Context Filter in Tableau?
Show answer details
Correct answer: B
According to Tableau's Order of Operations, Context Filters are applied before Dimension Filters. If you want to find the 'Top 10 Products' specifically within the 'East' region, you must add 'Region: East' to Context so it filters the data first, and then the Top N filter runs on that subset.
- 2
You have a dashboard with a map view and a detailed text table. You want the text table to filter and show details only for the state selected on the map. Which dashboard action should you configure?
Show answer details
Correct answer: B
A Filter Action allows a selection in a source sheet (the map) to filter the data shown in a target sheet (the text table). This is the standard pattern for 'master-detail' interactivity.
- 3
A user wants to create a 'Combined Axis' chart to show both 'Actual Sales' and 'Budget Sales' as side-by-side bars for each Region. How is this achieved in the Tableau interface?
Show answer details
Correct answer: B
Dropping a second measure directly onto an existing axis (not the opposite side) creates a Combined Axis chart. Tableau automatically replaces the single measure pill with 'Measure Values' and adds 'Measure Names' to the Rows/Columns/Color shelf to distinguish the bars.
- 4
You are analyzing a dataset containing sales transactions where the 'Order Date' field is currently recognized as a String data type (e.g., '20230115'). You need to use this field for time-series analysis in Tableau. Which method efficiently converts this field to a Date type without modifying the underlying source file?
Show answer details
Correct answer: A
The DATEPARSE function is specifically designed to convert string fields into date fields by allowing you to specify the exact format of the string (e.g., DATEPARSE('yyyyMMdd', [Order Date])). While clicking the data type icon is also possible, DATEPARSE offers precise control for non-standard formats.
- 5
A data analyst connects to an Excel file where the data starts on row 5, and rows 1-4 contain merged cells and titles. The data in Tableau appears messy with nulls in the headers. What is the most efficient way to resolve this in the Data Source page?
Show answer details
Correct answer: B
The Data Interpreter is a built-in feature that automatically detects sub-tables and removes extraneous headers, footers, and merged cells to prepare the data for analysis without altering the source file.
- 6
You have survey data where each question is a separate column (e.g., Q1, Q2, Q3) with the respondent's answer as the value. You want to analyze the distribution of answers across all questions in a single bar chart. How should you reshape the data in the Data Source page?
Show answer details
Correct answer: A
Pivoting transforms wide data (multiple columns for similar attributes) into tall data (two columns: 'Pivot Field Names' and 'Pivot Field Values'). This allows you to use 'Pivot Field Names' as a dimension to slice the answers, which is essential for analyzing survey data collectively.
