Alteryx Masterclass - Let's Get Started

person icon Packt Publishing

Alteryx Masterclass - Let's Get Started

Master the fundamentals of Alteryx for data cleaning and data preparation.

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Packt Publishing

architecture icon IT & Software,ITIL Certification,Alteryx


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

This course is for aspiring data analysts who are looking for a successful career in data analytics and want to further their knowledge beyond Tableau and PowerBI.

Alteryx is a data preparation and cleaning tool used mainly by data scientists to clean and prepare data. Its effectiveness lies in its user-friendly interface and variety of tools that can be used for data analysis. In this course, you’ll learn the fundamentals of Alteryx and work on preparing and deriving insights from your data.

You’ll begin by getting an introduction to Alteryx and learn how to get your data into Alteryx. You’ll learn how Alteryx cleans data in an efficient way, and how to use this to your advantage. You’ll use tools such as ‘union’ and ‘replace’ to combine and clean your data, ‘cross tab’ and ‘transpose’ to pivot your data, and a host of additional useful tools to learn the dynamics of Alteryx. You’ll also work on a case study to cement your knowledge of Alteryx.

By the end of this course, you’ll be a confident data scientist with the knowledge of Alteryx to clean and prepare your data in the best way possible.

The code bundle for this course is available at https://github.com/PacktPublishing/Alteryx-MasterClass---Let-s-Get-Started


What will you learn in this course:

  • Get data into Alteryx
  • Clean and save your data
  • Prepare data using different tools in Alteryx
  • Combine data using the union tool
  • Use additional useful tools in Alteryx
  • Work on a case study in Alteryx
Alteryx Masterclass - Let's Get Started


Check out the detailed breakdown of what’s inside the course

Let's Explore Alteryx
35 Lectures
  • play icon Introduction 01:11 01:11
  • play icon Alteryx Interface 08:44 08:44
  • play icon How to Get Our Data in Alteryx 13:45 13:45
  • play icon Connecting to a SQL Database 04:32 04:32
  • play icon Using the Browse Tool and Saving Cleaned Data 06:02 06:02
  • play icon Using the Select Tool 10:05 10:05
  • play icon Auto Field 04:36 04:36
  • play icon Data Cleansing 10:27 10:27
  • play icon The Filter Tool Deep Dive 09:19 09:19
  • play icon Using the Formula Tool 12:05 12:05
  • play icon Data Preparation in Alteryx 10:04 10:04
  • play icon Imputation – Dealing with Missing Values 06:41 06:41
  • play icon Binning in Alteryx 08:02 08:02
  • play icon Performing Multiple Calculations at Once 10:01 10:01
  • play icon Multi-Row Formula and Where to Use It 08:57 08:57
  • play icon Other Useful Tools 08:54 08:54
  • play icon Classifying Your Data in Tiles in Alteryx 07:31 07:31
  • play icon Combining Data 06:52 06:52
  • play icon Cleaning Data with the Find and Replace Tool 05:48 05:48
  • play icon Using the Append Tool in Alteryx with Caution 04:00 04:00
  • play icon Using the Make Group Aka Make Friends Tool in Alteryx 03:37 03:37
  • play icon How to Match Fields that Do not Match in Alteryx 06:59 06:59
  • play icon Joining in Alteryx 12:16 12:16
  • play icon Parsing Tools and How to Use them in Alteryx - 1 08:35 08:35
  • play icon Parsing Tools and How to Use them in Alteryx - 2 08:03 08:03
  • play icon Transforming Data in Alteryx 07:51 07:51
  • play icon Pivoting and Unpivoting 09:44 09:44
  • play icon Alteryx Cumulative Sales 06:38 06:38
  • play icon Aggregation with Summarize 09:06 09:06
  • play icon Weighted Average Calculation in Alteryx 05:35 05:35
  • play icon Dynamics - Additional Useful Tools in Alteryx 07:32 07:32
  • play icon How to Combine Multiple Excel Tabs into Alteryx 07:05 07:05
  • play icon Webscraping - How to Get Foreign Exchange Rates 11:00 11:00
  • play icon Webscraping - Getting Tables from Websites with Python 09:02 09:02
  • play icon Final Words and Case Study 00:54 00:54

Instructor Details

Packt Publishing

Packt Publishing

Founded in 2004 in Birmingham, UK, Packt's mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.

Working towards that vision, we have published over 6,500 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done - whether that's specific learning on an emerging technology or optimizing key skills in more established tools.

As part of our mission, we have also awarded over $1,000,000 through our Open Source Project Royalty scheme, helping numerous projects become household names along the way.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best


Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us