Alteryx MasterClass - Lets get started

Name: Alteryx MasterClass - Lets get started
Rating: 4.7 (88 reviews)

How to master Alteryx fundamentals data prepraration and data cleaning with Alteryx. Alteryx for data analysts scientist

Highest Rated

Created byDan We

Last updated 3/2024

English

What you'll learn

All you need to clean your data fast and efficiently
You learn the fundamentals of Alteryx Designer
New job opportunities knock on your door
You can easily prepare your data in advance to visualize it later in Tools like Tableau or Power BI
You extend your data analytics knowledge
You can do ETL without coding
You can clean and shape your data the way you need it

Course content

1 section • 39 lectures • 4h 32m total length

Hello Altery - Introduction1:11
Important - before you start0:22
Download all resources here0:02
2 Alteryx - Lets explore the interface8:44
3 How to get our data into alteryx13:45
4 How to connect to a SQL database in practise4:32
5 How to use the browse tool and saving cleaned data6:02
Explore the browse tool to inspect cleaned data and view the full dataset, then save the prepared data with the output data tool to a file.
6 Select tool - all you need to know10:05
7 Auto Field - let Alteryx figure out the correct datatype4:36
8 Data Cleansing fast and efficient10:27
9 The Filter tool - a deep dive9:19
10 The formula tool and how to use it12:05
11 Data Preparation with Generate Rows in Alteryx10:04
Learn to use the generate rows tool to duplicate data rows with a loop, creating a date field from start to end dates.
12 Data Preparation - Imputation - Dealing with missing values6:41
Explore imputation to handle missing values in data preparation, choosing between average, median, mode or a user-specified value, and optionally add imputed indicators or new columns.
13 Data Preparation - Binning in Alteryx8:02
14 Data Preparation - Multiple Calculations at once in Alteryx10:01
15 Data Preparation - Multi Row Formula Tool and where to use it8:57
16 Data Preparation other useful tools in Alteryx8:54
17 Data Preparation - Classifying your data in Tiles in Alteryx7:31
18 Combining Data - How to use the Union Tool in Alteryx6:52
19 Cleaning data with the Find and Replace Tool in Alteryx5:48
20 Using the Append Tool in Alteryx with caution4:00
21 How to use the Make Group aka make Friends tool in Alteryx3:37
22 How to match fields which do not match in Alteryx - fuzzy match6:59
23 Joining in Alteryx - available options12:16
24 Parsing Tools and how to use them in Alteryx 18:35
25 Parsing Tools and how to use them in Alteryx 2 Regex8:03
26 Transforming Data in Alteryx Arrange and Count Records7:51
27 Pivoting and Unpivoting - Cross Tab and Transpose in Alteryx9:44
28 Alteryx Cummulative Sales - Running Total and how it works6:38
29 Aggregation with Summarize - Most important tool9:06
30 Weighted Average Calculation in Alteryx5:35
31 Dynamics - Additional useful tools in Alteryx7:32
32 How to combine multiple excel tabs into alteryx7:05
33 Webscraping - How to get foreign exchange rates in Alteryx11:00
34 Bonus - Webscraping - Getting Tables from Websites with Python in Alteryx9:03
NEW - A free resource for bonus videos tips and tricks0:04
35 Final Words and Case Study0:54
More learning0:26

Requirements

Your interest in data preparation and data analytics, visual analytics is key!
This MasterClass starts from scratch - we learn the basics and build a solid foundation during the case study
Alteryx Designer must be downloaded (fully functional trial version available for free)
The case study course Alteryx Masterclass - a crashcourse for beginners is optional but not required

Description

Alteryx MasterClass - Let's get started

You are interested in data analytics and business intelligence? Great! You have chosen not only a highly rewarding profession but also one of the most interesting ones of the future. Data is the oil of our century and getting the right insights at the right time will be the key competitive advantage for businesses.

This is why you are here. Companies need highly skilled people to help them analyzing their data. During this process the data aggregation and cleaning is the most challenging part. 80% of the time of data analysts and data scientists are spend with data preparation. This can be cumbersome but is crucial to derive valuable insights. Because:

"Trash in trash out!"

This is why we need to explore fast and efficient ways to prepare our data which we then want to visualize in powerful tools like Tableau or Power BI.

And now the most interesting question? How exactly can we achieve this? What are the best tools to do that, which do not require extreme programming skills?

Meet Alteryx! One of the best ETL / data preparation tools on the market. This awesome tool with an "Apple flair design" and drag and drop functionality will help us to prepare and combine even the worst kinds of data sources

This course is my answer to students request who loved the first course

Alteryx Masterclass - a crashcourse for beginners

where we go through a whole data cleaning case study in alteryx and wanted to learn more about the alteryx tools which we have not covered yet in the case study.

It is not required to take the case study but I personally believe both courses together are a great fit to help you becoming professional with alteryx.

Here we start from scratch and a fully functional trial version of the software to follow along can be downloaded for free. The only thing you need to bring with you is your personal interest and willingness to learn in a data driven age.

If that sound like you then..

Let's dive into the case study together

Are you ready?

Who this course is for:

You want to become a data analyst
Students who have taken Alteryx Masterclass - a crashcourse for beginners
You want to go into a data analyst or data scientist career
You want to learn how to effectively clean your data
You want to extend your knowlegde beyond Tableau and Power BI
You encountered various data issues (e.g. format,...) in the past and are looking for a solid solution
You want to take advantage of the data driven opportunity ahead