Tableau Connecting & Preparing Data 3 — Questions and Answers
Question 1: What does the Data Interpreter feature in Tableau help with?
- Cleaning messy spreadsheets with titles, footnotes, and merged cells (Correct answer)
- Writing SQL queries
- Building dashboards
- Scheduling extract refreshes
Correct answer: Cleaning messy spreadsheets with titles, footnotes, and merged cells
Data Interpreter detects and removes extraneous formatting like titles and footnotes in Excel files.
Question 2: Which operation transforms columns into rows in Tableau's data source?
- Pivot (Correct answer)
- Union
- Join
- Split
Correct answer: Pivot
Pivoting converts wide column-based data into rows for easier analysis.
Question 3: The Split function on a field is used to do what?
- Separate one column into multiple based on a delimiter (Correct answer)
- Merge two columns
- Remove null values
- Aggregate values
Correct answer: Separate one column into multiple based on a delimiter
Split breaks a single field into several fields using a separator character.
Question 4: What is a cross-database join in Tableau?
- A join combining tables from different data sources (Correct answer)
- A join within a single Excel sheet
- A union of CSV files
- A blend of extracts
Correct answer: A join combining tables from different data sources
Cross-database joins combine tables that reside in different databases or connections.
Question 5: When is data blending typically preferred over a join?
- When combining data at different levels of granularity from separate sources (Correct answer)
- When all data is in one table
- When you need a full outer join
- When pivoting columns
Correct answer: When combining data at different levels of granularity from separate sources
Blending aggregates secondary source data to the primary source's level, useful across differing granularities.
Question 6: In data blending, what defines the link between the primary and secondary data sources?
- A linking field common to both sources (Correct answer)
- A calculated field only
- The first column alphabetically
- The extract file name
Correct answer: A linking field common to both sources
Blending uses a shared linking field to relate the primary and secondary sources.
Question 7: Which Tableau product is dedicated to advanced visual data cleaning and shaping workflows?
- Tableau Prep Builder (Correct answer)
- Tableau Reader
- Tableau Public
- Tableau Mobile
Correct answer: Tableau Prep Builder
Tableau Prep Builder provides a visual interface for cleaning, combining, and shaping data.
Tableau Connecting & Preparing Data 3
What does the Data Interpreter feature in Tableau help with?