Tableau Data Connections and Preparation Questions and Answers 1 — 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?
- Data Blending
- Pivot
- Data Interpreter (Correct answer)
- Relationships
Correct answer: Data Interpreter
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?
- Inner Join
- Relationships (Correct answer)
- Full Outer Join
- Union
Correct answer: Relationships
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?
- Split
- Merge
- Union
- Pivot (Correct answer)
Correct answer: Pivot
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?
- Changing a field's data type from Number to String
- Creating a new calculated field
- Renaming a data field
- Filtering out a specific category of data (Correct answer)
Correct answer: Filtering out a specific category of data
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?
- Union
- Relationship
- Data Blending (Correct answer)
- Cross-database join
Correct answer: Data Blending
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.
Question 6: Which of the following best describes the primary difference between a live connection and a Tableau data extract?
- Live connections are always faster than extracts because they don't require data ingestion.
- Extracts create a static subset of data, which can improve performance and enable offline work. (Correct answer)
- Live connections store the data within the Tableau workbook file (.twb).
- Extracts can only be created from file-based data sources like Excel and CSV.
Correct answer: Extracts create a static subset of data, which can improve performance and enable offline work.
A Tableau data extract is a compressed snapshot of the data that is stored locally. This can significantly improve performance by reducing query load on the original data source and allows for analysis even when disconnected from the source. Live connections query the source data directly, which can be slower depending on the source system and network.
Tableau Data Connections and Preparation Questions and Answers 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?