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
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
