Connecting & Preparing Data Flashcards
7 cards from real Tableau practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Connecting & Preparing Data flashcards as text
What does the Data Interpreter feature in Tableau help with?
Answer: Cleaning messy spreadsheets with titles, footnotes, and merged cells
Data Interpreter detects and removes extraneous formatting like titles and footnotes in Excel files.
Which operation transforms columns into rows in Tableau's data source?
Answer: Pivot
Pivoting converts wide column-based data into rows for easier analysis.
The Split function on a field is used to do what?
Answer: Separate one column into multiple based on a delimiter
Split breaks a single field into several fields using a separator character.
What is a cross-database join in Tableau?
Answer: A join combining tables from different data sources
Cross-database joins combine tables that reside in different databases or connections.
When is data blending typically preferred over a join?
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.
In data blending, what defines the link between the primary and secondary data sources?
Answer: A linking field common to both sources
Blending uses a shared linking field to relate the primary and secondary sources.
Which Tableau product is dedicated to advanced visual data cleaning and shaping workflows?
Answer: Tableau Prep Builder
Tableau Prep Builder provides a visual interface for cleaning, combining, and shaping data.