Tableau-Desktop-Found Connecting to and Preparing Data Practice Question
You have a dataset with columns 'Date', 'Region', 'Sales', and 'Profit'. You need to reshape the data so that 'Sales' and 'Profit' are in a single column called 'Measure Name' and their values are in a 'Measure Value' column. Which TWO steps should you take?
⚠ Common exam trap
Candidates frequently attempt to use a calculated field or a join to reshape data. They overlook the Pivot feature in the Data Source tab, which is specifically designed for this wide-to-long transformation.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Select 'Sales' and 'Profit' columns in the Data Source tab.
To convert wide data into long format, use the Pivot function in the Data Source tab. Selecting the columns and applying the pivot operation creates the necessary long-form structure. This is critical for creating charts that compare multiple measures effectively, as it allows Tableau to treat 'Sales' and 'Profit' as values within a single categorical dimension.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Select 'Sales' and 'Profit' columns in the Data Source tab.
Why this is correct
Selecting the columns is the mandatory first step to initiate the pivot transformation. By highlighting these specific columns, you inform Tableau which data points need to be reshaped into rows to facilitate easier analysis of multiple metrics simultaneously within your visualization environment.
- ✓
Right-click the selected columns and select Pivot.
Why this is correct
Selecting the Pivot option from the context menu is the trigger that performs the structural change. This transformation converts the selected headers into a new column, 'Pivot Field Names', and the data into 'Pivot Field Values', which can then be renamed for clarity.
- ✗
Create a calculated field to join the columns.
Why it's wrong here
Calculated fields cannot reshape the underlying table structure in the way a pivot does. Attempting to concatenate or join values via calculations is inefficient and does not result in the proper long-format structure required for effective multi-measure analysis in Tableau visualizations.
- ✗
Drag 'Measure Names' to the filter shelf.
Why it's wrong here
Dragging Measure Names to the filter shelf allows you to select which measures appear in the view, but it does not change the physical structure of your data source. It is an analytical step, not a data preparation or reshaping step.
- ✗
Use the Split function on the 'Date' column.
Why it's wrong here
The Split function is intended for extracting parts of a string or parsing delimited text. It has no relevance to the task of pivoting measures or reshaping the data format. Applying it to a date field would not assist in achieving the desired wide-to-long transformation.
About these practice questions
One of 126 original Tableau-Desktop-Found practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.