Description

This training program covers Alteryx Designer for new to intermediate and advance Alteryx users. It introduces the User Interface and works through primary Alteryx capability, introducing many tools with which you use to analyse and fix your data and prepare it for visualisation. The lessons are organised into modules that provide conceptual information, how-to steps, follow me, tutorials on each subject along with handy tips to make using Alteryx easier.

 

Radiant Teachlearning offers Alteryx Designer Training Program in Classroom and Virtual instructor Led/Online mode.

 

 

Duration: 3 day

Pre-requisite

 Audience Profile

  • Data Analysts who wish to explore their data and answer their business questions.
  • IT staff who want to validate data quickly and collaboratively with business
  • Participants may have experience with Excel or a traditional BI tool but little experience in connecting to data stored in different ways or in Data Discovery tools.

Course Content

Introduction

  • Understand Alteryx Designer terminology Workflow Canvas
  • Alteryx Designer Interface
  • Become familiar with Designer User and Workflow Settings

 

 

Alteryx Designer UI

  • Favorites Palette
  • Workflow Canvas
  • Tool Palettes
  • Configuration

 

 

Data Inputs

Introduction to supported data sources and connectivity

  • Input
  • Output
  • Directory
  • Text Input

 

Restructure your data

Skip records, split data, use a record as field headings, pivot and unpivot data and trim and split fields using:

  • Input Data
  • Dynamic Rename
  • Text to Columns
  • Transpose
  • Cross Tab
  • Formula
  • Directory
  • Cross Tab
  • Comment
  • Sample
  • Tool Container
  • Select
  • Filter
  • Output Data
  • Record ID
  • Unique

 

Join data from different sources

Join two tables from the same database, join result to an Excel spreadsheet and view the output as Pivot Table in Excel using:

  • Filter
  • Summarize
  • Browse
  • Union
  • Join Multiple
  • Input Data
  • Formula
  • Join
  • Output Data
  • Date Filter
  • Generate Row

 

Handling data

Missing data, Skip, Random sample, Append data

  • Random %
  • Sample
  • Unique
  • Running Total
  • Auto Field
  • Tile
  • Impute Values
  • Data Cleansing
  • Formula
  • Append Field
  • Multi Row Formula
  • Multi Filed Formula

 

 

Create static reporting:

Create a report including maps, charts and text all on the same page using:

  • Table
  • Charting
  • Layout
  • Date Time Now
  • Email
  • Sort
  • Render
  • Report Map
  • Report Text
  • Image

 

 

Perform spatial analysis:

Specify a trade area, match customers within trade area to the nearest store and draw a map showing the store trade area and the customers using:

  • Create Points
  • Spatial Match
  • Find Nearest
  • Trade Area
  • Distance
  • Spatial Info

 

Parsing data with regular expressions:

Use REGEX to parse input data to create a new field, filter by a parsed REGEX expression, split a field into multiple fields, select and ignore fields, apply a sequence number to all rows, output as a Tableau Data Extract, create spatial points, create a polyline from the spatial points and browse the final result using:

  • Multi-Row Formula
  • Record ID
  • Poly-Build
  • RegEx
  • Running total
  • Date time

 

 

Building Analytical App:

Create an Alteryx analytic application so that end-users without Alteryx Designer can run workflow published to the Alteryx Public Gallery. When running the app users will be able to supply input values at run time to modify the result using:

  • List Box
  • Numeric Up Down
  • Check Box
  • Control Parameter
  • Action
  • Image
  • File Browse
  • Radio Button

 

 

Connecting to Database:

In-Database allows analysis and blending against the large sets of data without shifting the data out of database and can provide performance optimization over traditional analysis methods. Traditional approaches need data to be moved out of the database into a separate environment for processing

  • Join In-DB
  • Data Stream In
  • Data Stream Out
  • Select In-DB
  • Connect In-DB
  • Filter In-DB
  • Formula In-DB
  • Summarize In-DB

 

 

Demographic Analysis:

Demographic Analysis category offer the ability to extract data utilizing the Allocate Engine within Alteryx.

  • Allocate Meta Info
  • Allocate Report
  • Allocate Append
  • Allocate Input tool

FAQs

Category:

Unble To Find a Batch..?

Request a Batch