Course
|
Alteryx

Applying Parsing and Formula Tools

In almost all projects, we'll need to parse data and perform calculations to facilitate further analysis. In this course we'll look at the parsing and formula tools available in Alteryx.
3 HOURS
Intermediate
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Parse date data into the correct format
Convert text to columns
Parse text using formulas
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Alteryx

Applying Parsing and Formula Tools

In almost all projects, we'll need to parse data and perform calculations to facilitate further analysis. In this course we'll look at the parsing and formula tools available in Alteryx.
3 HOURS
Intermediate
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Parse date data into the correct format
Convert text to columns
Parse text using formulas
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

11 Lessons
Course Introduction
2 MINS
LESSON
Course Introduction
Exercise

In this lesson, we introduce the case that we will examine in this course as well as the tools we'll use for our analysis.

Date and Time Basics
5 MINS
LESSON
Date and Time Basics
Exercise

In this lesson, we learn the specific way in which dates and times are interpreted and manipulated by Alteryx using the DateTime tool.

Applying Formulas to Multiple Fields
5 MINS
LESSON
Applying Formulas to Multiple Fields
Exercise

The Multi-Field Formula tool is typically used to manipulate data across the same row. Learn how to use the tool in this detailed lesson.

Using the Text to Columns Tool
6 MINS
LESSON
Using the Text to Columns Tool
Exercise

In this lesson, we learn how to use the Text to Columns tool to separate combined fields in Alteryx.

Parsing Data with the Formula Tool
7 MINS
LESSON
Parsing Data with the Formula Tool
Exercise

In this lesson, we learn some additional techniques of using the formula tool to separate text into recognizable components.

Using Conditional Functions
8 MINS
LESSON
Using Conditional Functions
Exercise

In this lesson, we learn how to use the formula tool to write conditional functions to manipulate and convert data.

Using the Switch Function
7 MINS
LESSON
Using the Switch Function
Exercise

In this lesson, we learn how to switch function and use it to further categorize the data.

Generating New Rows of Data
7 MINS
LESSON
Generating New Rows of Data
Exercise

In this lesson, we learn how to use the Multi-Row Formula tool to manipulate data across different rows. This lesson also introduces the Generate Rows tool.

Calculating Moving Averages
7 MINS
LESSON
Calculating Moving Averages
Exercise

This lesson builds on our previous work with the Multi-Row tool to create a moving average calculation.

Calculating Quarterly Revenue
8 MINS
LESSON
Calculating Quarterly Revenue
Exercise

In this lesson, we use the DateTimeYear and DateTimeMonth functions to split our date data into quarters, and aggregate revenue data accordingly.

Analyzing Market Share
7 MINS
LESSON
Analyzing Market Share
Exercise

In this lesson, we use the formula and filter tools to calculate the market share of each geographic sales area.

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo