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
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
Requirements
  • The basic course "Alteryx: Self-Service Analytics In Your Hands" is a pre-requisite
  • Students already need to have Alteryx Designer installed
Description

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
05:58
Date Parsing
07:20
Sample Size Summarized
05:37
Repeating Unique
03:53

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

First Day Month
08:40
Time Difference
10:02
Dynamic Variables
09:21
String Identifiers
05:04
Character Count
06:47
Transforming Data
14:18
Summarize Time Segments
10:57
Log Transformation
04:21
Percentage Format
03:40
Rearranging Columns
06:21
Filtering Price Differences
06:01
Merged Strings
23:36
Parse Numbers & Strings
06:55
Fuzzy Matching
18:11
Previous Value Check
07:57
Grouped Regular Expressions
15:28
Missing Values
06:04

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
10:38
Count Key Words
14:34
Data Parse Method
13:40
Delimiter Cleansing
06:28
Running Averages
13:36
Standardize Dates
10:03
Spatial Distance
04:54

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
05:19
Data Cleansing & Multi-Row Formulas
10:15
Date Calculations
08:15
Calculating Rates
12:30

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
05:44

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
02:43
In-Database Joining & Aggregation
10:34

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
00:02