Preview Alteryx Tutorial for Beginners 2022

Back

Course content

Section Material

Alteryx Full Course Material

Section 1 : Introduction

1 Introduction to Alteryx

1.3 Download and Install Alteryx

1.4 User Interface 1

Section 2 : Import & Export

2.0 Introduction to Import and Export

2.1 Naming Conventions

2.2 Import Excel File

2.3 Configuration and Results

2.4 Importing CSV file

2.5 Save and Open Workflow

2.6 Combine Bulk CSV files

2.7 Import CSV from Nested Folders

2.8 Export Files to Excel

2.9 Export Files to CSV

2.10 Browse Tool

2.11 Importing Text File

2.12 Text Input Tool

2.13 Directory Tool

2.14 Date Time Now Tool

2.15 Split One Excel Workbook To 100 CSV Files

2.16 Split One Excel To Multiple Excel Files

Quiz

Import & Export

Assignment

Import and Export

Section 3 : Basic Data Preparation Tools

3.0 Introduction To Basic Data Preparation Tools

3.1 Sorting Tool

3.2 Removing Duplicates

3.3 Select Tool

3.4 Auto Field

3.5 Record ID Tool

Quiz

Basic Data Preparation Tools

Assignment

Basic Data Preparation Tools

Section 4 : Other Data Preparation Tools

4.0 Introduction To Data Preparation Tools

4.1 Data Cleansing Tool - Part 1

4.2 Data Cleansing Tool - Part 2

4.3 Select Records

4.4 Samples Tool

4.5 Create Samples

4.6 Random Percent Sample

4.7 Imputation [Find and Replace]

4.8 Generate Rows

4.9 Tile Tool

Quiz

Other Data Preparation Tools

Assignment

Other Data Preparation Tools

Section 5 : Filters & Functions

5.0 Introduction To Filters & Functions

5.1 Single Filter

5.2 Multiple Filters

5.3 Text Functions 1

5.4 Text Function 2

5.5 Date Functions 1

5.6 Date Functions 2

5.7 Conditional Functions

5.8 Number Functions

5.9 Multi-Field Binning

5.10 Multi Row Formula

5.11 Multi-Field Formula

Quiz

Filters & Functions

Assignment

Filters _ Functions

Section 6 : Joins

6.0 Introduction To Joins

6.1 Union [By Names]

6.4 Joins [3 Types]

6.5 Joins [Derived VLOOKUP]

6.7 Multiple Joins [Different Sheets]

6.8 Append Fields - Ex 1

6.9 Append Fields - Ex 2

6.10 Find & Replace

6.11 Fuzzy Match

Quiz

Joins

Assignment

Joins

Section 7 : Parse

7.0 Introduction To Parse Tab

7.1 DateTime Tool

7.2 Text to Columns - Ex 1

7.3 Text to Columns - Ex 2

7.4 Regular Expression Ex 1

7.5 Regular Expression Ex 2

Quiz

Parse

Assignment

Parse

Section 8 : Transform Tab

8.0 Introduction To Transform Tab

8.1 Count Records

8.2 Summarize Tool

8.3 Running Total

8.4 Transpose

8.5 Cross Tab

8.6 Weighted Average

8.7 Arrange Tool

Quiz

Transform Tab

Assignment

Transform Tab

Section 9 : Reporting Tab

9.0 Introduction To Reporting Tab

9.1 Creating a Basic Table

9.2 Table Configuration

9.3 Conditional Formatting in Table

9.4 Default Table Settings

9.5 Creating a Pie Chart

9.6 Creating a Bar Chart

9.7 Side By Side Bar Chart

9.8 Report Text

9.9 Chart Formatting - Part 1

9.10 Chart Formatting - Part 2

9.11 Donut Chart

9.12 Horizontal Layout

9.13 Vertical Layout

9.14 Report Headers

9.15 Report Footers

9.16 Render - Part 1

9.17 Render - Part 2

Quiz

Reporting Tab

Assignment

Reporting Tab

Section 10 : Documentation

10.0 Documentation Tab

10.1 Tool Container

10.2 Comment Box

10.3 Explorer Box

Quiz

Documentation

Assignment

Documentation Tab

Section 11 : Spatial

11.0 Introduction To Spatial

11.1 Spatial Objects Introduction

11.2 Create Points

11.3 Poly Build Tool

11.4 Create Points [Map of India]

11.5 Creating Points [My Cordinates]

11.6 Trade Area

11.7 Distance

11.8 Find Nearest

Quiz

Spatial

Assignment

Spatial

Section 12 : Help

12.1 Introduction To Help

12.2 Search Help 1

12.3 FREE Webinars

12.4 Weekly Challenge

12.5 CERTIFICATION

Section 13 : Case Studies

13.1 Introduction To Case Studies

13.2 Case Study 1 - Combine 48 CSV Files Into One Excel File

13.3 Case Study 2 - Split Combined Data Into Multiple PDF Files

13.4 Case Study 3 - Splitting Combine Data Into Multiple PNG PPT Files

13.5 Case Study 4 - Split Combined Data Into Multiple Excel Files

13.6 Case Study 5 - Combine Multiple Excel Files Into One

Project

Alteryx Project

Capstone Projects

Project 1

Project 2

Project 3

Project 4

Project 5

Preview - Alteryx Tutorial for Beginners 2022