Skip to main content
Introduction to Alteryx

Joining and Transforming Data

Bringing together multiple datasets can hugely expand the scale and scope of your data analysis projects. In this course, you’ll get to grips with the different tools Alteryx provides to union, join, pivot and transpose your data.

Beginner        15 Lessons        150 Minutes        CPD Credits
Start Today

About This Course

As your data projects grow in complexity you will find yourself looking to Alteryx’s more advanced tools. This course introduces some of these tools, beginning with the concept of data joins.

You will learn the various join types available in Alteryx and the appropriate use case for each. You will use the Filter and Summarize tools to extract specific results. You will also transform your data with the transpose and pivot tools.

By the end of this course, you will be well primed to bring together data from different sources, before combining and transforming it using the vast array of tools available in Alteryx.

Start Today

Learning Outcomes

  • Understand the different types of joins
  • Perform a data join
  • Perform a data union
  • Aggregate/summarize data
  • Transpose0dData
  • Pivot data


1. Introducing the Dataset
2. Data Unions and Data Joins
3. Unioning Data
4. Joining Multiple Datasets
5. Performing a Data Join
6. Outer Joins

Read More

7. Analyzing Profitability and Trends
8. Preparing Data for Analysis
9. Aggregating Data
10. Creating Calculated Fields
11. Transposing Data
12. Pivoting Data
13. Comparing Quartiles and Quintiles
14. Grouping Data
15. Count Records and Append Fields Tools
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world