Course Code: aervbspk
Duration: 7 hours
Course Outline:

1. Alteryx Overview

  • What is Alteryx?
  • Key features of Alteryx
  • Understanding Alteryx's role in data analytics and automation

 

2. Input Tools

  • Connecting to data sources
  • Writing to a data source
  • Using the Browse tool to inspect data

 

3. Preparation Tools

  • Data Cleansing: Handling missing values, trimming, standardizing data
  • Filtering: Filtering data based on conditions
  • Select Tool: Choosing and renaming columns, managing data types
  • Formula Tool: Creating custom formulas for data transformation
  • Sort Tool
  • Unique Tool

 

4. Join Tools

  • Join: Merging data from different sources
  • Union: Combining data from multiple datasets
  • Find Replace: Replacing values across datasets
  • Matching Data: Identifying and linking related records

 

5. Transform Tools

  • Transpose Tool: Reshaping data from wide to long format
  • Cross Tab Tool: Aggregating data and pivoting it for reporting
  • Summarize Tool: Calculating totals, averages, and other aggregates
  • Regular Expressions: Using regex for text matching and extraction

 

6. Reporting and Visualization

  • Intro
  • Table
  • Interactive chart
  • Report text
  • Report header
  • Report footer
  • Report layout
  • Render

 

7. Macros and Advanced Functions (Optional, advanced topics)

  • Introduction to Macros: Automating repetitive tasks