Tableau Connecting & Preparing Data 3

Question 1

What does the Data Interpreter feature in Tableau help with?

Accepted Answer

Cleaning messy spreadsheets with titles, footnotes, and merged cells

Answer

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?

Accepted Answer

Pivot

Answer

Pivoting converts wide column-based data into rows for easier analysis.

Question 3

The Split function on a field is used to do what?

Accepted Answer

Separate one column into multiple based on a delimiter

Answer

Split breaks a single field into several fields using a separator character.

Question 4

What is a cross-database join in Tableau?

Accepted Answer

A join combining tables from different data sources

Answer

Cross-database joins combine tables that reside in different databases or connections.

Question 5

When is data blending typically preferred over a join?

Accepted Answer

When combining data at different levels of granularity from separate sources

Answer

Blending aggregates secondary source data to the primary source's level, useful across differing granularities.

Tableau Practice Test