Alteryx Bootcamp
4.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
42 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Alteryx Bootcamp to your Wishlist.

Add to Wishlist

Alteryx Bootcamp

From couch to Alteryx developer in 4 hours.
New
4.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
42 students enrolled
Created by hendrik kleine
Last updated 9/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 55 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Anyone who is completely new to Alteryx.
  • Anyone who is a beginner with Alteryx and would like to explore more of the tools available.
Compare to Other Alteryx Courses
Curriculum For This Course
79 Lectures
03:50:21
+
Introduction
5 Lectures 11:21

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

Preview 02:03

This video provides a brief introduction to the course instructor.

About the Instructor
01:22

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

Installing Alteryx Designer (free trial)
02:41

This video walks you through the Alteryx Designer interface.

Interface Walkthrough
04:39

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

Downloading Course Resources
00:36
+
Input Tools
11 Lectures 32:33

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

Introduction to Input Tools
01:13

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

Preview 09:08

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

Input Data Tool - Connect to CSV
01:02

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

Input Data Tool - Connect to SQL Server (demo)
04:32

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

Input Data Tool - Connect to Compressed Files
02:39

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

Text Input Tool
01:47

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

Directory Tool
02:01

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

Output Data Tool - Write to Excel
02:57

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:26

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

Date Time Now Tool
01:00

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
02:48
+
Preparation Tools
16 Lectures 44:47

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

Select Tool
04:50

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

Data Cleansing Tool
01:49

In this video, you'll learn how to use the Date Filter tool to filter your dataset based on a date field.

Date Filter Tool
03:12

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:07

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

Preview 02:46

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:56

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:03

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

Sort Tool
01:18

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

Record ID Tool
01:33

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

Unique Tool
01:39

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:28

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

Random % Sample Tool
01:29

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

Auto Field Tool
02:35

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

Imputation Tool
02:47

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

Tile Tool
02:42

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:33
+
Join Tools
7 Lectures 27:22

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

Preview 04:27

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:04

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

Union Tool
04:43

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

Append Tool
02:06

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

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

Fuzzy Match Tool
07:07

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:01
+
Transform Tools
6 Lectures 14:14

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

Preview 03:01

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

Running Total Tool
01:59

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:33

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

Transpose Tool
02:20

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

Cross Tab Tool
02:05

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 10:50

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

DateTime Tool
03:45

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

Preview 03:04

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

Text to Columns Tool
04:01
+
Reporting Tools
9 Lectures 25:36

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

Preview 01:16

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

Table Tool
05:02

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

Charting Tool
02:45

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

Report Text Tool
03:32

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

Report Header Tool
01:13

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

Report Footer Tool
01:27

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
03:59

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

Render Tool
02:29

In this video, you'll learn how to send emails directly from an Alteryx workflow, using the Email tool.

Email Tool
03:53
+
In-Database Tools
12 Lectures 23:14

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

Introduction to In-Database Tools
01:11

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:53

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

Browse In-DB Tool
01:29

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:23

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:39

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

Preview 01:48

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

Join In-DB Tool
02:29

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:09

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:19

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:45

In this video, you'll learn how to combine multiple datasets in an In-Database workflow, using the Union In-DB tool.

Union In-DB tool
01:45

In this video, you'll learn how to write data out, in an In-Database workflow, using the Write Data In-DB tool.

Write Data In-DB tool
01:24
+
Documentation Tools
3 Lectures 05:47

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

Comment Tool
02:20

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:55

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

Tool Container Tool
02:32
+
Predictive Tools & R Code
5 Lectures 23:04

This video provides you with a brief introduction to Alteryx Predictive Tools.

Introduction to Predictive Tools & R Code
03:22

In this video, you'll learn how to perform time series forecasting using the ARIMA predictive model.

Time Series Forecasting - ARIMA & Forecast Tools
06:00

In this video, you'll learn how to perform time series forecasting using the ETS predictive model.

Time Series Forecasting - ETS & Forecast Tools
01:41

In this video, you'll learn how to evaluate multiple time series predictive models, to determine the best fit model, using the TS Compare tool.

Time Series Forecasting - TS Compare
05:07

In this video, you'll learn how to embed your very own R code in an Alteryx workflow.

Custom R Code
06:54
1 More Section
About the Instructor
hendrik kleine
4.7 Average rating
6 Reviews
42 Students
1 Course
Senior Business Intelligence Professional

I've made a career out of helping businesses capitalize on their data using an incredibly diverse set of tools for data analysis, transformation and presentation purposes.  Over the past decade I've been fortunate enough to work with several leading fortune 100 tech companies to implement Business Intelligence strategies.

Most recently, I've taken up using Alteryx for data analysis and love how it helps move the industry forward by putting advanced analysis capabilities in the hands of the beginning data analyst.