Alteryx Masterclass : Let's Get Started

Preview this course
Enroll £132.59 £106.07
30-Day Money-Back Guarantee
Full Lifetime Access.

- OR -

Get this course, plus 250+ of our top-rated AI & Data courses, with a Subscription.
Enjoy a Free Trial. Cancel Anytime.
43 on-demand videos & exercises
Level: Beginner
English
4hrs 32mins
Access on mobile, web and TV

Who's this course for?

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.

What you'll learn

  • 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

Key Features

  • Grasp the fundamentals of Alteryx
  • Clean and prepare data in Alteryx
  • Derive insights from your data

Course Curriculum

01

Let_s Explore Alteryx

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

What to know about this course

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

About the Author

Data Circuit


We use cookies to provide you with an optimal experience and relevant communication. Learn more or accept individual cookies.

Necessary

Necessary cookies (First Party Cookies) are sometimes called "strictly necessary" as without them we cannot provide the functionality that you need to use this website. For example, essential cookies help remember your preferences as you navigate through the online school.

Functional

Functional cookies enable this website to provide enhanced functionality and personalization, by remembering information you have entered and choices you make. These preferences are remembered through the use of persistent cookies, so that you will not have to set them again the next time you visit the website.

Analytics

Analytics cookies track information about visits on our website so that we can measure and improve its performance, as well as optimize our course content. These cookies help us analyze user behavior by tracking the number of visits, how visitors use the website, which site or page they come from and how long they are staying for.

Marketing

Marketing cookies are used to deliver advertising material relevant to you and your interests. They are also used to limit the number of times you see an advertisement, resulting to more targeted advertising, as well as help us measure the effectiveness of our campaigns. They are usually placed by advertising networks we collaborate with, with our permission.