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
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.
Learning Outcomes
-
Understand the different types of joins
-
Perform a data join
-
Perform a data union
-
Aggregate/summarize data
-
Transpose0dData
-
Pivot data
Lessons
1. Introducing the Dataset
2. Data Unions and Data Joins
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.
