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
Introduction
- Tableau Prep Builder as an ETL (Extract, Transform and Load) tool
Setting up Tableau Prep Builder
- Activating and Register Tableau Prep Builder
Overview of Tableau Prep Builder Features and Architecture
- Tableau Prep Builder and its relation to Tableau Desktop, Tableau Server and Tableau Prep Conductor
Navigating the Tableau Prep Builder Workspace
Connecting to Data Source
- Reading an Excel
- Reading from a database
Shaping Data
- Creating a Join
- Creating a Union
Pivoting Data
Cleaning Data
- What is dirty data?
- Changing the data type
- Filtering data
- Aggregating data
- Updating multiple values at once
Running a Flow
- Building a flow
- Refreshing a flow
- Running a flow from the command line
Outputing Data to Tableau Desktop
Publishing Data
- Packaging a Prep Builder data flow into an extract
- Publishing a flow with Prep Conductor
Best Practices
Troubleshooting