Alteryx for Beginners

Video description

Understand the features of Alteryx and learn how to automate boring manual data cleaning and data analysis tasks

About This Video

Become familiar with all the latest tools and features of Alteryx
Learn how to use Alteryx for creating a smart solution workflow for data cleaning and data analysis
Consolidate your learning by working on interesting real-world case studies

In Detail

Do you want to perform data cleansing and data analysis at jet speed? This course …

Alteryx for Beginners

Video description

Understand the features of Alteryx and learn how to automate boring manual data cleaning and data analysis tasks

About This Video

Become familiar with all the latest tools and features of Alteryx
Learn how to use Alteryx for creating a smart solution workflow for data cleaning and data analysis
Consolidate your learning by working on interesting real-world case studies

In Detail

Do you want to perform data cleansing and data analysis at jet speed? This course will show you how you can do data cleaning and data analysis a smooth and less time-consuming task using Alteryx.

The course starts with an introduction to Alteryx, explaining its installation process and user interface. Next, you will learn how to get data and update existing data from Excel and Comma Separated Value (CSV) files using the In/Out tool in Alteryx. Moving along, you will learn to use the Preparation tab for data cleansing and filtering and find out the role of the Join tab in Alteryx. Next, you will learn to work with the Parse and Transform tabs and learn how to use the Reporting tab in Alteryx. Finally, you will study the tools under the Documentation tab, such as comment, explorer, and container, and go through some interesting case studies to encapsulate your learning.

By the end of this course, you will be able to use Alteryx for your data cleaning and data analysis needs in the real world.

Who this book is for

If you are someone who works with data regularly and is constantly looking for a tool that will help you to perform data cleaning and data analysis quickly and easily, this course is for you. This course teaches Alteryx from scratch; however, a basic understanding of Excel VLookup, functions, formulas, along with some knowledge of Joins, would be helpful.

Publisher resources

Download Example Code

Chapter 1 : Introduction to Alteryx

Introduction to Alteryx

Downloading and Installing Alteryx

User Interface of Alteryx

Chapter 2 : In/Out Tab

Alteryx – Getting Data from Excel

Alteryx – Getting Data from Comma Separated Value (CSV) Files

Alteryx – Appending All Comma Separated Value (CSV) files

Alteryx – Browse Tool

Alteryx – Output Tool - Updating Existing Data

Alteryx – Directory Tool

Alteryx – Directory Tool - Specific Files

Alteryx – Text Input Tool

Alteryx – Date and Time Tool

Chapter 3 : Preparation Tab

Alteryx – Auto Field Tool

Alteryx – Data Cleansing Tool - Part 1

Alteryx – Data Cleansing Tool - Part 2

Alteryx – Filter Tool (Text Example)

Alteryx – Filter Tool (Number Example)

Alteryx – Filter Tool (Date Example)

Alteryx – Formula Tool (Basic Example)

Alteryx – Formula Tool - (Multiple Examples)

Alteryx – Generate Rows Tool

Alteryx – Imputation Tool

Alteryx – Multi-Field Binning Tool

Alteryx – Multi-Field Formula Tool

Alteryx – Multi-Row Formula Tool

Alteryx – Random % Sample Tool

Alteryx – Record ID Tool

Alteryx – Sample Tool

Alteryx – Select Tool

Alteryx – Sort

Alteryx – Create Sample Tool

Alteryx – Tile Tool

Alteryx – Unique Tool

Chapter 4 : Join Tab

Alteryx – Append Fields Tool

Alteryx – Find and Replace Tool

Alteryx – Fuzzy Match Tool

Alteryx – Join Tool

Alteryx – Join Multiple Tool

Alteryx – Union Tool

Chapter 5 : Parse Tab

RegEx Tool

Converting Text to Columns

Chapter 6 : Transform Tab

Alteryx – Count Records Tool

Alteryx – Cross Tab Tool

Alteryx – Transpose Tool

Alteryx – Running Total Tool

Alteryx – Summarize Tool

Chapter 7 : Reporting Tab

Alteryx – Table Tool

Alteryx – Interactive Chart Tool

Alteryx – Joining Table and Chart

Alteryx – Adding Annotation

Alteryx – Report Text Tool

Alteryx – Report Header Tool

Alteryx – Report Footer Tool

Alteryx – Report Layout Tool

Alteryx – Render Tool

Chapter 8 : Documentation Tab

Alteryx – Comment Tool

Alteryx – Explorer Tool

Alteryx – Container Tool

Chapter 9 : Case Studies

Case Study - 1

Case Study - 2

Case Study - 3

Case Study - 4

Case Study - 5

Case Study - 6

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.