Reshaping Data in Tableau Prep
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Introducing the Dataset
Introducing the Dataset
This lesson introduces the datasets that we will be using in this course. All datasets relate to the fees generated by a pharmaceuticals company distribution company.
Data Unions and Data Joins
Data Unions and Data Joins
Here we'll introduce the concept of data unions and data joins from a purely theoretical perspective.
Performing a Wildcard Data Union
Performing a Wildcard Data Union
In this lesson, we learn how to use the wildcard union feature in the input data step to bring together records vertically from separate sheets files with the same data structure.
Unioning Data in the Flow Pane
Unioning Data in the Flow Pane
We continue the unioning process through the use of the union step, which can vertically join data from separate input steps.
Performing a Data Join
Performing a Data Join
In this lesson, we learn how to use the join step to bring together records horizontally.
Aggregating Data
Aggregating Data
Occasionally, an analysis requires a change to the granularity of the dataset. In this lesson, we'll explain what data granularity is and how to use the Aggregate step.
Pivoting Crosstab Datasets
Pivoting Crosstab Datasets
The shape of a dataset can vary from tall and narrow to short and wide. In this lesson we show how to convert wide datasets to narrow and why Tableau Desktop prefers taller datasets.
