Alteryx Training and Certification Course

BY
Mindmajix Technologies

Mode

Online

Duration

20 Hours

Fees

₹ 8800 11000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 8,800  ₹11,000
certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Module 1 - Introduction to Alteryx

  • Understanding Alteryx Designer
  • Alteryx designer Interface
  • User and Workflow settings

Module 2 - Alteryx Designer

  • Tool Palettes
  • Configuration
  • Favorite Palettes
  • Workflow Canvas

Module 3 - Restructuring the data processing

  • 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

Module 4 - Join Data from Different Sources

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

Module 5 - Handling Data

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

Module 6 - Create Static Reporting

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

Module 7 - Spatial Analysis

  • CreatePoints
  • SpatialMatch
  • FindNearest
  • Trade area
  • Distance
  • Special info

Module 8 - Phrase Data with Regex

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

Module 9 - Analytical App

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

Module 10 - Macro

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

Module 11 - Join and Data Blend

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

Module 12 - Database Connections

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

Module 13 - Regression Techniques

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

Module 14 - Clustering

  • Append Cluster
  • K-Centroids Analysis
  • Visualization

Module 15 - Case Study

  • 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

Module 16 - Practice Test & Interview Questions

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses