Development
Development Tools
Alteryx
Alteryx Bootcamp
4.5 (9,542 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.
25,350 students enrolled

Alteryx Bootcamp

From couch to Alteryx developer in less than four hours.
Bestseller
4.5 (9,530 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.
25,350 students enrolled
Created by Hendrik Kleine
Last updated 9/2019
English
English [Auto], French [Auto], 5 more
  • German [Auto]
  • Indonesian [Auto]
  • Italian [Auto]
  • Portuguese [Auto]
  • Spanish [Auto]
Preview this course
Alteryx Bootcamp
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 54 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
  • Develop Alteryx Workflows
  • Create ETL (Extract Transform and Load) Processes
  • Perform Predictive Analytics Functions
  • Build Custom Data Transformations
  • Develop Repeatable Alteryx Macros
  • Embed custom R code inside Alteryx
  • Use Alteryx in your Professional Day Job
Course content
Expand all 74 lectures 03:50:37
+ – Introduction
4 lectures 13:02

This video provides a high-level overview of the course contents.

Course Overview
Preview 01:57

This video walks you through installing a free trial version of Alteryx Designer.

Installing Alteryx Designer (free trial)
03:35

This video walks you through the Alteryx Designer interface.

Interface Walkthrough
06:31

The resources attached to this video are all the resources needed for the entire course.

Downloading Course Resources
00:59
+ – Input Tools
11 lectures 35:12

In this video, you'll learn about the functionality of the Input Tools.

Introduction to Input Tools
01:15

In this video, you'll learn how to connect Alteryx to a Microsoft Excel workbook.

Input Data Tool - Connect to Excel
Preview 09:16

In this video, you'll learn how to connect Alteryx to a CSV file.

Input Data Tool - Connect to CSV
01:17

In this video, you'll learn how to connect Alteryx to a Microsoft SQL Server database.

Input Data Tool - Connect to SQL Server (demo)
06:03

In this video, you'll learn how to connect Alteryx to compressed (ZIP) files.

Input Data Tool - Connect to Compressed Files
02:41

In this video, you'll learn how to manually enter data into an Alteryx Designer workflow.

Text Input Tool
01:57

In this video, you'll learn how to get information from multiple files, using the Directory Tool.

Directory Tool
02:11

In this video, you'll learn how to output data from Alteryx Designer, to a Microsoft Excel workbook.

Output Data Tool - Write to Excel
03:16

In this video, you'll learn how to output data from Alteryx Designer, to a Microsoft SQL Server database.

Output Data Tool - Write to SQL Server (demo)
03:15

In this video, you'll learn how to insert the current date and time into an Alteryx workflow.

Date Time Now Tool
00:59

In this video, you'll learn how to view your data at any point in an Alteryx workflow, by using the Browse tool.

Browse Tool
03:02
+ – Preparation Tools
15 lectures 44:02

In this video, you'll learn to use the select tool to select fields, rename fields and specify data types.

Select Tool
05:28

In this video, you'll learn how to use the data cleansing tool, to address common data quality issues.

Data Cleansing Tool
01:52

In this video, you'll learn how to use the Filter tool to restrict the data in your dataset based on custom conditions.

Filter Tool
04:19

In this video, you'll learn how to use the Formula tool to create custom expressions to apply to your data.

Formula Tool
Preview 03:03

In this video, you'll learn how to apply a formula to multiple fields at once, using the Multi-Field Formula tool.

Multi-Field Formula Tool
03:43

In this video, you'll learn how to use values from different rows when calculating a formula for the current row, using the Multi-Row Formula tool.

Multi-Row Formula Tool
03:19

In this video, you'll learn how to sort your data, using the Sort Tool.

Sort Tool
01:22

In this video, you'll learn how to add an ID column to your dataset, using the Record ID tool.

Record ID Tool
01:36

In this video, you'll learn how to create a dataset with distinct values, using the Unique tool.

Unique Tool
01:49

In this video, you'll learn how to use the sample tool, to retrieve a sample of rows from your dataset, using the Sample tool.

Sample Tool
02:40

In this video, you'll learn how to get a random sample of rows, using the Random Percent Sample tool.

Random % Sample Tool
01:38

In this video, you'll learn how to optimize data types, using the Auto Field tool.

Auto Field Tool
02:42

In this video, you'll learn how to impute value in your data, using the Imputation tool.

Imputation Tool
02:49

In this video, you'll learn how to group rows in your data using the Tile tool.

Tile Tool
03:00

In this video, you'll learn how to dynamically generate additional rows based on certain conditions, using the Generate Rows tool.

Generate Rows Tool
04:42
+ – Join Tools
7 lectures 28:52

In this video, you'll learn how to perform left, inner and right joins, using the Join tool.

Join Tool
Preview 04:09

In this video, you'll learn how to join more than 2 datasets at the same time, using the Join Multiple tool.

Join Multiple Tool
04:14

In this video, you'll learn how to combine multiple datasets, using the Union tool.

Union Tool
04:57

In this video, you'll learn how to append your data to perform cartesian joins, using the Append tool.

Append Tool
02:12

In this video, you'll learn how to find and replace values in your dataset, very much like the Excel VLOOKUP function, using the Find Replace tool.

Find Replace Tool
03:27

In this video, you'll learn how to match data similar to each other, using the Fuzzy Match tool.

Fuzzy Match Tool
07:40

In this video, you'll learn how to create groups in your data based on association, using the Make Group tool.

Make Group Tool
02:13
+ – Transform Tools
6 lectures 15:20

In this video, you'll learn how to aggregate your data, using the Summarize tool.

Summarize Tool
Preview 03:17

In this video, you'll learn how to add a running total field to your data, using the Running Total tool.

Running Total Tool
02:13

In this video, you'll learn how to add a field to your dataset with the weighted average, using the Weighted Average tool.

Weighted Average Tool
01:40

In this video, you'll learn how to change the orientation of your data, using the Transpose tool.

Transpose Tool
02:39

In this video, you'll learn how to change the orientation of your data, using the Cross Tab tool.

Cross Tab Tool
02:15

In this video, you'll learn to manually transpose your data to the desired orientation, using the Arrange tool.

Arrange Tool
03:16
+ – Parse Tools
3 lectures 11:34

In this section, you'll learn how to parse text to dates and vice versa, using the DateTime Parse tool.

DateTime Tool
04:10

In this video, you'll learn how to perform custom Regular Expressions on your data, within an Alteryx workflow, using the RegEx tool.

RegEx Tool
Preview 03:18

In this video, you'll learn how to parse text to columns, using the Text to Columns tool.

Text to Columns Tool
04:06
+ – Reporting Tools
8 lectures 19:01

This video provides a brief introduction to Alteryx' reporting tools.

Introduction to Reporting Tools
Preview 01:03

In this video, you'll learn how to create formatted tables, using the Table tool.

Table Tool
05:10

In this video, you'll learn how to create formatted charts, using the Charting tool.

Interactive Chart Tool
02:39

In this video, you'll learn how to add custom, dynamic text to any report, using the Report Text tool.

Report Text Tool
02:42

In this video, you'll learn how to use the Report Header tool to add a header to your report.

Report Header Tool
01:22

In this video, you'll learn how to use the Report Footer tool to add a footer to your report.

Report Footer Tool
01:40

In this video, you'll learn how to create a custom layout for the different elements on your report, using the Report Layout tool.

Report Layout Tool
02:21

In this video, you'll learn how to generate the actual report file, using the Render Tool.

Render Tool
02:04
+ – In-Database Tools
10 lectures 21:52

This video provides a brief introduction to In-Database tools.

Introduction to In-Database Tools
01:34

In this video, you'll learn how to connect In-Database and how to stream that data into alteryx, using the Connect In-DB and Data Stream Out tools.

Connect In-DB Tool & Data Stream Out Tool
04:55

In this video, you'll learn how to Browse In-Database data, using the Browse In-DB tool.

Browse In-DB Tool
01:43

In this video, you'll learn how to select and rename field in an In-Database workflow, using the Select In-DB tool.

Select In-DB Tool
01:34

In this video, you'll learn how to filter your data in an In-Database workflow, using the Filter In-DB tool.

Filter In-DB Tool
01:38

In this video, you'll learn how to add formulas to your In-Database workflow, using the Formula In-DB tool.

Formula In-DB Tool
Preview 01:47

In this video, you'll learn how to join data In-Database, using the Join In-DB tool.

Join In-DB Tool
02:46

In this video, you'll learn how to move data into an In-Database workflow, using the Data Stream In tool.

Data Stream In Tool
02:39

In this video, you'll learn to aggregate data in your In-Database workflow, using the Summarize In-DB tool.

Summarize In-DB tool
01:18

In this video, you'll learn how to obtain a sample set of your data from an In-Database workflow, using the Sample In-DB tool.

Sample In-DB tool
01:58
+ – Documentation Tools
3 lectures 06:10

In this video, you'll learn to annotate your workflow, using the Comment tool.

Comment Tool
02:29

In this video, you'll learn how to embed a web page into your Alteryx workflow canvas, using the Explorer Box tool.

Explorer Box Tool
00:56

In this video, you'll learn to group and disable multiple tools, using the Tool Container.

Tool Container Tool
02:45
+ – Macros
2 lectures 12:19

This video provides a brief overview of the different macro types available in Alteryx.

Introduction to Macros
Preview 02:05

In this workshop, you'll learn to create a standard macro from scratch, using various tools.

Workshop - Creating a standard Macro
10:14
Requirements
  • You should have basic PC knowledge.
  • You should have a basic understanding of data analysis.
Description

This course is for everyone who is either completely new, or a beginner with Alteryx Designer. In this course, I'll walk you through the basics of Alteryx, from installing your free trial, to connecting to various data sources, performing complex transformation, developing macros, analytic apps and predictive modelling using R.

This course does not require any prior knowledge of Alteryx. You should be comfortable with data transformation and reporting, using tools such as Microsoft Excel, everything else you'll pick up along the way in this course.

This course is excellent to kickstart your path to becoming an Alteryx developer, you'll learn all the basics in four hours of material, and will be able to apply your knowledge in the real world, immediately.

Who this course is for:
  • Anyone who is completely new to Alteryx.
  • Anyone who is a beginner with Alteryx and would like to explore more of the tools available.
Featured review
Max Kafui
Max Kafui ( 8 courses, 4 reviews )
7 months ago
Simple and easy to follow. I'm new to Alteryx and very impressed with its capabilities. This course is immensely valuable to understanding the basic concepts and capabilities of Alteryx. Highly recommended!!!