The Course Content
Day One: Introduction to Alteryx
What is Alteryx and why use it?
Install and activate Alteryx Designer
Navigate the Alteryx interface and use the canvas, tool palette, configuration window, results window, and workflow view
Connect to various data sources and use the input data tool
Browse, filter, sort, and summarize data using the browse, filter, sort, and summarize tools
Join, union, and append data using the join, union, and append tools
Exercises and examples
Day Two: Working with Data Preparation and Transformation
The select tool to modify data types, field names, and field order
The formula tool to create and edit calculations and expressions
The text to columns tool to split data into multiple fields
The transpose and cross tab tools to reshape data
The sample tool to select a subset of records
The unique tool to remove duplicate records
Exercises and examples
Day Three: Working with Data Analysis and Reporting
The find replace tool to replace values based on a reference table
The fuzzy match tool to identify similar records
The spatial tools to perform geospatial analysis and mapping
The predictive tools to perform statistical analysis and machine learning
The reporting tools to create charts, tables, maps, and dashboards
Exercises and examples
Day Four: Working with Macros and Apps
Macros and how to create them in Alteryx
The macro input and macro output tools
The action tool to modify tool configurations within a macro
The interface tools to create user inputs and outputs for a macro
Saving a macro as an app and run it in Alteryx Gallery or Server
Exercises and examples
Day Five: Advanced Topics and Tips
The dynamic input tool to change data sources at runtime
The download tool to access web data using APIs
The run command tool to execute external commands
The Alteryx scripting tools, including Python and R1
Optimizing your workflow for performance and best practices
Troubleshooting common errors and issues in Alteryx
Exercises and examples