Alteryx Masterclass - Let's Get Started
Master the fundamentals of Alteryx for data cleaning and data preparation.
Updated on Sep, 2023
Language - English
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
Goals
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
Curriculum
Check out the detailed breakdown of what’s inside the course
Let's Explore Alteryx
35 Lectures
-
Introduction
01:11
01:11
-
Alteryx Interface
08:44
08:44
-
How to Get Our Data in Alteryx
13:45
13:45
-
Connecting to a SQL Database
04:32
04:32
-
Using the Browse Tool and Saving Cleaned Data
06:02
06:02
-
Using the Select Tool
10:05
10:05
-
Auto Field
04:36
04:36
-
Data Cleansing
10:27
10:27
-
The Filter Tool Deep Dive
09:19
09:19
-
Using the Formula Tool
12:05
12:05
-
Data Preparation in Alteryx
10:04
10:04
-
Imputation – Dealing with Missing Values
06:41
06:41
-
Binning in Alteryx
08:02
08:02
-
Performing Multiple Calculations at Once
10:01
10:01
-
Multi-Row Formula and Where to Use It
08:57
08:57
-
Other Useful Tools
08:54
08:54
-
Classifying Your Data in Tiles in Alteryx
07:31
07:31
-
Combining Data
06:52
06:52
-
Cleaning Data with the Find and Replace Tool
05:48
05:48
-
Using the Append Tool in Alteryx with Caution
04:00
04:00
-
Using the Make Group Aka Make Friends Tool in Alteryx
03:37
03:37
-
How to Match Fields that Do not Match in Alteryx
06:59
06:59
-
Joining in Alteryx
12:16
12:16
-
Parsing Tools and How to Use them in Alteryx - 1
08:35
08:35
-
Parsing Tools and How to Use them in Alteryx - 2
08:03
08:03
-
Transforming Data in Alteryx
07:51
07:51
-
Pivoting and Unpivoting
09:44
09:44
-
Alteryx Cumulative Sales
06:38
06:38
-
Aggregation with Summarize
09:06
09:06
-
Weighted Average Calculation in Alteryx
05:35
05:35
-
Dynamics - Additional Useful Tools in Alteryx
07:32
07:32
-
How to Combine Multiple Excel Tabs into Alteryx
07:05
07:05
-
Webscraping - How to Get Foreign Exchange Rates
11:00
11:00
-
Webscraping - Getting Tables from Websites with Python
09:02
09:02
-
Final Words and Case Study
00:54
00:54
Instructor Details
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.
Our students work
with the Best
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now