Alteryx Bootcamp

25,365 students enrolled

Alteryx Bootcamp

Name: Alteryx Bootcamp
Brand: Udemy
SKU: course:1248866
Rating: 4.5 (9555 reviews)

From couch to Alteryx developer in less than four hours.

Bestseller

25,354 students enrolled

Created by Hendrik Kleine

Last updated 9/2019

English

English [Auto], French [Auto],

Preview this course

$51.99 $74.99 31% off

5 hours left at this price!

Buy now

30-Day Money-Back Guarantee

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

+ – 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

1 more section

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 ( 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!!!