#SANTALYTICS Part 1

[TaraM]

#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

 

• Part 1: November 30, 2016: #SANTALYTICS Part 1: Solution and Behind the Data
• Part 2: December 7, 2016: #SANTALYTICS Part 2: Solution and Behind the Data
• Part 3: December 14, 2016: #SANTALYTICS Part 3: Solution and Behind the Data
• Part 4: December 21, 2016:  #SANTALYTICS Part 4: Solution and Series Finale

[JordanB]

My Naughty and Nice List :)

Best,

Jordan 

[lminors]

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

Spoiler

[TaraM]

@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 

[JonA]

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

[TaraM]

credit goes to @MattD on the data 

[MarqueeCrew]

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).   

[tom_montpool]

Here's mine...workflow and results.

[jdunkerley79]

Belated attempt ...

Spoiler

 

[AlexKo]

Don't mind me, just collecting badges.. 

[JonA]

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