Loading...

ALT10G – Alteryx Designer – Core Concepts

Home / ALT10G – Alteryx Designer – Core Concepts

Course Outline:

Course Outline:

  • 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
  • Clean unwanted characters in records
  • Order 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
  • Identify unique records
  • 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
  • Parse data
  • Work with date/time fields
  • 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 field
  • Pivot data
  • Group and Bin Records
  • Aggregate data
  • Workflow best practices
  • Cache a portion of your workflow
  • Output data to different file formats

Course Audience & Prerequisites:

Audience

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

Prerequisites

None

 

Course Offerings:

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.

  • Course Outline
  • Course Audience & Prerequisites
  • Course Offerings
  • Related Courses

Course Outline:

  • 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
  • Clean unwanted characters in records
  • Order 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
  • Identify unique records
  • 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
  • Parse data
  • Work with date/time fields
  • 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 field
  • Pivot data
  • Group and Bin Records
  • Aggregate data
  • Workflow best practices
  • Cache a portion of your workflow
  • Output data to different file formats

Audience

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

Prerequisites

None

 

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.

ALT20G – Alteryx Designer – Advanced Concepts

This course teaches students higher-level Alteryx abilities and builds on the ALT10G – Alteryx Designer – Core Concepts course. Students will learn more advanced preparation, blending and parsing techniques. Other areas explored include; spatial analytics for creating points, lines and polygons, creating reports for consumption, macros and applications to minimize workflow dependencies, and an introduction to the Alteryx Gallery.   This course provides students with the skills required to prepare for the Alteryx Designer Advanced Certification Exam.

ALT30G – Alteryx Designer – Predictive Concepts

This course is designed to teach students how to utilize Alteryx to perform predictive analytics. Concepts covered in this course include: Time series, regression, predictive grouping, and how to create an R Macro in Alteryx. Students will learn how to prepare and analyze data before running it through models to ensure to create meaningful predictive investigations.

ALT40G – Alteryx Server Fundamentals

This course teaches students the ins and outs of Alteryx server deployment, including the Gallery, Controller, and Scheduler. Students will review server architectures, learn to appropriately allocate resources, and provision controller and worker nodes, all with an understanding of modern distributed computing.