BECOME A Alteryx EXPERT
Holistic Curriculum | Complete Practical Driven Learning | Real-Time Projects | Be a Future Ready
Key Highlights of Alteryx Online training
- Curriculum is curated by Industrial Experts in Alteryx
- Extensive study on real time projects
- Handouts, Exercises and Assignments on each and every topic
- Work on Real-time scenarios
- 100+ Hands on Practical Assignments
- Real time work on currently running projects
- Resume preparation
- Mock Interviews
- 100% Placement Assistance
- All classes will be recorded and sent to you everyday
- Get Certified
Timmings
Mon-Friday |
One hour per day |
|---|
Sat & Sunday |
3 Hours per day |
|---|
Course Duration
Coures Name |
Type |
Course Duration |
Price |
Alteryx |
Training |
18,000/- |
|
Alteryx |
Workshop |
||
Alteryx |
Training & Workshop |
Alteryx Course Content
From this section, you will get an overview of the AlterYX course. And also, you will learn the following fundamental concepts.
- Understanding Alteryx Designer
- Alteryx designer Interface
- User and Workflow settings
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
- 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