Alteryx Designer – Introduction is an excellent opportunity to discover how Alteryx can help solve even the most complex data challenges.

Alteryx is a data analytics platform designed to simplify and automate the process of preparing, analyzing, and sharing data insights. It enables users—from business analysts to data scientists—to perform complex data operations with minimal coding, using a visual, drag-and-drop interface.

This one-day hands-on course is perfect for beginners, or anyone looking to explore and learn the basics of Alteryx. It’s designed for all professionals who work with data, regardless of their analytics background. If you’re comfortable using Excel, you’ll find it easy to pick up Alteryx Designer.

During the course, you’ll explore fundamental concepts and key tools for data preparation, blending, and workflow automation, including basic macros. By the end, you’ll have the confidence and skills needed to start creating your own efficient data workflows.

• Alteryx Designer user interface and canvas
• Alteryx native file formats
• Read (Input) / Write (Output) Data
• Tools: Browse, Sample, Select, Sort, Filter, Cleansing, Date Tools, Formulas, Joins, Unions, Append, Summarize, Cross Tab, Text To Columns, Transpose, Unique.
• Macros
• Analytical App
• Macro Interface tools and Actions
• Spatial Analytics (demo)

By the end of this course, you will have the ability to perform the following tasks:

• Use Alteryx Designer search and resources
• Navigate the user interface
• Identify Alteryx native file formats
• Read and write data
• Interpret common data types
• Cleanse data using the Data Cleansing tool
• Build formulas (e.g. reference formulas, conditional statements)
• Filter and arrange data using tools: Select, Sort, Filter, Unique, Sample
• Perform unions, joins, and appends
• Leverage the Find and Replace tools
• Convert data string formats to and from date formats
• Delimit data with the Text To Columns tool
• Troubleshoot (e.g. duplication within joins, incompatible data types, mismatched fields)
• Transform Data
• Apply the Summarize Tool
• Configure the Transpose Tool
• Apply the Cross Tab Tool (e.g. grouping data, methods of aggregation)
• Convert a workflow to a Macro
• Understand the differences of Macros (Standard, Batch, Iterative)
• Create an Analytical App
• Using Macro Input and Output
• Adding Interface tools and Actions
• Running the Macros and Analytical Apps.
• Spatial Analytics (demo)

Instructor-led hands-on workshop