Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with...
The Alteryx education program providing software licenses, teaching tools, and learning pathways to empower learners to question, understand and solve...
Need to level-up your knowledge but don’t have time for a long read? Tune in to our podcasts to cover analytics culture, data science, and everything in...
Hi Maveryx,
We posted the solution JSON file to Cloud Quest #7. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!
Let’s dive into this week's quest!
Upload the provided Cloud Quest 8 - Start File.json file into your Analytics Cloud library.
The input and output datasets are included in the start file.
For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.
Scenario:
A group of friends are playing their favorite game. Not understanding the importance of inputting data in an easy-to-work-with format, they devised an incredibly inefficient way to keep score of their game!
In the game, there are five rounds of play and five players (a, b, c, d, and e—the first letter of their names). Each time the player’s initial appears in lowercase, the player is awarded 1 point. Each time their initial appears in uppercase, 1 point is subtracted from their overall score. Now it is your job to figure out each player’s score for each round and their respective totals after all five rounds of play. Who won?
Hints:
Tokenize the input data into rows.
There are many ways to calculate scores for each letter, but an If/Then statement can accomplish this in one expression.
When pivoting, you can perform multiple calculations at once including Sum and Total Column.
A combination of the Cross Tab, RegEx, Formula, and Dynamic Replace tools should solve your problem, but not necessarily in this sequence.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:
Getting Started with Designer Cloud
Building Connections in Designer Cloud
Building Your Workflow in Designer Cloud
Once you have completed your quest, go back to your Analytics Cloud library.
Download your workflow solution file.
Include your JSON file and a screenshot of your workflow as attachments to your comment.
Here’s to a successful quest!
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
In April, we celebrate Earth Month, a time dedicated to raising awareness and taking action for environmental conservation and sustainability.
This weekly challenge delves into temperatures, highlighting their crucial role in our planet's health. The dataset presents comprehensive information on global temperature records, covering various countries worldwide. It includes average temperature records in Celsius for major cities from 1743 to 2013.
To solve this challenge, we will be concentrating on the data from 1950 onwards.
Your tasks are as follows:
Determine which cities have average temperatures greater than or equal to 25 degrees.
Among the cities identified in the previous task, identify the country with the highest number of such cities.
Examining all countries within the dataset, pinpoint the year with the highest average temperature and the year with the lowest average temperature across the globe.
Need a refresher? Review these lessons in Academy to gear up:
Sorting Data
Separating Data into Columns and Rows
Summarizing Data
Source: https://www.kaggle.com/datasets/maso0dahmed/global-temperature-records-1850-2022
Good luck!
... 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
Aggregate Consumer Purchases:
For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger. The incoming data is larger than usual for these exercises so I have packaged the workflow as an Alteryx Package. The link to the solution for last challenge #7 is HERE.
This week’s Objective:
In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.
Summary of Data:
Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.
Hint:
Don't forget to join to the lookup table and filter by date.
As always we look forward to your feedback and suggestions!
UPDATE 01/18/2016:
The solution has been uploaded.
UPDATE 12/28/2016:
The challenge, text and solution have been updated.
... View more
A solution to last week's Challenge can be found here!
A big thanks to those of you that joined us last week at Inspire for the Weekly Challenge session! It was so much fun solving with you all!
This week, we're identifying the most popular baby names that were registered between the years of 1880 and 2017. Given the provided dataset, determine the most popular names for Males and Females for each available year. The column "Field_1" contains three concatenated values: the name, the associated gender (Male or Female) and the number of occurrences that the name appeared in birth records. The column "FileName" contains the name of the file in which the record is found; the data was read in from a zip file that contained text files for each year (1880-2017) of records.
... View more