Introduction
Alteryx Overview
- What is Alteryx?
- Alteryx features
Preparing the Development Environment
- Installing and configuring Alteryx
Input and Read
- Connecting data sources to Alteryx
- Importing data
- Using the input tool
Data Wrangling
- Using data preparation tools and parsing tools
- Working with joins and unions
Transformations
- Using various pivot methods
- Aggregating data
Layouts
- Reporting layouts
- Exporting reports
Summary and Conclusion
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
Data Management
- Preparing and cleansing data
Data Wrangling
- Creating custom formulas, algorithms, and calculations
- Performing data transformations
Data visualization
- Integrating a BI platform (Tableau, Power BI, etc.)
- Creating data visualizations
- Automating reporting
Summary and Conclusion
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