Alteryx Tutorial for Beginners

Name: Alteryx Tutorial for Beginners
Rating: 4.1 (5 reviews)

Master the basics of Alteryx Designer

Created byProgramming Knowledge

Last updated 11/2022

English

What you'll learn

Learn everything you need to know about Alteryx.
Explore advanced analytics tools like time series and predictive analytics.
Study data cleaning, transformation, and analysis.
Make many kinds of unique Macros.

Course content

1 section • 20 lectures • 3h 21m total length

Introduction to the Alteryx10:03
Installing Alteryx6:05
Importing Excel File10:07
Importing Multiple Files10:29
Data Types - Alteryx10:06
Explore the five data types in Alteryx: string, numeric, date time, boolean, and spatial objects, and learn how auto field and select tools assign and modify them.
Browse Tool | Alteryx10:37
Output Data Tool | Data Cleansing in Alteryx for Beginners10:14
In / Out Tools | Alteryx10:32
Using the Autofield and Data Cleansing Tools | Alteryx10:18
Sort Tool, Sample tool and Formula Tools in Alteryx10:25
Multi Field Binning Tool in Alteryx workflow.10:10
How to Use Append Fields Tool in Alteryx (Append Fields Tool)10:01
Union, Find and Replace Tool in Alteryx.10:20
Left, Right, and Full Outer Joins9:51
Struggling with Regex and Text-to-Columns Tool10:38
Master how to configure the radix tool using regular expressions in Alteryx to parse, match, or replace data, and apply the text-to-columns tool to split by a delimiter.
How to Transpose Data using Cross Tab Tool10:22
Master the count records tool to tally all records, with or without filters. See how cross tab and transpose pivot data, converting orientations and comparing row and column outputs.
How to Use Running Total Tool in Alteryx10:15
How to use the Table tool in Alteryx.10:39
Add and use the reporting tab in Alteryx, configure the table tool to create basic or pivot tables, customize fields, apply formatting rules, and render reports to Excel.
How to Create Charts in Alteryx Designer10:10
How to Create Batch Charts in Alteryx.9:56

Requirements

a laptop and some familiarity with IT.
Inspiration and a desire to study.

Description

This course is designed for anyone who is new to Alteryx Designer or a beginner. In this course, I'll walk you through the fundamentals of Alteryx, from installing your free trial to connecting to various data sources, performing complex transformations, creating macros, and developing predictive models with R.

Alteryx is a data-blending tool that lets users import data from multiple sources, blend it, process it as needed, and then model, report, or export it to dashboards or other systems for further analysis.

This course assumes no prior knowledge of Alteryx. You should be familiar with data transformation and reporting tools such as Microsoft Excel, as well as everything else you'll learn in this course.

Content

1 - Introduction to the Alteryx

2 - Installing Alteryx

3 - Importing Excel File

4 - Importing Multiple Files

5 - Data Types - Alteryx

6 - Browse Tool | Alteryx

7 - Output Data Tool | Data Cleansing in Alteryx for Beginners

8 - In/Out Tools | Alteryx

9 - Using the Autofield and Data Cleansing Tools | Alteryx

10 - Sort Tool, Sample Tool and Formula Tools in Alteryx

11 - Multi Field Binning Tool in alteryx workflow

12 - How to Use Append Fields Tool in Alteryx (Append Fields Tool )

13 - Union, Find and Replace Tool in Alteryx

14 - Left, Right, and Full Outer Joins

15 - Struggling with Regex and Text-to-Columns Tool

16 - How to Transpose Data using Cross Tab Tool

17 - How to Use Running Total Tool in Alteryx

18 - How to use the Table tool in Alteryx

19 - How to Create Charts in Alteryx Designer

20 - How to Create Batch Charts in Alteryx

Who this course is for:

Data Analysts and Business Analysts at Aspring.
Data Engineers and Data Scientists in Training
Everyone who is already in the industry and wants to advance their career.