Course Code: bspaltfu
Duration: 14 hours
Course Outline:

Introduction

Alteryx Overview

  • What is Alteryx?
  • Alteryx Features

Preparing and Developing Environment

  • Installing and Configuring Alteryx

Input tools

  • Connecting to Data Sources
  • Writing to a data source
  • Working with the Browse Tool

Preparation tools

  • Cleansing, filtering and sorting data
  • Working with fields and columns

Join tools

  • Merging data sets
  • Finding and replacing data
  • Matching data

Transform and Parse tools

  • Calculating totals and averages
  • Transposing data
  • Using regular expressions

Data Wrangling

  • Creating custom formulas, algorithms and calculations
  • Performing data transformations

Data Visualization

  • Creating data visualizations

Reporting and Documentation tools

  • Creating tables and charts
  • Managing tools
  • Automating reporting

Creating Macros

  • Standard Macro
  • Batch Macro
  • Iterative Macro

Predictive tools in Alteryx