Overview

Hi SparkED Network! Below is the Session 3 recording of the Mastering Alteryx Designer Tools Training. During this training, Alteryx ACE, @Deanna Sanchez, brings back the pizza sales data to demonstrate the join and union tools. The packaged workflows are attached to this thread.     Try these weekly challenges to test your new skills: #189: Billboard Top 100 #364: Career-Minded Barbie #335: Movie Decisions 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!    Join us for the final session of the year on Monday, 12/11/23 3:30 - 5:30 pm MST where Deanna will cover Data Manipulation and Transformation. Register Here! ... View more

Hello SparkED students and learners,   We hope your journey in analytics has been going well! As part of our commitment to providing you with the best learning experience, we invite you to participate in a Career Impact Survey.   Access the Survey Here   We’re aiming to find out if you’ve been able to use your Alteryx knowledge as part of a job search or even in a new career. Answering our questions should only take ten minutes or less.   Thank you in advance for your participation!   We greatly value your input and encourage you to share your honest feedback with us. Thank you for being an integral part of the Alteryx SparkED community.   The Alteryx SparkED Team ... View more

Calling all data detectives and candy connoisseurs! Every year, trick-or-treaters collect a mixed bag of Halloween treasures, from skittles to peanut butter cups and even dental items and baseball cards. Join Alteryx SparkED for a spooktacular challenge as we analyze the ratings of these Halloween goodies. Discover the hidden gems, the 'meh' moments, and maybe even a few sweet surprises in the world of Halloween candy!     Happy Halloween Maveryx! Attached to this thread is a Halloween Candy Dataset from 2017, where participants rated a variety of candies and treats on a scale of 'Despair' - Dislike, 'Meh' - Average, 'Joy' - Like.   Clean & analyze the data to answer the questions below. Respond to the discussion with the answers, a screenshot of your workflow, and photo of YOUR favorite candy!   What type of candy or treat ranked the most well liked ('Joy') across participants? What is the least favorite ('Despair') candy or treat in the United States and how many participants gave it this rating? What are the top three candies or treats that had the most 'Meh' ratings? What candy bars are the most polarizing (meaning at least 30% of submitted reviews for the candy bar are 'Joy', and at least 30% are 'Despair')? Please feel free to include any other fun insights you found while analyzing the data!    Ng, D. (2020, October 30). So much candy data, seriously. SCQ. https://www.scq.ubc.ca/so-much-candy-data-seriously/ ... View more

    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    ... View more

  Hi SparkED Network! Did you miss the first session of our new training series, Mastering Alteryx Designer Tools? Check-out the recording below where Alteryx ACE, @Deanna Sanchez, kicks-off the series with an Intro to Alteryx Designer, demonstrating tools such as Browse, Select & Sort as she analyzes pizza sales data. The packaged workflow is attached to this thread.     Mastering Alteryx Designer Tools: A Foundational Training is a beginner-level training, designed for those 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 Register Here  Session 3: Alteryx Joins and Unions - Monday 11/13/23 3:30 - 5:00 PM MST Session 4: Data Manipulation and Transformation - Monday, 12/11/23 3:30 - 5:00 PM MST ... View more