Tableau Data Connections and Preparation Questions and Answers

Question 1

A business analyst is working with an Excel spreadsheet that contains multiple sub-tables, titles, and footers. When connecting this file to Tableau, the data appears disorganized. Which Tableau feature should the analyst use to automatically identify and clean the dataset?

Accepted Answer

Data Interpreter

Answer

The Data Interpreter in Tableau is designed to clean data from sources like Excel, CSV, and Google Sheets. It can automatically detect and bypass extraneous information such as titles, notes, footers, and empty cells to identify the actual fields and values in the dataset.

Question 2

You are combining two tables in Tableau. The first table contains sales transaction data at a daily level, and the second contains monthly sales targets. To avoid duplicating the monthly target for every daily transaction, which data combination method is most appropriate and flexible?

Accepted Answer

Relationships

Answer

Relationships are the recommended method for combining tables with different levels of detail (LOD). They maintain the separate nature of the tables and query them at their native LOD, preventing data duplication that would occur with a join. Joins would merge the tables into a single table, causing the monthly targets to be repeated for each day's sales.

Question 3

A data source has survey results where each question is a separate column (e.g., 'Q1_Satisfaction', 'Q2_Recommendation', 'Q3_Timeliness'). To analyze this data effectively, you need to transform these columns into two fields: one for the 'Question' and one for the 'Response'. Which data preparation action should you perform?

Accepted Answer

Pivot

Answer

Pivoting data transforms it from a wide format (crosstab) to a tall format (columnar). In this scenario, you would pivot the 'Q1_Satisfaction', 'Q2_Recommendation', and 'Q3_Timeliness' columns. This action creates two new columns: 'Pivot Field Names' (containing the original column headers like 'Q1_Satisfaction') and 'Pivot Field Values' (containing the corresponding responses).

Question 4

When working with data in the Data Source page, which of the following is NOT considered a metadata management task in Tableau?

Accepted Answer

Filtering out a specific category of data

Answer

Metadata management involves managing the structure and properties of the data, not the data itself. Changing data types, renaming fields, and creating calculated fields are all modifications to the metadata. Filtering data, however, is an operation that removes rows of data from the dataset being used in the visualization, which is a data-level operation, not a metadata change.

Question 5

An analyst needs to combine data from a published Tableau Server data source with a local Excel file. A join is not possible. Which method should be used to bring data from both sources into a single worksheet?

Accepted Answer

Data Blending

Answer

Data blending is the appropriate method when you need to combine data from a published Tableau Server data source with another source, like a local Excel file. Relationships and joins cannot be created with published data sources. Data blending queries each data source independently and then aggregates the results in the view.

Tableau Practice Test

Tableau Practice Test

Tableau Data Connections and Preparation Questions and Answers