Alteryx Designer

Course Description

This 2-day Alteryx Designer training provides students with the skills and knowledge necessary to design, build, test, and maintain Alteryx workflow processes with Alteryx Designer. Students will learn how to create complete end-to-end data pipelines.

Course Outcomes

At the end of the course, learners will be able to:

  • Use the Alteryx Designer interface to design data workflows.
  • Connect to a plethora of data sources and write into numerous output sources.
  • Clean and update your data and create useable datasets
  • Use your effort to create repeatable workflows
  • Filter, join, aggregate, blend and prep data.
  • Apply expression logic to data without writing SQL
  • Preparation for Alteryx Designer Core Exam

Course Summary

Next Public Course Dates

UK & Europe:

  • 26 - 27 November 2024
  • 10 - 11 December 2024
  • 14 - 15 January 2025

US & Canada:

  • 19 - 20 November 2024
  • 3 - 4 December 2024
  • 17 - 18 December 2024

More dates

Prerequisites
  • None
Duration
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
  • 60% theoretical, 40% practical
Audience
  • Data workers with little or no experience of Alteryx Designer
  • Financial specialists confronted with the boundaries of spreadsheets

Course Modules

  • Designer Overview – Navigating the Interface
  • Reading Data – Input Data tool, Sample tool
  • Writing Data – Output Data tool
  • Data Types – Auto Field tool, Select tool
  • Conditional Expressions
  • Compound expressions
  • Data blending – union
  • Joining data
  • Formulas, String Expressions – Formula Basics, Conditional expressions, Introduction to calculations, Working with words
  • Aggregation – Top 10 lists, Sort and Sample Tools
  • Aggregating Data From Multiple Rows – Summarize tool
  • Applying Formulas to Multiple Fields – Multi-Field Formula tool
  • Calculating with Several Rows – Multi-Row Formula, Appending Data to Another Data Set, Append Tool
  • Find and Replace
  • Data Transformations – Cross Tab Tool, Transposing Data

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line