Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #413: Ice Cream Road Trip – A Journey of Love

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hi Maveryx,

 

A solution to last week’s challenge can be found here. 

 

This week, we are diving into a sweet exploration in celebration of Valentine’s Day. With the help of Alteryx Designer, you will discover where to find the most ice cream shop locations across the United States of a beloved franchise.

 

Imagine this: your friends, who are huge fans of one chain of ice cream shops, are looking for their next big adventure. As their awesome friend (who happens to have great data analytics skills), you offered to help them pick their next destination for Valentine’s Day, focusing on both the density of these ice cream shops and the availability of their favorite flavor.

 

To solve this challenge, complete the following tasks: Icecream.jpg

 

  1. Determine which state they should venture to based on the state with the highest number of store locations relative to the population.
  2. Create a heat map visualizing the states with the most ice cream shops.
  3. Here's a twist: their favorite ice cream is a special flavor of this chain: Buttered Baguette. If your top state choice from Task 1 does not carry this flavor, which state should they visit next to get a scoop of Buttered Baguette?

 

Need a refresher? Review these lessons in Academy to gear up:

 

Have a happy Valentine’s Day!

Luke_C
17 - Castor
17 - Castor
Spoiler
 

image.png

alexnajm
17 - Castor
17 - Castor

Finished! Great challenge with Spatial as always :)

Spoiler
Challenge 413.png
mmontgomery
11 - Bolide
11 - Bolide

Been a minute since I've needed to do a thematic map - good practice!

Spoiler
c413.png
ed_hayter
12 - Quasar

An Ice cream roadtrip beats my current valentine's plans

 

Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W413.jpg
DataNath
17 - Castor
17 - Castor

My solution to #413.

 

Spoiler
413.png
JamesCharnley
13 - Pulsar
Spoiler
image.png

Ice Cream

balajilolla2
9 - Comet
Spoiler
Solution Attached

Workflow.jpg
MajorData
Alteryx
Alteryx

... accidentally posted under my work account.