Course Code: bspaltyx
Duration: 7 hours
Course Outline:
  • Introduction
  • Alteryx Overview
    • What is Alteryx?
    • Alteryx Features
  • 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
    • Automated reporting
  • Creating Macros
    • Standard Macro
    • Batch Macro
    • Iterative Macro
  • Predictive tools in Alteryx