Alteryx Masterclass - Let's Get Started
Master the fundamentals of Alteryx for data cleaning and data preparation.
IT & Software,ITIL Certification,Alteryx
Lectures -35
Duration -4.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point 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
Goals
- 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
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now