Alteryx Masterclass - solving real world business challenges

Name: Alteryx Masterclass - solving real world business challenges
Rating: 4.2 (220 reviews)

Learn to work faster, more efficiently and have fun with Alteryx

Created byDan We

Last updated 3/2024

English

What you'll learn

You will improve your knowlege in working with Alteryx
You can easily prepare your data in advance to visualize it later in Tools like Tableau or Power BI
fast and efficient data cleansing without coding
potential new job opportunities
various alteryx tools, fuzzy matching, find replace, dynamic input, dynamic select, helpul macros, spacial analytics and more

Course content

1 section • 21 lectures • 2h 18m total length

Course introduction2:12
Ressources - learning material0:02
One important thing before you start0:24
2 How to import configure and union multiple csv files in Alteryx fast9:13
3 How to import multiple sheets from one excel file into alteryx fast6:29
4 Importing multiple sheets from one excel file - cleaning process13:33
5 How to import multiple excel files with multiple sheets into Alteryx fast8:58
6 Quick look at how to connect to SQL Databases4:00
Learn to connect Alteryx to a SQL Server database using the input tool, test connections, and import tables for ETL and data cleaning directly from a server.
7 Tips and Tricks - user settings, workflow cashing and more13:11
8 Leverage the find and replace tool for joining messy data9:43
9 Use cases for the append tool - understand when and how to use it10:01
10 Find and replace - How to deal with messy customer address data in alteryx15:02
11 Fuzzy match - How to clean a customer list with lots of misspelled names10:30
Master the fuzzy match tool to clean a messy customer list with misspelled names and create a unique, deduplicated dataset for accurate customer records.
12 Fuzzy Match Use case continuation in alteryx11:16
Combine two data sources with a union, apply fuzzy match on addresses using a configurable threshold, and map record IDs to identify accurate matches.
13 - Spatial analytics in alteryx - which customers should we target15:30
14 For interested students - my current personal project - work in progress3:33
15 Gimmicks let's play games in alteryx3:39
Your input is needed - share your thoughts and ideas0:09
NEW - A free resource for bonus videos tips and tricks0:04
16 Logout0:33
Apply your new data analytics and visual analytics skills with Alteryx, celebrate your progress, and explore additional courses on visual analytics, machine learning, and artificial intelligence.
More learning0:26

Requirements

I would suggest first starting with my Alteryx Masterclass - crash course in alteryx for beginners course
You should have worked with alteryx before (basic knowledge)
Alteryx Designer must be downloaded (fully functional trial version available for free)
Your personal interest

Description

Master Alteryx to solve your daily data issues at work - fast, efficient and by having fun

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 analyts 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 clean and combine even the worst kinds of datasources

This course is the cosecutive of the Alteryx Masterclass series. If you have no prior knowledge I would highly recommend to do the "Alteryx Masterclass - crash course in alteryx for beginners" course first!

This course is about extending your prior knowledge and help you solve often seen data issues in a fast and efficient way. I hope I can provide additional tips and tricks to help you leverage the power of alteryx to get thinks done.

So why waiting?

Let's get into it!

Who this course is for:

students who have successfully gone through my first alteryx course
students who are interested in data preparation (ETL) in a fast and efficient way (with or without coding)
students who face data cleansing issues at their job
students interested in a market leading ETL data cleansing software