Alteryx Masterclass - Let's Get Started

Alteryx Masterclass - Let’s Get Started

Video description

Master the fundamentals of Alteryx for data cleaning and data preparation.

About This Video

Grasp the fundamentals of Alteryx
Clean and prepare data in Alteryx
Derive insights from your data

In Detail

Alteryx is a data preparation and cleaning tool used mainly by data scientists to clean and prepare data. Its effectiveness lies in its user-friendly interface and variety of tools that can be used for data analysis. In this course, …

Alteryx Masterclass - Let’s Get Started

Video description

Master the fundamentals of Alteryx for data cleaning and data preparation.

About This Video

Grasp the fundamentals of Alteryx
Clean and prepare data in Alteryx
Derive insights from your data

In Detail

You'll begin by getting an introduction to Alteryx and learn how to get your data into Alteryx. You'll learn how Alteryx cleans data in an efficient way, and how to use this to your advantage. You'll use tools such as 'union' and 'replace' to combine and clean your data, 'cross tab' and 'transpose' to pivot your data, and a host of additional useful tools to learn the dynamics of Alteryx. You'll also work on a case study to cement your knowledge of Alteryx.

By the end of this course, you'll be a confident data scientist with the knowledge of Alteryx to clean and prepare your data in the best way possible.

Publisher resources

Download Example Code

Chapter 1 : Let’s Explore Alteryx

Introduction

Alteryx Interface

How to Get Our Data in Alteryx

Connecting to a SQL Database

Using the Browse Tool and Saving Cleaned Data

Using the Select Tool

Auto Field

Data Cleansing

The Filter Tool Deep Dive

Using the Formula Tool

Data Preparation in Alteryx

Imputation – Dealing with Missing Values

Binning in Alteryx

Performing Multiple Calculations at Once

Multi-Row Formula and Where to Use It

Other Useful Tools

Classifying Your Data in Tiles in Alteryx

Combining Data

Cleaning Data with the Find and Replace Tool

Using the Append Tool in Alteryx with Caution

Using the Make Group Aka Make Friends Tool in Alteryx

How to Match Fields that Do not Match in Alteryx

Joining in Alteryx

Parsing Tools and How to Use them in Alteryx - 1

Parsing Tools and How to Use them in Alteryx - 2

Transforming Data in Alteryx

Pivoting and Unpivoting

Alteryx Cumulative Sales

Aggregation with Summarize

Weighted Average Calculation in Alteryx

Dynamics - Additional Useful Tools in Alteryx

How to Combine Multiple Excel Tabs into Alteryx

Webscraping - How to Get Foreign Exchange Rates

Webscraping - Getting Tables from Websites with Python

Final Words and Case Study

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.