Module 1. Introduction to Alteryx
- Understanding Alteryx Designer
- Alteryx designer Interface
- User and Workflow settings
Module 2. Alteryx Designer
- Tool Palettes
- Configuration
- Favorite Palettes
- Workflow Canvas
Module 3. Restructuring the data processing
- Split data, skip records, use a record as field headings, pivot and un-pivot data and trim and split fields
- Input Data
- Dynamic Rename
- Text to columns
- Transpose
- Cross Tab
- Formula
- Directory
- Comment
- Sample
- Tool Container
- Select
- Filter
- Output Data
- Record Id
- Unique
Module 4. Join Data from Different Sources
- Filter
- Summarize
- Browse
- Union
- Join Multiple
- Input Data
- Formula
- Join
- Output Data
- Data Filter
- Generate Row
Module 5. Handling Data
- Impute Values
- Data Cleansing
- Formula
- Append Field
- Random Sample
- Unique
- Running tool
Module 6. Create Static Reporting
- Table
- Charts
- Layout
- Datetime Now
- Sort
- Render
- resort map
- ReportText
- Image
Module 7. Spatial Analysis
- CreatePoints
- SpatialMatch
- FindNearest
- Trade area
- Distance
- Special info
Module 8. Phrase Data with Regex
- List Box
- Numeric UpDown
- CheckBox
- Control Parameter
- Action
- Image
- File Browse
- Radio Button
Module 9. Analytical App
- List Box
- Numeric UpDown
- CheckBox
- Control Parameter
- Action
- Image
- File Browse
- Radio Button
Module 10. Macro
- Create standard macro
- Batch macro
- Macro Input
- Macro Output
- Dynamic Rename
- Dynamic Input
- Control Parameter
- Action
Module 11. Join and Data Blend
- Input data
- Unique
- Select
- Union
- Formula
- Browse
- FuzzyMatch
- Join
- Filter
- Auto Field
- Module 12. Database Connections
- Join In-DB
- Data Stream In
- Data Stream Out
- Select In-DB
- Connect In-DB
- Filter In-DB
- Formula In-DB
- Summarize In-DB
- Module 13. Regression Techniques
- Score
- Visualization
- Lift Charts
- Nested test
- Linear regressions
- Logistic Regressions
- Stepwise Regressions
- Decision tree
Module 14. Clustering
- Append Cluster
- K-Centroids Analysis
- Visualization
Module 15. Case Study
- Blending Data
- Preparing Data containing Date/Time fields
- Data cleansing processes
- Reading, Writing and Data Blending
- Performing Analytical Ranking
- Analytics Rolling Average
- Using RegEx SocialMedia solution
- RegEx Analytics
- Data Prep and Blending using Fuzzy Matching
- Parsing Data
- Preparing Reporting
- Reporting Solution for Excel
- Building Analytical Apps in Alteryx
- Create a Standard Macro
- Create a batch macro
- Spatial Trade Area Development
- Find all customers within 30 miles of a store
- Performing Partitioning Cluster Analysis