ALT10G – Alteryx Designer – Core Concepts & Intermediate Training

Home / ALT10G – Alteryx Designer – Core Concepts & Intermediate Training

This course teaches students the building blocks required to complete more complex analytical tasks with Alteryx Designer. Students will gain a thorough understanding of important concepts that will enable them to prepare, parse, blend, transform and analyze data from disparate sources and output their results. The students will also learn the skills they need to easily and quickly cut down their development time, along with topics such as data connections, macros, analytical apps, and optimizing workflows. They will learn how to manipulate data structures and learn the best practices within Alteryx along with variety of ways to parse data, understand the difference between the 3 main macro types, and how to configure macros.

Course Length: 1 day(s)

Course Price: $700 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online

Enroll Now

Course: ALT10G – Alteryx Designer – Core Concepts & Intermediate Training

Core Concepts:

  • Understand Alteryx Designer terminology
  • Easily navigate the Alteryx Designer Interface
  • Become familiar with Designer User and Workflow Settings
  • Be able to share and save workflows
  • Understand how Designer processes data
  • Connect to and update data sources:
    • Files and databases
    • Dynamically load Excel Spreadsheets
    • Bulk load text-based files such as CSV
    • Write back to the original data source
  • Order and sample records
  • Rename fields manually and dynamically
  • Detect and change field data types manually and automatically
  • Filter records and use conditional expression to update/add fields
  • Blend data from disparate sources:
    • Append records from different sources
    • Merge records from different sources on key fields
    • Add fields from one data set to all records in another
  • Pivot data
  • Group and Bin Records
  • Aggregate data
  • Build expressions to add and update fields, by performing basic calculations
    • Replacing text within a field
    • Using string length and positions
    • Parse data from one field into multiple fields
  • Work with date/time fields
  • Output data to different file formats

Intermediate Concepts:

  • Introduction
  • Advanced Importing Methods
  • Parsing
  • Structural Data Transformations
  • Repeatable Processes and Macros
  • Analytical Applications
  • Best Practices
  • Manipulate data structures


This class is for Beginner to Intermediate level Alteryx Designer Users and is appropriate for anyone working with data regardless of their analytical background.


Instructor Led In Classroom

Newcomp can directly deliver courses through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.