Joining and Transforming Data
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Introducing the Dataset
Introducing the Dataset
This lesson provides a brief course overview and introduces the dataset we'll use in the first half of the course.
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.
Unioning Data
Unioning Data
In this lesson, we learn how to use the Union tool to bring together records vertically from separate files with the same data structure.
Joining Multiple Datasets
Joining Multiple Datasets
In this lesson, you will learn how to use the Join Multiple tool to bring together all data from multiple sources.
Performing a Data Join
Performing a Data Join
In this lesson, we learn how to use the Join tool to horizontally merge records from two datasets.
Outer Joins
Outer Joins
In this lesson, we'll learn how to create an outer join by combining the outputs from a Join tool.
Analyzing Profitability and Trends
Analyzing Profitability and Trends
In this lesson, we provide an overview on the data used and analysis performed in the remaining lessons.
Preparing Data for Analysis
Preparing Data for Analysis
Apply tools from previous courses as we prepare for our analysis by merging and cleaning our data sets.
Aggregating Data
Aggregating Data
Learn how to group and aggregate data by applying the various actions available in the Summarize tool.
Creating Calculated Fields
Creating Calculated Fields
Learn how to use the Formula tool to apply user-generated expressions to the fields in a dataset. In this case, we'll use the Formula tool to calculate profit figures.
Transposing Data
Transposing Data
Learn how to convert a dataset from a wide format to a tall format using the Transpose tool.
Pivoting Data
Pivoting Data
Learn how to convert a dataset from a tall format to a wide format using the Cross Tab tool.
