1. Introduction
● Overview of the course
● Course objectives: Focus on ETL (Extract, Transform, Load) functions and practical skills for reporting and reconciliation
2. Alteryx Overview
● What is Alteryx?
● Key features of Alteryx
● Understanding Alteryx's role in data analytics and automation
3. Input Tools
● Connecting to data sources
● Writing to a data source
● Using the Browse tool to inspect data
4. 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
5. 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
6. 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
7. Macros and Advanced Functions (Optional, advanced topics)
● Introduction to Macros: Automating repetitive tasks