Alteryx Training

Stalwart Learning Alteryx training enables you to master Alteryx for advanced data analytics through hands-on sessions with real-life examples. We will walk you through the key fundamentals of Alteryx, from…

Created by

Stalwart Learning

Date & Time

Price

Duration

4 Days

Location

https://stalwartlearning.com

ENQUIRE NOW


Course Description

Overview of Alteryx

Stalwart Learning Alteryx training enables you to master Alteryx for advanced data analytics through hands-on sessions with real-life examples. We will walk you through the key fundamentals of Alteryx, from installation to connecting different data sources, performing analytics, creating macros, building analytical apps, and more.

Duration

4 Days

Prerequisite for Alteryx

Anyone who currently works with data, including business analysts, data analysts and developers.

Course Outline for Alteryx

An Introduction to Alteryx
  • What Is Alteryx Analytics Platform? Alteryx Gallery
  • The Alteryx Interface The Interface
  • File Menu Edit Menu View Menu Options Menu Help Menu Samples
  • User Settings Toolbar
  • Tool Palette
  • Results Window Properties Window Interface Designer Canvas
  • Using Tools
Insert Tool Menu
  • The Games
  • Tools & Concepts Improved Features Browse
  • Cross Tab Comment Filter
  • Formula Input Data Join
  • Output Data Running Total Sample
  • Select Sort
  • Summarize Tool Container Transpose
  • Union Freestyle
  • Let’s Tidy Things Up – Workflow to optimize viewing Modern History
  • Brains vs Brawns – Alteryx Perspective
Data Preparation
  • Tools & Concepts Imputation
  • Multi‐Field Formula 
  • Multi‐Row Formula 
  • Text Input
The Direct Approach
  • Tools
  • Append Fields 
  • Date Time Now 
  • Date Time
  • Directory
  • How is it achieved?
Cultural Musings
  • Tools & Concepts 
  • Allocate Input 
  • Find Replace
  • Join Multiple
  • Text to Columns
  • Culturally Divided – Division of Data by columns
Reporting in Alteryx
  • Tools & Concepts 
  • Charting 
  • Create Points
  • Layout Render Report Footer Report Map Report Header Table
Expensive Beauty Products ‐ How Alteryx joins between DB’s
  • Tools & Concepts 
  • Fuzzy Match
  • Record ID 
  • RegEx 
  • Unique
  • Tool Container 
  • More Flags
Applications Wanted
  • Tools & Concepts 
  • Action
  • Condition Date
  • Date Filter
  • Drop Down 
  • File Browse 
  • Radio Button 
  • Text Box
  • Let’s Build an App for That!
  • To Summarize or Not to Summarize: That is the Question
What’s inside the DB (How to use data coming in from multiple sources)
  • Tools & Concepts 
  • Macro Input
  • Macro Output 
  • Map
  • Map Input
  • Numeric Up Down
Meta‐Morphosis
  • Tools & Concepts
  • Check Box
  • Detour
  • Detour End
  • Dynamic Rename 
  • JSON Parse
  • Message
  • All the Tools 
  • Along the Way Narrowing Down the Search

ENQUIRE NOW