This one-day instructor-led course provides participants who already possess knowledge of Alteryx Designer with deeper insight into its advanced capabilities. Building on foundations covered in the Level 1 course, this training focuses on sophisticated features that enable more complex data extraction, transformation, and data loading operations using Alteryx's In-DB tools. You will also see demonstrations of the platform's procedural programming features and how they expand your analytical possibilities.
Audience Profile:
The primary audience for this course is business intelligence professionals and technically skilled business users who want to perform advanced data analysis with Alteryx Designer.
Prerequisites:
This course assumes you have completed the Alteryx Concepts: Level 1 course or possess equivalent knowledge of the topics covered in that foundational training.
Course Outline:
Review of Alteryx Designer Basics
- Overview of the Alteryx Analytics Platform
- Acquiring and preparing data sources
- Shaping and transforming data for analysis
- Creating and distributing analytical reports
In-DB Tools
This module introduces tools that facilitate direct interaction with live relational databases, allowing you to perform sophisticated operations without extracting data into memory.
Topics include:
- Browse In-DB
- Connect In-DB
- Data Stream In and Out
- Filter In-DB
- Join In-DB
- Macro Input and Output In-DB
- Select In-DB
- Summarize In-DB
- Union In-DB
- Write Data In-DB
- Sample In-DB
Integrating with Other Systems:
Alteryx provides numerous tools and connectors that simplify integration with external platforms and services, expanding your analytical capabilities.
Topics include:
- The download tool and external service connections
Procedural Programming:
Although Alteryx is engineered for simplicity in data acquisition and transformation, it includes sophisticated, flexible programming tools for constructing advanced solutions. This module demonstrates the programming features that allow you to build complex, customized analytical workflows.
