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