Alteryx Interface & Workflow Basics
Navigating the Alteryx Designer interface.
Understanding the workflow canvas.
Tool palette overview.
Data Input & Output
Connecting to various data sources (Excel, CSV, databases).
Using Input and Output tools.
Handling different data formats.
Data Preparation & Cleaning
Filtering and sorting data.
Data cleansing techniques.
Removing duplicates and handling null values.
Data Transformation
Join, Union, and Append tools.
Summarization and grouping.
Formula tool for calculations.
Working with Data Types
Understanding data types.
Data conversion and formatting.
Date and string manipulation.
Advanced Data Processing
Using Multi-Row and Multi-Field tools.
Spatial data basics.
Parsing and reshaping data.
Analytical Tools
Regression basics.
Predictive analytics overview.
Using built-in analytical tools.
Workflow Automation
Scheduling workflows.
Batch macros and iterative macros.
Error handling techniques.
Reporting in Alteryx
Generating reports and dashboards.
Exporting data to Excel and PDF.
Visual insights basics.
Macros in Alteryx
Understanding macros.
Creating standard and batch macros.
Reusability of workflows.