alteryx Community

# #SANTALYTICS 2016

Help an elf get Santa around the globe!

## #SANTALYTICS Part 1

Alteryx Alumni (Retired)

#SANTALYTICS Part 1:

With an impossible task looming, poor old Santa is clueless at best. There are 15,000 kids in this route (Recipient Database.xlsx, Address Database.xlsx) and he'll have to somehow stitch together all the data he's gotten from his elves - a dozen log files of what the kids have been up to this year (* Action Log.xlsx). Summarizing these and finding a rating for each kid should help! You can do so by subtracting just how naughty they were from how nice they were throughout the year.

Santa has been doing this for centuries and has used trial and error to build out his naughty and nice ratings for grouping the kids (Naughty or Nice Ratings.xlsx). Using an approximate even distribution while assigning to each of the 25 groups, can you use Alteryx to determine which kids fall into each category this year?

We only have so many days until the Holidays and presents also need to be assigned too! We already know the naughty kids will get coal, but what about the other 20 groupings of kids? The elves do good work, but presents aren't free - we should probably use the price of each gift to make sure the best kids are getting the best classes of gifts! You can use the price of the gifts to also sort these into 20 evenly distributed groups. Let's hold off until Santa knows his exact routes to pick the gifts specifically - the Reindeer can only hold so much!

Goal of Part 1:
We want a list of recipients ranked with

1. their Naughty or Nice rating and Score
2. the class of present they are entitled to.

We will award badges and recognize community members that submitted solutions in our November 30 blog post on Engine works: #SANTALYTICS Part 1: Solution and Behind the Data

Tara McCoy
30 REPLIES 30
Alteryx

My Naughty and Nice List :)

Best,

Jordan

9 - Comet

That was good fun! Look forward to next week. Solution attached.

Spoiler

Alteryx Alumni (Retired)

@Treyson - I love that you had your team involved! Be sure to send me their usernames so they can be awarded badges. Ho ho ho

Tara McCoy
Alteryx

@TaraM - bonus stars to the clever Action field in the Action Log files. My personal favorite: "Prounouced it jif instead of gif"

Alteryx Alumni (Retired)

credit goes to @MattD on the data

Tara McCoy
20 - Arcturus

Ho Ho HO!  If I got a present from the big guy, I think that George Stanley might deserve another chance.  Remember, "There's room for everyone on Santa's Nice list."

2015 Santa Pic (Yes, that's me in both pictures).

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
12 - Quasar

Here's mine...workflow and results.

ACE Emeritus

Belated attempt ...

Spoiler

Alteryx Alumni (Retired)

Don't mind me, just collecting badges..

Alex Koszycki
Program Manager, Community Platform
Alteryx

I expect better from you @EvelynSpencer....the 5th naughtiest child, how could you?

Labels