ALTERYX ONLINE TRAINING

For more details Please contact LEARNCHASE
www.learnchase.com
Whatsapp: +918123930940
E-mail Id: [email protected]
E-mail id: [email protected]

ALTERYX ONLINE TRAINING

Introduction of AlterYX
Understand Alteryx Designer terminology WorkflowCanvas
Alteryx Designer Interface
Become familiar with Designer User and Workflow Settings

Alteryx DesignerUI
ToolPalettes
Configuration
FavoritesPalette
Workf
lowCanvas

Restructure your data
Split data, skip records, use a record as field headings, pivot and unpivot data and trim and split fields using:

Input Data
DynamicRename
Text toColumns
Transpose
CrossTab
Formula
Directory
Cross Tab
Comment
Sample
ToolContainer
Select
Filter
Output Data
Record ID
Unique

Join data from different sources
Join two tables from the same database, join the result to an Excel spreadsheet and view the output as a 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

Impute Values
Data Cleansing
Formula
Append Field
Random % Sample
Unique
Running Total

Create static reporting
Create static reporting: Create a report including maps, charts and text all on the same pageusing:

Table
Charting
Layout
Date TimeNow
Email
Sort
Render
ReportMap
ReportText
Image
Perform spatial analysis

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

CreatePoints
SpatialMatch
FindNearest
TradeArea
Distance
S
patialInfo

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, create spatial points, output as a Tableau Data Extract, create a polyline from the spatial points and browse the final result using:

Multi-Row Formula
Record ID
Poly-Build
RegEx
Text to Columns

Building Analytical App
Create an Alteryx analytic application so that end-users without Alteryx Designer can run a 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 UpDown
Check Box
Control Parameter
Action
Image
File Browse
Radio Button

Macro
Create a macro that will run through every record and then loop the records back through the workflow, repeating the entire process as many times as is specified, or until a condition is met:

Create standard macro
Batch macro
Macro Input
Macro Output
Dynamic Rename
Dynamic Input
Control Parameter
Action

Fuzzy Match
Introduces Alteryx tools to match customer data against a master list of customers and use G-NAF datafiles:

InputData
Union
Unique
Select
Formula
Browse
FuzzyMatch
Jo
in
Filter
Auto Field

Connecting to Database
In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. Traditional approaches require 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

Predictive Tools
Audience:

Anyone who currently works with or analyses data, including business analysts, data analysts and developers.

Pre-Predictive/Data Investigation Tools:

Before a process or analysis takes place, users need to understand the details of their data. Alteryx gives users an array of Data Investigation tools to quickly and easily understand their data.

Field Summary Report
Frequency Table
Create Samples
Association Analysis
Distributed Analysis

Time Series Forecasting
Illustrates how to use several of the univariate times series tools to build, verify and make forecasts in Alteryx:

ETS
TS Compare
ARIMA
TS Forecast

Regression Techniques
Investigate your data by visualisation, predict likelihood of donation and score before deciding on the number of university new donors to target with a donation campaign. This introduces the following Alteryx tools:

Score
Visualization
Lift Chart
Nested Test
Linear Regression
Logistic Regression
StepwiseRegression
Decision Tree

Clustering
Partition records into K groups around centroids by assigning cluster memberships, using K-Means, KMedians, or Neural Gas clustering.

Append Cluster
K-Centroids Analysis
Visualization

Case Studies
These case studies are designed for the class to have the practice during the sessions, after discussion of each topic there will be a case study that audience has to develop in their machines.

Data will be shared with everyone before each case study

Blending Data
Preparing Data containing Date/Time fields
Preparing Data containing Date/Time fields
Data cleansing processes
Reading, Writing and Data Blending
Performing Analytical Ranking
Analytics Rolling Average
Using RegEx SocialMedia solution
RegEx Analytics
Data Prep and Blending using Fuzzy Matching
Parsing Data
Preparing Reporting
Reporting Solution for Excel
Building Analytical Apps in Alteryx
Create a Standard Macro
Create a batch macro
Spatial Trade Area Development
Find all customers within 30 miles of a store
Performing Partitioning Cluster Analysis
Time Series Analytics

For more details Please contact LEARNCHASE
www.learnchase.com
Whatsapp: +918123930940
E-mail Id: [email protected]
E-mail id: [email protected]