Analytics-101 Sample Questions & Answers
Free Tableau Desktop Foundations practice questions with worked answers and explanations. See how the ExamJungle simulator prepares you — then jump into the full test.
Launch the full Analytics-101 simulator →Showing 6 of 12 free samples.
- Question 1Intermediate
Connecting to & Preparing Data · Combining data
You are building a view using two tables: 'Orders' and 'Returns'. You want to analyze sales performance but also identify which orders were returned. Not all orders have returns. Which method of combining data is best suited to avoid duplicating measure values from the 'Orders' table while keeping all order records?
Show answer & explanation
Correct answer: B
Relationships (the logical layer) are smarter than physical joins. They maintain the native level of detail for each table and only aggregate data at the necessary level for the view. This prevents the 'measure duplication' issue common with joins when there is a one-to-many relationship.
- Question 2Intermediate
Connecting to & Preparing Data · Combining data
A user needs to combine 12 separate Excel files, one for each month of the year, into a single data source in Tableau. All files are in the same folder and have identical schema. What is the most efficient way to achieve this?
Show answer & explanation
Correct answer: B
A Wildcard Union allows you to connect to multiple files in a directory that match a specific naming pattern. This is dynamic; if a new file matching the pattern is added to the folder later, Tableau will automatically include it upon refresh.
- Question 3Beginner
Exploring & Analyzing Data · Filtering
You have created a scatter plot showing 'Sales' vs 'Profit'. You notice a cluster of outliers and want to exclude them from the view to focus on the main trend. After selecting the outliers, which option should you choose to remove them from the visualization but keep them in the underlying data source?
Show answer & explanation
Correct answer: A
The 'Exclude' command creates a filter on the Filters shelf that removes the selected data points from the current view. It does not delete data from the source; it simply hides it from the visualization context.
- Question 4Beginner
Understanding Tableau Concepts · Dimensions and Measures
Which of the following field types appears as a Green pill when dragged onto the Rows or Columns shelf?
Show answer & explanation
Correct answer: B
In Tableau, Green pills represent Continuous fields (whether they are dimensions or measures), which create axes. Blue pills represent Discrete fields, which create headers. Most commonly, measures are continuous (Green).
- Question 5Intermediate
Sharing Insights · Dashboard design
You are designing a dashboard for a mobile workforce. You want to ensure that when the dashboard is viewed on a smartphone, the layout adjusts automatically to fit the smaller screen vertically. Which feature should you use?
Show answer & explanation
Correct answer: B
Device Designer allows you to create specific layouts for different device types (Desktop, Tablet, Phone). By defining a Phone layout, you can rearrange, resize, or remove dashboard objects specifically for mobile viewing without affecting the default desktop view.
- Question 6Intermediate
Exploring & Analyzing Data · Creating charts
You want to create a Dual Axis chart to compare 'Sales' (Bar chart) and 'Profit Ratio' (Line chart) over time. After dragging the second measure to the opposite axis, you notice the trends are misleading because the axes scales are vastly different. What is the standard best practice step to fix this relative comparison?
Show answer & explanation
Correct answer: A
When using Dual Axis charts with measures of similar magnitude or when direct comparison of magnitude is required, synchronizing axes ensures that both sides use the same scale. Note: If measures have different formats (e.g., Currency vs Percentage), you might intentionally NOT synchronize, but for similar units, synchronization prevents misleading visual correlations.
Ready for the real thing?
The full Analytics-101 simulator has every exam-style question, timed mode, and instant scoring.