Introduction
Alteryx Overview
- What is Alteryx?
- Alteryx features
Preparing the Development 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
In-Database Tools
- Connecting in-database tools
- Streaming data
Reporting and Documentation Tools
- Creating tables and charts
- Managing tools
Macros and R Programming
- Creating macros
- Forecasting with predictive models
- Embedding R code
Summary and Conclusion