Learner Discussions

Connect with other learners by posting your questions, sharing ideas, and getting involved in a discussion.

Recording - Mastering Alteryx Designer Tools Session 2 | Alteryx Data Preparation

Alteryx Alumni (Retired)



Hi SparkED Network! Below is a recording of Session 2 of the Mastering Alteryx Designer Tools Training, where Alteryx ACE, @Deanna Sanchez, continues the series with Alteryx Data Preparation. Gain experience with tools such as Filter, Sort and Summarize as you analyze Airline Passenger Satisfaction Data. Additionally, you'll understand techniques for data filtering, sampling and grouping. The packaged workflow is attached to this thread. Deanna also builds upon Session One's pizza sales workflow - (Session 1 Recording Here). 


Weekly Challenges for Session 2: 

- Weekly Challenge # 348: Reorder a List of Names

Uses the Trim String Formula Functions


- Weekly Challenge #164: Retail Therapy

Uses a Join but can be performed without one


- Weekly Challenge # 291: A Winning Halloween Candy Basket

Uses a Join Multiple or Two Joins


Mastering Alteryx Designer Tools: A Foundational Training is a beginner-level training, designed exclusively for SparkED students, learners and educators with basic analytics knowledge and little to no experience with Alteryx Designer. 


We will dive into the world of data preparation, manipulation, and analysis with the guidance of our Alteryx ACES - Analytics experts and community advocates. Deanna Sanchez, Alteryx ACE and GIS (Geographical Information Systems) expert, will be leading these trainings this upcoming Fall, sharing her expertise on all things data analytics and Designer core tools and functions through hands-on Alteryx Designer application with sample and/or publicly available datasets.


Participants will gain mastery over a variety of Alteryx Designer tools, including Input Data and Output Data Tools, Filter Tool, Union Tool, Parsing Tools, among many others. We'll provide you with real-world scenarios to put your skills to the test and gain practical data analytics and Alteryx experience. Whether you're a SparkED student hungry for analytics knowledge or a curious learner seeking hands-on Alteryx experience, this is the training series for you! 


Training Schedule 

  • Session 1: Intro to Alteryx - Monday 9/25/23 3:30 - 5:00 PM MST
  • Session 2: Alteryx Data Preparation - Monday 10/23/23 3:30 - 5:00 PM MST 
  • Session 3: Alteryx Joins and Unions - Monday 11/13/23 3:30 - 5:00 PM MST Register Here 
  • Session 4: Data Manipulation and Transformation - Monday, 12/11/23 3:30 - 5:30 PM MST Register Here 


5 - Atom


Where is the airline_passenger_satisfaction file that supports the video?  The materials on the weblink for the recording include the Alteryx workflow but the datafiles are not included


Alteryx Alumni (Retired)

Hi @CharlesMarquis - I attached the datasets!