Alteryx: Real-Life Exercises For Data Analytics!
4.1 (375 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,041 students enrolled

Alteryx: Real-Life Exercises For Data Analytics!

Master Alteryx for Data Analytics step-by-step. Real-Life Exercises & Quizzes included. Learn by doing!
4.1 (375 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,041 students enrolled
Created by Renato Baruti
Last updated 5/2020
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 1 article
  • 41 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
  • The basic course "Alteryx: Self-Service Analytics In Your Hands" is a pre-requisite
  • Students already need to have Alteryx Designer installed

Learn Alteryx through Real-Life Exercises and deliver deeper insights for key business decision-making in hours, not weeks. 

In this hands-on Alteryx training you'll experience and solve real-world analytics problems easily and quickly that will allow you to cleanse, prepare, fix, and explore data and the endless opportunities of self-service data analytics.

An era where organizations are focused on real-time data to solve problems, a vital business decision relies on four key factors: Identify the problem, analyze the possible solutions, evaluate the possibilities that are likely to bring you closer to your goal, and make the decision. This decision can be streamlined to the hands of stakeholders by utilizing advanced analytics through the powerful data preparation and blending capabilities within Alteryx.

Use Alteryx and Analyze Data to answer complex business questions

  • Access, cleanse, and blend data from multiple sources using drag-and-drop tools
  • Discover, manage, and understand data in your organization to improve analytic productivity
  • Keep data in the database by accelerating the preparation, blending, and analysis of large sets of data

Contents and Overview

This course is meant for all skill levels. You will be on a data analytics journey from exploring the tools and the workflow canvas to robust tool utilization that will empower your data.  Each section provides new tools to use and apply what you're learning immediately.

This is your step-by-step actionable guide to solving real-life exercises and real-life use cases. Every lecture is independent, you can start in whatever section you desire.

The course is broken out in multiple sections with quizzes included. You'll learn when to transpose and join your data, how to convert string to date formats and vise-versa, which parsing methods are best for the use case scenarios, why batch macros are useful, and much more.

You'll be fully prepared to data prep, analyze, examine, and present data for deeper and faster insights.

Who this course is for:
  • 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
Course content
Expand all 38 lectures 05:35:55
+ Real-Life Exercises
23 lectures 03:26:40
Dynamic Concatenation
Date Parsing
Sample Size Summarized
Repeating Unique

Please use the formula in the resource file "First Day Month.xlsx".

First Day Month
Time Difference
Dynamic Variables
String Identifiers
Character Count
Transforming Data
Summarize Time Segments
Log Transformation
Percentage Format
Rearranging Columns
Filtering Price Differences
Merged Strings
Parse Numbers & Strings
Fuzzy Matching
Previous Value Check
Grouped Regular Expressions
Missing Values

This quiz will focus on the Real-Life Exercises lectures.

Section 1: Real-Life Exercises
3 questions
+ Real-Life Use Cases
7 lectures 01:13:53
Join to Area
Count Key Words
Data Parse Method
Delimiter Cleansing
Running Averages
Standardize Dates
Spatial Distance

This quiz will focus on the Real-Life Use Cases lectures.

Section 2: Real-Life Use Cases
3 questions
+ Excel to Alteryx Series
4 lectures 36:19
Combining Files from Single Input
Data Cleansing & Multi-Row Formulas
Date Calculations
Calculating Rates

This quiz will focus on the Excel to Alteryx Series lectures.

Section 3: Excel to Alteryx Series
3 questions
+ Batch Macros
1 lecture 05:44
Batch Macro Multiplier

This quiz will focus on the Batch Macro Multiplier lecture.

Section 4: Batch Macros
3 questions
+ In-Database
2 lectures 13:17
In-Database Connection
In-Database Joining & Aggregation

This quiz will focus on the In-Database section.

Section 5: In-Database
3 questions
+ Bonus! Tips & Tricks
1 lecture 00:02
Inspire 2017 Tips & Tricks