Alteryx Tutorial For Beginners - (Demo Free Course)
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.29 GB | Duration: 4h 24m
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)
Screenshots