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

English [Auto],

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
Learn data cleaning, and consolidate data from SQL Server and Excel with Alteryx, then visualize results using Tableau or Power BI to solve real-world business challenges.
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
Learn to import, configure, and union multiple CSV files in Alteryx by correcting delimiters, applying UTF-8 encoding, and using a star pattern to stack all 'transactions' files into one output.
3 How to import multiple sheets from one excel file into alteryx fast6:29
Import multiple sheets from a single excel file into Alteryx by using sheet names and the dynamic input tool to stack five hotel p&l sheets with identical structure.
4 Importing multiple sheets from one excel file - cleaning process13:33
Clean and restructure the Excel data by removing nulls, skipping initial rows, promoting first-row headers, renaming fields, converting to floats, and transposing to a flat table for Tableau visualization.
5 How to import multiple excel files with multiple sheets into Alteryx fast8:58
Learn to import multiple Excel files with many sheets into Alteryx fast using a free Chaos Reigns macro, handling identical structures and skipping header rows.
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
Learn to use containers to enable or disable workflow parts, cache and run large data flows, and tune user settings and annotations for clearer Alteryx workflows.
8 Leverage the find and replace tool for joining messy data9:43
Learn how to use the find and replace tool to join messy data on a string field, using case-insensitive matching and field name handling to merge two Excel sheets.
9 Use cases for the append tool - understand when and how to use it10:01
Master when and how to use the append tool in Alteryx, avoiding unwanted Cartesian products and knowing alternatives like join or find and replace.
10 Find and replace - How to deal with messy customer address data in alteryx15:02
master the find and replace tool in alteryx to clean messy data using a lookup table of replacements, handling special characters, and exporting a clean dataset.
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
Explore spatial analytics in Alteryx, creating points from latitude and longitude, building trade areas, and using spatial match, find nearest, and distance tools to target customers within a radius.
14 For interested students - my current personal project - work in progress3:33
Demonstrate reading PDF tables in Alteryx by using a PDF table reader macro, inputting file path and page for two-page tables, and previewing results with a browse tool.
15 Gimmicks let's play games in alteryx3:39
Explore Alteryx gimmicks and built-in games like Space Invaders, Pong, and data breaker, accessible via help and about or a ctrl-double click, for lighthearted breaks between workflows.
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