Free Tableau Connecting & Preparing Data Questions and Answers 1 — Questions and Answers
Question 1: A business analyst is working with a sales dataset in a wide format, where each column represents a different month (e.g., 'Jan Sales', 'Feb Sales', 'Mar Sales'). To effectively analyze sales trends over time, the data needs to be restructured so that all monthly sales figures are in a single column and the month names are in another. Which Tableau feature should the analyst use on the Data Source page to achieve this transformation?
- Split
- Data Interpreter
- Pivot (Correct answer)
- Join
Correct answer: Pivot
The Pivot feature in Tableau is designed to transform data from a wide format (crosstab) to a tall format (columnar). By selecting the monthly sales columns and applying a pivot, the analyst can create two new fields: one containing the column headers (months) and another containing the corresponding values (sales figures), which is the desired structure for time-series analysis.
Question 2: You are connecting to an Excel file that was formatted for human readability. It includes a title in the first row, a blank row for spacing, and then the actual data table with headers. When you connect to this file in Tableau, the fields are not correctly identified. Which feature should you use first to automatically clean up this type of extraneous formatting?
- Data Interpreter (Correct answer)
- Create Calculated Field
- Union
- Manage Metadata
Correct answer: Data Interpreter
Tableau's Data Interpreter is a tool specifically designed to clean messy datasets, such as Excel files with titles, notes, empty cells, or footers. It automatically detects the actual data table within the file, bypassing the extra formatting, which allows Tableau to correctly identify the fields and values for analysis.
Question 3: An analyst needs to combine sales data from a corporate SQL database with sales targets stored in a separate Google Sheet. Which method is most appropriate for combining these two disparate data sources within Tableau for analysis on a single worksheet?
- Join
- Union
- Data Blending (Correct answer)
- Relationship
Correct answer: Data Blending
Data blending is the correct method when you need to combine data from different, or disparate, data sources, such as a SQL database and a Google Sheet. Joins and Relationships are used to combine tables from the same data source. Data blending works by querying each data source independently and then aggregating the results together in the view at the worksheet level.
Question 4: A Tableau user needs to build a dashboard for a high-traffic sales floor where monitoring real-time data is critical. The underlying database is powerful and updated every few seconds. Which type of data connection should be used to ensure the dashboard reflects the most current information without manual intervention?
- Extract with a scheduled refresh every minute
- Published Data Source
- Live Connection (Correct answer)
- Saved Data Source (.tds)
Correct answer: Live Connection
A Live Connection directly queries the underlying database, ensuring that the visualizations always display the most up-to-date data. This is ideal for scenarios requiring real-time or near real-time monitoring. An extract, even if refreshed frequently, would still be a snapshot and introduce latency.
Question 5: After connecting to a data source, you notice a field named 'Cust_ID' which represents the customer identification number. To improve clarity for other users of the data source, you want to change its name to 'Customer ID' within Tableau. This action is an example of:
- Creating a Calculated Field
- Splitting a Column
- Managing Metadata (Correct answer)
- Creating a Hierarchy
Correct answer: Managing Metadata
Managing metadata involves modifying the properties of the data fields within Tableau without changing the underlying data source. Renaming a field, changing its data type, assigning a geographic role, or adding a default comment are all examples of metadata management.
Question 6: Which of the following scenarios is the primary reason to use a Tableau Extract over a Live Connection?
- When the underlying data changes constantly and requires real-time analysis
- When you need to reduce the query load on a production database and improve dashboard performance (Correct answer)
- When the dataset is very small and the source database is extremely fast
- When you need to combine tables from two different databases
Correct answer: When you need to reduce the query load on a production database and improve dashboard performance
Tableau Extracts are snapshots of data that are optimized for performance and stored in Tableau's high-performance data engine. Using an extract is a best practice when the source database is slow or when you want to minimize the query load on a critical production system. Extracts generally provide faster performance for complex dashboards.
Free Tableau Connecting & Preparing Data Questions and Answers 1
A business analyst is working with a sales dataset in a wide format, where each column represents a different month (e.g., 'Jan Sales', 'Feb Sales', 'Mar Sales').
To effectively analyze sales trends over time, the data needs to be restructured so that all monthly sales figures are in a single column and the month names are in another.
Which Tableau feature should the analyst use on the Data Source page to achieve this transformation?