Tableau Desktop Foundations Free Sample Questions

12 free sample questions136 in the full practice test

Try simulator

Analytics-101 Sample Questions

  1. Question 1

    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?

    Answer and explanation

    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.

  2. Question 2

    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?

    Answer and explanation

    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.

  3. Question 3

    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?

    Answer and explanation

    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.

  4. Question 4

    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?

    Answer and 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.

  5. Question 5

    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?

    Answer and 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.

  6. Question 6

    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?

    Answer and 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.

Register free to unlock 6 more sample questions

Lifetime One

Own this practice test forever.

$79.99
$75.99
one-time
  • Full access to 136 questions
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • Brainy AI Assistant
  • Lifetime updates

Two

Any 2 exams per month.

$20.00/exam
$39.99
/month
  • 2 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 1,000 Brainy AI Credits
  • Cancel anytime

Premium Twelve

Any 12 exams over 3 months.

$15.00/exam
$179.99
/3 months
  • 4 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 15,000 Brainy AI Credits
  • Dedicated support
  • Friend seat included — full access

Trusted by professionals at

NvidiaSupabaseGitHubOpenAITursoClerkClaude AIAmazon