The Formula Tool

Summary

In this course you’ll learn how to improve your analytic capabilities in Alteryx using formulas. You’ll learn how to use the formula tool to perform calculations to manipulate data and facilitate further analysis. You’ll see how to deal with common types of data, like dates, times and text. You’ll apply key concepts through case-study style learning.  This course was created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suited to intermediate learners who have a basic general familiarity with using Alteryx. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to learn how to analyze data using formulas in Alteryx.

Course Overview

This Kubicle course contains 16 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Conditional Expressions and Conversions
  • Date and Time Basics
  • Converting Two Digit Years
  • Converting Serial Numbers to Date
  • Converting Serial Numbers to Time
  • The Multi-Field Tool
  • The Multi-Row Tool
  • Parsing Text Using the Formula Tool
  • Separating Text with Formulas

Key Outcomes

Once you’ve completed this course, you’ll understand how to create formulas using the formula tool. You’ll be able to deal with common data types, and you’ll know how to use the standard expressions provided by Alteryx to create formulas that will generate insights from your data. By applying the skills you’ll learn in this course, you’ll improve your ability to analyze and understand your data using Alteryx.