Home

All courses

Alteryx - The Complete Masterclass

Alteryx

Business

Business Analytics & Intelligence

Alteryx - The Complete Masterclass

Master Alteryx Designer and learn advanced Alteryx data analysis from top-instructor

4.7

(2347)

14527 enrolled on this course

Last updated 11/2021

Nikolai Schuler

₹ 3099.0

₹ 4599.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

Do you want to learn the skills to
professionally build workflows & analyze data with Alteryx?
Then this is the right course for you.
In this course you will learn
everything that is important in Alteryx to become advanced and professional working with the Alteryx
Designer.
What you'll learn in this course:
✓ Understand everything from scratch
– step by step and practice-oriented
✓

Learn all the important tools
– know when and how to use them properly
✓ Connect different data sources
– from basics to advanced
✓

Create your own workflows
– and understand how to configure them properly
✓

Transform, clean & analyze data
– advanced analysis on your data
✓

Learn how to create professional reports
– automate them & send via email
✓

Advanced analysis
– learn how to use the R Tools
✓

Predictive Analytics & Time Series
– Advanced analytics for Data Science
✓

ETL workflows
– Implement the workflows to Extract, Transform & Load data
In short: Everything you need to master Alteryx!
Learn Alteryx the smart way:
✓ Many practical assignemts
– to apply what you've learnt
✓ Quizzes
–

to test your knowledge

✓ All of the downloadable resources
– all you'll need!
✓ Complete Masterclass
– with all the important tools you'll need!
This course is right for you if:
... you have never worked with Alteryx and you want to learn everything in one course.
... OR you have already some basic knowledge and want to dive deeper and become more advanced.
This course is helpful in the field of:
✓
Data Analytics & Business Analytics
✓
Data Engineering & Business Intelligence
✓
Data Science
… if you are aspiring to be in that field or you are already – this is the course for you to level up your skillset!
This is the course that covers everything in Alteryx to become an advanced professional Alteryx specialist!
Enroll now to learn Alteryx the right way and get life long access!
Who this course is for:
Aspring Data Analysts & Business Analyst
Aspiring Data Engineers & Data Scientist
Everyone that is already in the industry and wants to level up their skillset

What you'll learn

Learn all you need to Master Alteryx

Dive into the Advanced Analytics tools like Predictive Analytics & Time Series

Learn how to Clean, Transform & Analyse Data

Get data from various data sources like databases, files & AWS

Create different types of custom Macros

Learn all you need hands-on with many practical assignments & quizzes

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Welcome!

1.2-Course overview

1.3-What is Alteryx?

1.4-Download & Installation

1.5-Getting to know the interface

1.6-How to benefit best

2-Data Input & Output

2.1-Import csv

2.2-Import multiple files

2.3-Input Data

2.4-Browse tool

2.5-Import multiple files

2.6-Import Excel

2.7-Import txt

2.8-Importing data

2.9-Import ZIP

2.10-Manual Input

2.11-Annotations

2.12-Output Data

2.13-Date and Time tool

2.14-Input & Output

2.15-Import & Output Excel file

3-Data Preparation

3.1-Intro

3.2-Data Cleansing

3.3-Select

3.4-Auto Field

3.5-Data Preparation

3.6-Convert Date

3.7-Formula

3.8-More Data Preparation

3.9-Record ID

3.10-Data Preparation

4-Filtering, Sorting & Grouping

4.1-Intro

4.2-Sort

4.3-Filter

4.4-Multi-Row Formula

4.5-Multi-Row Formula: Second example

4.6-Sample

4.7-Filtering & Sampling

4.8-Unique

4.9-Multi-Field Formula

4.10-Tile

4.11-Alternative way of filtering & sorting

4.12-Multi-field binning

4.13-Create Samples

4.14-More Data Preparation

5-Joins

5.1-Intro & Preparation

5.2-Join

5.3-Join Multiple

5.4-Union

5.5-Find and Replace

5.6-Join & Union

5.7-Fuzzy Match

5.8-Make Group

5.9-Append Fields

5.10-Union & Join

6-Parse

6.1-Regular Expressions

6.2-Text To Columns

6.3-XML Parse

7-Transform

7.1-Summarize

7.2-Running Total

7.3-Weighted Average

7.4-Cross Tab

7.5-Transpose

7.6-Arrange

7.7-Transform

7.8-Transform

8-Reporting

8.1-Intro

8.2-Table Tool

8.3-Pie Chart

8.4-Bar Chart

8.5-Multiple Charts in a Layout

8.6-Header & Footer

8.7-Rendering a report

8.8-Images & Text

8.9-Alternative: Visual Layout

8.10-Emailing the report

8.11-Reporting

9-Spatial Analysis

9.1-Create points

9.2-Trade Area

9.3-Find Nearest

9.4-Distance

9.5-Spatial Match

9.6-Spatial Process

9.7-Heat Map

10-Working with Databases

10.1-Intro

10.2-Setting up a local SQL database

10.3-Creating a table

10.4-Loading from database

10.5-Writing to database

10.6-Connect In-DB

10.7-Filter In-DB

10.8-Formula In-DB

10.9-Select In-DB

10.10-Union In-DB

10.11-Join In-DB

10.12-Data Stream In

10.13-Data Stream Out

10.14-Write Data In-DB

10.15-Working In-DB

11-Working on AWS S3

11.1-Intro

11.2-Create Free Tier Account

11.3-Create bucket & upload file

11.4-Load from AWS

11.5-Upload to AWS

12-Macros

12.1-What are Macros?

12.2-Standard Macro

12.3-Batch Macro

12.4-Iterative Macro

12.5-Understanding Macros

13-Documentation

13.1-Comment

13.2-Tool Container

13.3-Explorer Box

14-Installing Predictive with R Tools

14.1-Relevant for the subsequent lectures

14.2-Installing the Predictive Tools Package

14.3-Creating a Macro

15-Data Investigation

15.1-Data Investigation & Field Summary

15.2-Pearson Correlation

15.3-Violin Plot

15.4-Scatterplot

16-Predictive Tools

16.1-Linear Regression

16.2-Score & Evaluate

16.3-Decision Forest

16.4-Model Comparison

16.5-Create a Predictive Model

17-Time Series

17.1-ARIMA

17.2-ETS & TS Compare

17.3-TS Forecast

17.4-Create a Time Series Model

18-Bonus

18.1-Bonus lecture

Course Categories

Popular Courses

Alteryx - The Complete Masterclass

Description

What you'll learn

Requirements

Course Content

You May Like