Course Description
This 2-day Alteryx Designer training provides students with the skills and knowledge necessary to design, build, test, and maintain Alteryx workflow processes with Alteryx Designer. Students will learn how to create complete end-to-end data pipelines.
Course Outcomes
At the end of the course, learners will be able to:
- Use the Alteryx Designer interface to design data workflows.
- Connect to a plethora of data sources and write into numerous output sources.
- Clean and update your data and create useable datasets
- Use your effort to create repeatable workflows
- Filter, join, aggregate, blend and prep data.
- Apply expression logic to data without writing SQL
- Preparation for Alteryx Designer Core Exam
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Designer Overview – Navigating the Interface
- Reading Data – Input Data tool, Sample tool
- Writing Data – Output Data tool
- Data Types – Auto Field tool, Select tool
- Conditional Expressions
- Compound expressions
- Data blending – union
- Joining data
- Formulas, String Expressions – Formula Basics, Conditional expressions, Introduction to calculations, Working with words
- Aggregation – Top 10 lists, Sort and Sample Tools
- Aggregating Data From Multiple Rows – Summarize tool
- Applying Formulas to Multiple Fields – Multi-Field Formula tool
- Calculating with Several Rows – Multi-Row Formula, Appending Data to Another Data Set, Append Tool
- Find and Replace
- Data Transformations – Cross Tab Tool, Transposing Data
Testimonials
“The trainer was INCREDIBLE. He was extremely passionate, made sure to consistently ask if anybody needed help, logged on early to answer any questions, and was an overall great human being.”
- Salvatore, Hilton Grand Vacations
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
“The Tableau Visual Analytics session with Michael was awesome, he is a really good instructor”
- Graciela Kahn, Director, Business Intelligence, NeighborWorks America
