This two-day Alteryx training course focusses on the fundamental and core functionality of Alteryx. Get hands on with the product to really know those core tools that you’ll be using over and over and over again in every workflow that you build so that you can use them efficiently and properly every time.

This class is for Beginner to Intermediate level Alteryx Designer Users and is appropriate for anyone working with data regardless of their analytical background. It can be delivered to a large team on-site or small groups and individuals may attend the public registration option, hosted at a training centre in central London.

You’ll learn how to:

• 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

• Create an Analytic App and save it to your the Alteryx Gallery Private Studio

• 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