Course
|
Alteryx

Joining and Transforming Data

Joining data is a fundamental data preparation skill, but that doesn't mean that it's easy. We've configured this course to ensure that the users have a much stronger grasp of this essential skill. This course covers the basics of unions, joins, pivoting, and transposing data.
3 HOURS
Beginner
15 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand the different types of joins
Perform a data join
Perform a data union
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Alteryx

Joining and Transforming Data

Joining data is a fundamental data preparation skill, but that doesn't mean that it's easy. We've configured this course to ensure that the users have a much stronger grasp of this essential skill. This course covers the basics of unions, joins, pivoting, and transposing data.
3 HOURS
Beginner
15 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand the different types of joins
Perform a data join
Perform a data union
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

15 Lessons
Introducing the Dataset
3 MINS
LESSON
Introducing the Dataset
Exercise

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
5 MINS
LESSON
Data Unions and Data Joins
Exercise

Here we'll introduce the concept of data unions and data joins from a purely theoretical perspective.

Unioning Data
3 MINS
LESSON
Unioning Data
Exercise

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
6 MINS
LESSON
Joining Multiple Datasets
Exercise

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
5 MINS
LESSON
Performing a Data Join
Exercise

In this lesson, we learn how to use the Join tool to horizontally merge records from two datasets.

Outer Joins
5 MINS
LESSON
Outer Joins
Exercise

In this lesson, we'll learn how to create an outer join by combining the outputs from a Join tool.

Analyzing Profitability and Trends
3 MINS
LESSON
Analyzing Profitability and Trends
Exercise

In this lesson, we provide an overview on the data used and analysis performed in the remaining lessons.

Preparing Data for Analysis
7 MINS
LESSON
Preparing Data for Analysis
Exercise

Apply tools from previous courses as we prepare for our analysis by merging and cleaning our data sets.

Aggregating Data
5 MINS
LESSON
Aggregating Data
Exercise

Learn how to group and aggregate data by applying the various actions available in the Summarize tool.

Creating Calculated Fields
8 MINS
LESSON
Creating Calculated Fields
Exercise

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
4 MINS
LESSON
Transposing Data
Exercise

Learn how to convert a dataset from a wide format to a tall format using the Transpose tool.

Pivoting Data
5 MINS
LESSON
Pivoting Data
Exercise

Learn how to convert a dataset from a tall format to a wide format using the Cross Tab tool.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo