BECOME A Alteryx EXPERT

In the AlterYX designer section, you will learn how to provide a single platform that lets you rapidly process large volumes of data without writing any code. Also, you will learn how to leverage multiple tools to pull together all the relevant data you need for your analytics.

• Tool Palettes
• Configuration
• Favorite Palettes
• Workflow Canvas

In this session, you will learn how to extract, filter, transform, group, cleanse, and join the data across various sources using AlterYX Designer.

Topics:

• Split data, skip records, use a record as field headings, pivot and unpivot data and trim and split fields
• Input Data
• DynamicRename
• Text to columns
• Transpose
• Cross Tab
• Formula
• Directory
• Comment
• Sample
• Tool Container
• Select
• Filter
• Output Data
• Record Id
• Unique

In this section, you will learn how to join two tables from the same database, and you will view the output in the form of pivot tables in the excel sheet using the following features.

Topics: 

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

In this section, you will learn how to handle the appended, missing, and skipped data in the AlterYX tool.

Topics:

• Impute Values
• Data Cleansing
• Formula
• Append Field
• Random Sample
• Unique
• Running tool

In this chapter, you will learn how to create static reports, including maps, charts, and texts.

Topics: 

• Table
• Charts
• Layout
• Datetime Now
• Email
• Sort
• Render
• resort map
• ReportText
• Image

In this session, you will learn how to make business decisions using geospatial data and analyze the data to optimize the transportation and logistics, sales territories, or coverage area to deliver powerful results.

Topics:

• CreatePoints
• SpatialMatch
• FindNearest
• trade area
• Distance
• special info

In this section, you will learn the uses of Regex tools in AlterYX, such as matching, parsing, tokenizing, and replacing. Also, you’ll learn how to create an Alteryx analytic application so that end-users can run a workflow published to the Alteryx Public Gallery without Alteryx Designer.

Topics:

• List Box
• Numeric UpDown
• CheckBox
• Control Parameter
• Action
• Image
• File Browse
• Radio Button

In this chapter, you will learn how to create an analytical application in the AlterYX tool.

Topics:

• List Box
• Numeric UpDown
• CheckBox
• Control Parameter
• Action
• Image
• File Browse
• Radio Button

In this session, you’ll learn how to create a macro that will run through every record and then loop the records back through the workflow.

Topics: 

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

In this chapter, you will get an overview of AlterYX tools like sample, filter, select, sort, and more.

Topics:

• input data
• Unique
• Select
• Union
• Formula
• Browse
• FuzzyMatch
• Join
• Filter
• Auto Field

In this session, you’ll learn how to enable the blending and analysis against large sets of data without moving the data out of a database. Also, you’ll gain knowledge on traditional approaches that require data to be moved out of the database into a separate environment for processing.

Topics:

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

In this chapter, you will learn various regression techniques and how to investigate your data by visualizing.

Topics: 

• Score
• Visualization
• Lift Charts
• Nested test
• Linear regressions
• Logistic Regressions
• Stepwise Regressions
• Decision tree

In this chapter, you will learn how to partition the records into “K groups” around centroids by assigning cluster memberships, using K-Means, KMedians, or Neural Gas clusterings.

Topics:

• Append Cluster
• K-Centroids Analysis
• Visualization

You’ll have a practice session on each topic after completion of the discussion. Our trainer will share with you a few case studies on each topic, and you need to practice those in your machine.

Topics:

• Blending Data
• 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