Course Code:
alteryxcustomized
Duration:
14 hours
Course Outline:
- Introduction
- Alteryx Overview
- What is Alteryx?
- Alteryx Features
- Preparing and Developing 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
- Data Wrangling
- Creating custom formulas, algorithms and calculations
- Performing data transformations
- In-Database Tools
- Connecting in-database tools
- Streaming data
- Reporting and Documentation tools
- Creating tables and charts
- Managing tools
- Data Investigation
- Spatial tools
- Automating reporting
- Macros and Programming
- Creating macros
- Building predictive models