Data Manipulation

Summary

In this course you’ll learn some advanced techniques Alteryx has for parsing & manipulating data.  You’ll learn in detail about the techniques of fuzzy matching & regular expressions. Both of these are useful techniques which many people can struggle to understand. You’ll apply key concepts through case-study style learning, with concise lessons & applied assessments.  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 be more proficient at manipulating data with Alteryx.

Course Overview

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

  • The Text to Columns tool
  • The Unique and Find and Replace Tools
  • Fuzzy Match - Data Preparation
  • Fuzzy Match - Tool Configuration
  • Fuzzy Match - Iterating Your Results
  • Fuzzy Match - Cascading Matches
  • Introduction to Regular Expressions
  • Dissecting a Regular Expression
  • Using the RegEx Tool
  • Other RegEx Outputs

Key Outcomes

Once you’ve completed this course, you’ll better understand how to use the data manipulation tools in Alteryx. You’ll be able to find matches in your data using fuzzy matches and use regular expressions to perform searches, replacements and matches in your data. By applying the skills you’ll learn in this course, you’ll be able to use more advanced and more efficient methods to analyze your data.