CTC- AlterYX Syllabus
Applying different algorithms to solve the business problems to understand the Industry application 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 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 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 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 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
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
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
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
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