Alteryx: Basic & Intermediate - Practical Data Preparation and Automation Training Course

Introduction to Alteryx and the Designer Environment

• Exploration of the Alteryx Designer interface and workflow canvas
• Configuration of workflows, tool palettes, and workflow properties
• Best practices for saving, documenting, and sharing workflows

Essential Data Preparation Tools

• Input and Output Data tools for connecting to CSV, Excel, and databases
• Using Select, Filter, Sort, and Browse for rapid data inspection and refinement
• Practical exercise: cleansing a sample dataset

Basic Data Transformation

• The Formula tool for calculated fields and conditional logic
• Data Cleansing techniques: managing nulls, trimming, and standardizing values
• Text to Columns and parsing delimited fields

Simple Data Combination

• Using Join and Union to combine datasets
• Summarize tool for aggregation and roll-ups
• Hands-on session: constructing an end-to-end ETL workflow

Advanced Data Blending and Parsing (Intermediate)

• Effective blending of multiple data sources and file formats
• Parsing semi-structured data: fundamentals of XML and JSON
• Techniques for validating and normalizing blended data

Basic Analytical Tools and Reporting

• Find Replace, Cross Tab, and Transpose for data reshaping
• Generating simple reports and exporting results
• Case study: producing a summarized operational report

Introduction to Macros and Reusability

• Types of macros: Standard Macros and their appropriate applications
• Creation, testing, and packaging of reusable macros
• Integration of macros within workflows to streamline processes

Workflow Automation Best Practices

• Organizing workflows using containers and annotations
• Considerations for error handling, logging, and scheduling
• Practical exercise: automating a recurring data preparation task

Summary and Next Steps