Free Trial

Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #20: Halloween Costumes

AYXAcademy
Alteryx
Alteryx

Hi Community,

 

Happy Halloween to those who celebrate! We posted the solution JSON file to Cloud Quest 19. 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!

 

  1. Download and extract the provided ZIP file containing your starting data and workflow files.
  2. Upload the provided Cloud Quest 20  Start.json file into your Analytics Cloud library.
  3. Reconnect the provided Quest_20_Amazon Costumes.csv dataset to your starting workflow 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:

 

In this week’s Cloud Quest, you have been given a small sample of reviews submitted for Halloween costumes purchased on Amazon during the years 2010–2020. Use the dataset to answer the following questions:

 

  1. In the United Kingdom, which month had the fewest costumes purchased (all years)?
  2. What were the top two most purchased costumes in each country (all years)?
  3. Create a table showing the percentage change in the number of sales year over year.

 

Bonus: One of the exciting capabilities of modern large language models (LLMs) is their ability to quickly parse complex text. While not necessary for this quest, try using an LLM to extract simplified costume names from the product name column such as "Top Gun Flight Suit," or "Train Engineer."

 

Your results will vary depending on the prompt and LLM vendor used. For this example, we copied a summarized list of product names into Claude 3.5 and used the following prompt:



 

“Attached is a list of Halloween costume descriptions from a dataset. Attempt to isolate JUST the name of the costume. Remove any information about size, gender, or brand. Brand names are typically uppercase. Keep any descriptive text relating to a costume’s material such as ‘leather’ and if it is a specific article of clothing such as ‘dress.’”

 

 

Spoiler

 A combination of the RegEx, Sort, DateTime, Summarize, Join, Filter, and Multi-Row Formula 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 Alteryx Academy for guidance:

 

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.

 

Data Source: https://www.kaggle.com/datasets/thomaskonstantin/popular-halloween-costumes-amazon-reviews/code

Here’s to a successful quest!

 

Academy Wordmark.png

 

13 REPLIES 13
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
JeffF
Alteryx
Alteryx

The "% YoY Change" values in the solution for Task 3 are all 100 higher than they should be. Or maybe I don't understand that metric.

 

Spoiler
Since I can't figure out a way to parse out the costume names and "Nintendo Super Mario Bros DISK73689L Classic Costume, (Small 4-6 years)" is somehow supposed to be "Mario", I'm calling my solution good.

One could argue that for Task 1, June and September had the fewest sales with 0 each.

CloudQuest20_JeffF.png 

 

Qiu
21 - Polaris
21 - Polaris

It is good and fun one.
I think the Costume name the 2nd answer is coming out from LLM, which dont have access now.
So I am using the long one in the input data instead.

Spoiler
Cloud Quest 20.png
ggruccio
ACE Emeritus
ACE Emeritus

I also used the long costume names.  Similar to @Qiu , I don't use a LLM.

 

Happy Halloween Everyone!

 

Spoiler
Screenshot 2024-10-31 151355.png
jpowellsd
Alteryx
Alteryx

Same as everyone else, I didn't use LLM so costume names differ.  FUn challenge though   Happy Halloween !1f47b.png

Spoiler
Clouse Quest #20.jpg
AkimasaKajitani
17 - Castor
17 - Castor

Happy Halloween !!!

 

Spoiler
image.png
Shelbey
Alteryx
Alteryx
Spoiler
Screenshot 2024-11-01 141603.png
alexnajm
18 - Pollux
18 - Pollux

Done!

Spoiler
Cloud Quest 20.png
RWvanLeeuwen
11 - Bolide
Spoiler
some day, the alteryx cloud will contain the AI features we need for this challengesome day, the alteryx cloud will contain the AI features we need for this challenge