Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available 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
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
The link to last week’s challenge is HERE.
Happy thanksgiving to the USA based challenge participants, hopefully you are hungry for another exercise. This week we will continue with some more data parsing and preparation with survey data. Enjoy!
Use Case: The 2 sources of data contain survey information. The Data input contains all of the survey responses. The Questions input contains the associated questions.
The column (called Column) in the Questions file corresponds to the field header value in the Data file, so value 38 in the Questions files is the questions associated with field F38 in the Data file.
The first row in the Data file contains the response type. In field F38, the data is formatted as Response (Scale 1-10) - Age Range.
Objective: Create an output file for a visualization tool (Tableau, Qlik, PowerBI) that details the response by age for each individual.
... View more
Happy Halloween loyal weekly exercise participants, here is an exercise I hope does not scare you too much. Hopefully is a treat and not a trick. The link to last week’s challenge is HERE.
Use case: An Alteryx subscriber needs to build a process to validate VIN numbers to test for data quality issues across the fleet data. The algorithm is provided at the below wiki link.
http://en.wikipedia.org/wiki/Vehicle_identification_number
Objective: Please take the VIN numbers from the Input and create a new column for the check digit. Compare the check digit with the calculated check digit value. If the two values do not match (and there was no error in the calculation), then there is a mistake in the VIN. Out of the six VINs, how many vehicles have invalid codes?
... View more
A solution to last week’s challenge can be found here.
This challenge was developed in collaboration with some Alteryx users, and we would like to thank @biosartorelli, @lemuelcastro, @Malvim, @nicolascorreiacolombo and @silvestremoreira for taking time out of their busy schedule to think of a great challenge for this special time of the year. Thank you!
Every year Santa Claus gets his sleigh and helpers (reindeers and elves) and goes around the world distributing presents to those who behaved well. Did you behave well this year? Is Santa going to leave your present under the Christmas tree?
This challenge will bring you the answer!
You goal is to figure out Santa’s route for the night of December 25th and what time he is going to pass through the city closest to you! He should take 24 hours to go around the globe (leaving North Pole at 00:00:00am) delivering the presents but be aware that the route is very well hidden, and you will be able to find it if you analyze your datasets carefully. When you find the route as well as the time, use your reporting skills to figure out the delicious recipe Santa left you.
As a bonus, would you be able to find out what time he will be at your city exactly?
Enjoy the season and this challenge!
... View more