Duration
2 days
Introduction
Alteryx Overview
- What is Alteryx
- Alteryx features
Preparing the Development Environment
- Installing and configuring Alteryx
- Navigating the interface
Alteryx Quick Start
- Importing data
- Creating and executing a workflow
- Working with documentation tools and cumulative tools
Input and Read
- Connecting, reading, and writing to a data source
- Importing data
- Using the input tool and browse tool
In-database tools
- Connecting In-database tools
- Streaming data
Preparation tools
- Cleansing, filtering, and sorting data.
- Working with fields/columns
- Finding and replacing data
- Merging data
- Matching data
Data Wrangling
- Creating custom formulas, algorithms, and calculations
- Performing data transformations
- Aggregating data
- Using various pivot methods
- Working with unions and joins
- Using regular expressions
Data visualization and Reporting
- Creating data visualizations
- Creating tables and charts
- Reporting layouts
- Automating reporting
Macros and Python Programming
- Creating macros
- Forecasting with predictive models
- Embedding R code
Summary and Conclusion
Programme scope, delivery arrangements and suitability are confirmed during enquiry.