Welcome!

Course overview

What is Alteryx

Download & Installation

Getting to know the interface

How to benefit best

Import csv

Import multiple files

Browse tool

Import Excel

Import txt

Import ZIP

Manual Input

Annotations

Output Data

Date and Time tool

Intro

Data Cleansing

Auto Field

Convert Date

Formula

Record ID

Intro

Sort

Filter

Multi-Row Formula

Multi-Row Formula Second example

Sample

Unique

Multi-Field Formula

Tile

Alternative way of filtering & sorting

Multi-field binning

Create Samples

Intro & Preparation

Join

Join Multiple

Union

Find and Replace

Fuzzy Match

Make Group

Append Fields

Regular Expressions

Text To Columns

XML Parse

Summarize

Running Total

Weighted Average

Cross Tab

Transpose

Arrange

Intro

Table Tool

Pie Chart

Bar Chart

Multiple Charts in a Layout

Header & Footer

Rendering a report

Images & Text

Alternative Visual Layout

Emailing the report

Create points

Trade Area

Find Nearest

Distance

Spatial Match

Spatial Process

Heat Map

Intro

Setting up a local SQL database

Creating a table

Loading from database

Writing to database

Connect In-DB

Filter In-DB

Formula In-DB

Select In-DB

Union In-DB

Join In-DB

Data Stream In

Data Stream Out

Write Data In-DB

Intro

Create Free Tier Account

Create bucket & upload file

Load from AWS

Upload to AWS

What are Macros

Standard Macro

Batch Macro

Iterative Macro

Comment

Tool Container

Explorer Box

Installing the Predictive Tools Package

Data Investigation & Field Summary

Pearson Correlation

Violin Plot

Scatterplot

Linear Regression

Score & Evaluate

Decision Forest

Model Comparison

ARIMA

ETS & TS Compare

TS Forecast