Alteryx: Real-Life Exercises For Data Analytics!

Master Alteryx for Data Analytics step-by-step. Real-Life Exercises & Quizzes included. Learn by doing!

Created by: Renato Baruti
Founder and CEO at Baruti Analytics | Author

What Will I Learn?

• Create Averages with outliers
• Create dynamic concatenations
• Create robust Regular Expressions formulas
• Understand types of Joins and how they work
• Parse data using Text to Columns
• Create Percentage Format
• Convert date to string formats and string to date formats
• Create Generate Rows for loop expressions
• Work with Transposing and Appending data
• Perform Log Transformations
• Create Time Differences
• Combine Merged Strings
• Create Running Averages
• Determine distance using Spatial tools
• Find Missing Values
• Create Batch Macros
• Create In-Database Connection
• Create In-Database Joining and Aggregation
• Work with Fuzzy Matching
• Count Key Words
• Combine Files from Single Input
• Create Multi-Row Formulas
• Perform Data Cleansing
• Create Dynamic Variables

Requirements

• The basic course "Alteryx: Self-Service Analytics In Your Hands" is a pre-requisite
• Students already need to have Alteryx Designer installed

Target audience

• This course is for anyone with solid beginner level skills in Alteryx
• This course is for anyone who wants to take their Alteryx skillset to the next level