Alteryx Tutorial For Beginners – (Demo Free Course)

Right Place to Begin with

What you’ll learn
** Create a Smart Solution Workflow to be used for Analysis Purpose
** Automate Manual Task which consumes lot of time and Energy
** Get Data from various data sources in Alteryx
** Cleaning and Massaging Data for Business Intelligence tools
** Appending Data from Same Data Source
** Appending Data from Different Data Source
** Merging Data using Joins
** Finding and Replacing Text
** Sort, Filter, Functions and Formulas
Requirements
** Excel VLOOKUP
** Excel Pivot Table
** Excel Functions and Formulas
** What are Joins (Good to have knowledge)
Description
Data Cleaning is the most tedious and time consuming task today. Industries spend lot of time in working out to get the right solutions, Hire Experts and Invest Time. All this cleaning work can be managed smoothly by Alteryx.Alteryx is 1) Data Cleaning Tool2) Data Blending Tool3) Predictive Analysis Tool4) Spatial Analysis Tool5) ETL Tool6) Self Service Analytical ToolThis course is specially designed for participants having no knowledge about Alteryx and Want to upgrade skills to clean data set.After Learning from this course, you would be able to Join datasets, perform union operations, Find and Replace, Fuzzy Match, Sort, Filter etc.There are 260 + Tools available in Alteryx, This course covers the most important Tools used in the industry today.This is just a free demo course, where you get a handholding of Introduction to Alteryx. You can enroll for a full fledge course available on udemy. After Learning from this course, you would be able to Join datasets, perform union operations, Find and Replace, Fuzzy Match, Sort, Filter etc.There are 260 + Tools available in Alteryx, This course covers the most important Tools used in the industry today.This is just a free demo course, where you get a handholding of Introduction to Alteryx. You can enroll for a full fledge course available on udemy.

Overview

Section 1: Introduction to Alteryx

Lecture 1 1.1 Alteryx – Introduction to Alteryx

Lecture 2 1.2 Alteryx – Download and Install Alteryx

Lecture 3 1.3 Alteryx – User Interface of Alteryx

Section 2: Get Data in Alteryx

Lecture 4 2.1 Alteryx – Get Data from Excel

Lecture 5 2.2 Alteryx – Get Data from CSV

Lecture 6 2.3 Alteryx – Append All CSV files

Lecture 7 2.4 Alteryx – Browse Tool

Lecture 8 2.6 Alteryx – Output Tool – Updated Existing Output File

Lecture 9 2.7 Alteryx – Directory Tool – Alteryx Office

Lecture 10 2.8 Alteryx – Directory Tool – Specific Files

Lecture 11 2.9 Alteryx – Text Input Tool

Lecture 12 2.10 Alteryx – Date & Time Tool

Section 3: 3 Data Preparation Tools

Lecture 13 3.1 Alteryx – Auto Field – Alteryx Office

Lecture 14 3.2 Alteryx – Data Cleansing – Remove Null Rows & Columns – Alteryx Office

Lecture 15 3.3 Alteryx – Data Cleansing – Part 2 – Alteryx Laptop

Lecture 16 3.4 Filter Tool – Text -Alteryx Office

Lecture 17 3.5 Filter Tool – Number Example-Alteryx Laptop

Lecture 18 3.6 Filter Tool – Date Example-Alteryx Laptop

Lecture 19 3.7 Formula Tool – Basic Example – Alteryx

Lecture 20 3.8 Formula – Multiple Examples – Alteryx

Lecture 21 3.9 Generate Rows Tool – Alteryx

Lecture 22 3.10 Imputation Tool – Alteryx

Lecture 23 3.11 Multi-Field Binning Tool – Alteryx

Lecture 24 3.12 Multi-Field Formula – Alteryx

Lecture 25 3.13 Multi-Row Formula – Alteryx

Lecture 26 3.14 Random Percentage Sample- Alteryx

Lecture 27 3.15 Record Id- Alteryx

Lecture 28 3.16 Sample Tool- Alteryx

Lecture 29 3.17 Select Tool- Alteryx

Lecture 30 3.18 Sort Tool -Alteryx

Lecture 31 3.19 Create Samples Tool-Alteryx

Lecture 32 3.20 Tile Tool-Alteryx

Lecture 33 3.21 Unique Tool -Alteryx

Section 4: Joins

Lecture 34 4.1 Append Fields Tool- Alteryx

Lecture 35 4.2 Find And Replace Tool- Alteryx

Lecture 36 4.3 Fuzzy Match Tool- Alteryx

Lecture 37 4.4 Join Tool- Alteryx

Lecture 38 4.5 Join Multiple Tool – Alteryx

Lecture 39 4.7 Union Tool – Alteryx

Section 5: Parse

Lecture 40 5.2 Regex Tool- Alteryx

Lecture 41 5.3 Text To Columns – Alteryx

Section 6: Transform Tab

Lecture 42 6.2 Count Records Tool – Alteryx

Lecture 43 6.3 Cross Tab Tool – Alteryx

Lecture 44 6.4 Transpose- Alteryx

Lecture 45 6.5 Running Total- Alteryx

Lecture 46 6.6 Summarize Tool- Alteryx

Section 7: Reporting Tab

Lecture 47 7.1 Table Tool- Alteryx

Lecture 48 7.2 Interactive Chart Tool- Alteryx

Lecture 49 7.3 Join Table And Chart- Alteryx

Lecture 50 7.4 Add Annotation- Alteryx

Lecture 51 7.5 Report Text Tool- Alteryx

Lecture 52 7.6 Report Header- Alteryx

Lecture 53 7.7 Report Footer- Alteryx

Lecture 54 7.8 Layout Tool- Alteryx

Lecture 55 7.9 Render Tool Alteryx

Section 8: Documentation

Lecture 56 8.1 Comment Tool- Alteryx

Lecture 57 8.2 Explorer Tool- Alteryx

Lecture 58 8.3 Tool Container- Alteryx

** Participants Spending lot of time in Data Cleaning,** Participants using Tableau, Power BI and MicroStrategy,** Participants using Excel,** Freshers looking for Job,** Participants wanting to Completely Automate Manual Work,** Participants wanting to Learn ETL Tool,** Participants Aware about Talend, Power Query, Informatica (ETL Tools)