CTC- AlterYX Syllabus
Introduction of AlterYX
- Understand Alteryx Designer terminology WorkflowCanvas
- Alteryx Designer Interface
- Become familiar with Designer User and Workflow Settings
Alteryx DesignerUI
- ToolPalettes
- Configuration
- FavoritesPalette
- WorkflowCanvas
Alteryx DesignerUI
- ToolPalettes
- Configuration
- FavoritesPalette
- WorkflowCanvas
Handling data
- Missing data, Skip, Random sample, Append data
- Impute Values
- Data Cleansing
- Formula
- Append Field
- Random % Sample
- Unique
- Running Total
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
Create static reporting
Create static reporting: Create a report including maps, charts and text all on the same page using:
- Table
- Charting
- Layout
- Date TimeNow
- Sort
- Render
- ReportMap
- ReportText
- Image
- Perform spatial analysis
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
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
- SpatialInfo
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 Column
Assignments and PROJECT – CONSOLIDATE LEARNINGS
Applying different algorithms to solve the business problems to understand the Industry application