Alteryx Masterclass: Advanced Data Analytics Training

Name: Alteryx Masterclass: Advanced Data Analytics Training
Rating: 3.9 (4 reviews)

Level up your data analysis skills and master Alteryx with this advanced training course!

Created bySimon Sez IT

Last updated 11/2022

English

What you'll learn

Using multiple files and Calgary
Sampling data and using wild matches
Data cleansing, manipulation, binning, and grouping
Using RegEx (regular expressions) and parsing XML
Working with In-Database
Blending, selecting, and summarizing data
Taking your apps and macros to the next level
Using iterative and batch macros
Understanding app errors and conditions
Customizing apps and macros
All about Machine Learning and the Alteryx Intelligence Suite

Course content

5 sections • 30 lectures • 4h 4m total length

Introduction to the Course4:03
Explore how Alteryx enables self-service data preparation, cleansing, etl, and advanced analytics, with code free and code friendly options, plus machine learning and rpa integration.
WATCH ME: Essential Information for a Successful Training Experience2:11
DOWNLOAD ME: Course Instructor Files0:23
Using Multiple Files & Calgary9:35
Master advanced data analytics with Alteryx by building automated processes, applying dynamic actions, regex, and ML models, and using directory, filter, dynamic input, and Calgary for scalable data prep.
Sampling11:01
Tiles & Binning11:44
Explore data grouping with tiles and bins using Alteryx's tile tool and multi-field binning to create headers, record ids, and sales ranges, including equal records, equal intervals, and manual methods.
Cleaning11:09
Learn to clean data with alteryx by using the imputation tool to fill nulls in numeric fields with average, median, mode, or zero, and optimize data types and row generation.
Wild Matches & Grouping9:44
RegEx & Parsing XML9:36
Master regular expressions to match, parse, tokenize, and replace data across codes, logs, and documents, using regex tools to clean csv data in Alteryx and Tableau.
Gathering Numbers9:39
Utilize Alteryx transform tools to summarize and rearrange data, compute weighted averages using quantity as weight and gross income, and build running totals by branch and product line for reporting.
Section Quiz

Level-up Your Apps & Macros Part 110:12
Learn to level up your apps and macros by building an iterative macro in Alteryx, using interface tools like a dropdown, and looping to compute total payout.
Level-up Your Apps & Macros Part 24:44
Batch Macros11:14
App Errors & Conditions11:59
Learn to build robust alteryx apps with error message and condition tools, use constants (engine, question, user), mask password input, validate credentials, and log outcomes.
App & Macro Customization9:27
Section Quiz

Machine Learning Part 110:51
Explore Alteryx Intelligence Suite's assisted modeling to build a machine learning pipeline for classifying milk grade, compare algorithms, manage data types and missing values, and deploy with the Predict tool.
Machine Learning Part 210:49
Machine Learning Part 311:52
Combine customer and transaction data with build features and feature types to create predictive features for a credit score classification model, evaluated by AutoML with random forest and Xgboost.
Machine Learning Part 47:04
Machine Learning Part 510:02
Section Quiz

DOWNLOAD ME: Course Exercise Files0:23
Exercise 14:35
Auto field data, tag nationality with regex, save to Calgary database, divide 480 students into four tiles, compute running total of raised hand, and create tile_num, tile_sequence_num, and run_total_raised_hand indexes.
Exercise 26:02
Import the sql database and join three tables in database tools, remove duplicates, and compute the average users per year; also export 2019 questions to excel.
Exercise 312:39
Exercise 46:22
Exercise 55:15
Ending Video0:22

Requirements

Basic to intermediate knowledge of Alteryx is needed as this is an advanced course
Alteryx downloaded and installed on your machine (ideal but not essential)

Description

**This course includes downloadable instructor files and exercise files to work with and follow along.**

Created by data analysts who use the tool on a daily basis with clients, this Alteryx advanced course offers the students sections on data cleansing and manipulation, working in databases, apps, and macros, as well as a breakdown of Alteryx’s latest product, the Intelligence Suite. The Alteryx Intelligence Suite includes machine learning tools that introduce students to the world of Artificial Intelligence.

At the end of this course, students will receive skills needed to pass Alteryx’s certification as well as acquire on-job skills needed to become Data Analytics experts.

This is an advanced course designed for students who have beginner to intermediate-level knowledge of Alteryx and are looking to build on those skills. An intermediate to advanced understanding of Excel is also useful.

This course covers:

Using multiple files and Calgary
Sampling data and using wild matches
Data cleansing, manipulation, binning, and grouping
Using RegEx (regular expressions) and parsing XML
Working with In-Database
Blending, selecting, and summarizing data
Taking your apps and macros to the next level
Using iterative and batch macros
Understanding app errors and conditions
Customizing apps and macros
All about Machine Learning and the Alteryx Intelligence Suite

This course includes:

4 hours of video tutorials
27 individual video lectures
Course and exercise files to follow along
Certificate of completion

Who this course is for:

Data Scientists and Data Analysts
Those who are looking to use Alteryx for Data Analysis
Users who have a foundation in Alteryx and seeking to advance their skills

Alteryx Masterclass: Advanced Data Analytics Training

What you'll learn

Explore related topics

Course content

Data Cleansing & Manipulation10 lectures • 1hr 19min

Working in Database3 lectures • 32min

Apps & Macros5 lectures • 48min

Intelligence Suite5 lectures • 51min

Exercises and Course Close7 lectures • 36min

Requirements

Description

Who this course is for: