arrow_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