Santalytics 2020
Chat, collaborate and share your ideas on how to get Santa's Workshop back up and running!
Hey everyone!
That is a solution developed by me and @carlosteixeira .
Goal:
Help beginner users to don't get confused by crosstab/transpose logic, using something similar to pivot table of excel.
Development:
Using python, we created a macro where user can select which fields he need as lines, columns and values, getting as output a new transformed table with the specifications provided. To run, take more time than usually takes with crosstab/transpose but don't be a problem to use.
UI:
Inside Macro:
Inside python code:
#################################
# List all non-standard packages to be imported by your
# script here (only missing packages will be installed)
from ayx import Package
Package.installPackages(['pandas','numpy'])
#################################
from ayx import Alteryx
import pandas as pd
import numpy as np
#################################
file = pd.DataFrame(Alteryx.read("#1"))
linhas = pd.DataFrame(Alteryx.read("#2"))
colunas = pd.DataFrame(Alteryx.read("#3"))
valores = pd.DataFrame(Alteryx.read("#4"))
linhas = linhas["Linhas"].tolist()
colunas = colunas["Colunas"].tolist()
valores = valores["Valores"].tolist()
#################################
table = pd.pivot_table(file, values=valores, index=linhas,
columns=colunas, aggfunc=np.sum)
table = pd.DataFrame(table.to_records())
#################################
Alteryx.write(table,1)
Results:
Hope that macro can help someone!
While not necessarily solving a North Pole business problem, this app solves a problem in my home that I could see happening at the North Pole: What Christmas movie are we going to watch?!? No more endless scrolling through Netflix, Hulu, Amazon Prime, etc. with this app! As a bonus it provides a cookie and beverage selection. Now for the introduction:
'Twas early Christmas morning and Santa has returned to the North Pole tired from the long night of delivering presents. Needing to unwind, Santa suggests to Mrs. Claus to Netflix and chill watch a movie. Mrs. Claus agrees and says she will even make one more batch of cookies and make them drinks, but only if Santa can give her exactly which movie to watch, which cookie to make, and what they should drink. Not wanting to upset his chances with Mrs. Claus he uses his Alteryx random selection app and quickly finds a movie using the decades he wants while filtering for the genres that Mrs. Claus enjoys. A festive end to another successful Christmas!
UI:
App:
In stereotypical fashion, Santa does not like to ask for directions and typically relies on his gut instincts. Mrs. Claus reached out to me this year to help create a solution that would help Santa overcome his stubbornness and rely on data to plan delivery route.
Goal: Build an app that can calculate many different routes so Santa can decide for himself which is the best route for him.
Benefits: Allows Santa to create different reports and ultimately make the decision for himself. With him in control of the choices, maybe he will make a data-driven decision for planning his route this year.
Datasource: Basic World Cities Database file from simplemaps.com
App Location: The Santa Route Picker app is currently live on the Alteryx public gallery as well as attached to this post.
User Interface:
Sample Outputs:
V2- 200 largest cities ordered by nearest city:
I'm looking forward to seeing what everyone else puts together.
Happy Holidays everyone and stay safe out there!
Description: Given a number of Nice kids, this will provide budget needed and the avg cost per kid to give the best rated items from Amazon. Best Rated is largest amount of ratings to highest rating. From Santa's list (Checks list twice) it will give the Nicest Kids the "best" items and the least nicest the lowest rated. Only using New stock items.
The app can grow with address data and can make route for Santa in future. Once the Mrs. Claus uses the app and we see what is needed for improvement it can be easily made to her needs. Maybe a budget limit could be made for next year with an iterative macro to make sure we still get the "Best" toys for the Nice kids.
We can now know how much is going to be spent based on Amazon's inventory and the amount of nice kids and if there is enough stock so all the kids will get a toy.
Happy Holiday's and Happy New Year!
We can all agree there's only one way Santa can do what he does in a single day: Time travel. Obviously, Santa's sleigh operates in a pocket dimension with adjustable time dilation. That said, Santa needs to know how much to adjust the Sleigh Pocket-Dimension Time (SPDT) to ensure he can get to every home by Christmas morning. Assuming his Data Analyst elves can provide him with the number of homes to visit, the average distance between homes and the average speed of his sleigh, this app will tell him the correct SPDT setting.
Extra note: The app assumes Santa only works 8 hours and day and observes weekends and holidays (work-life balance is crucial!). Using the default app values Santa will spend 76 years delivering presents in the pocket dimension each Christmas. Maybe we'll explore Santa's cloning tech in next year's Santalytics.
Fun fact: NORAD tracks Santa's location https://www.noradsanta.org/
Lesser known fact: Santa has been cloned, along with his reindeer*. Large countries get their own Santa whilst other clones service groups of smaller countries. (Have you ever seen a photo of a gathering of mall Santas? Take a closer look and see how many look identical.)
Another lesser known fact: Gifts for the kids are prepositioned in distribution centers around the planet and sometimes in multiple locations inside a county. Much like the Pony Express, a fully laden sled with a fresh set of Donner and Blitzen, etc., await a Santa to jump from an empty sled and continue the deliveries.
Use Case:
The Santa and Mrs. Santa (yes, they cloned her, too) assigned to the United States would like to run some models and see which number of distribution centers will function best for deliveries.
Solution:
An Alteryx app that allows the US Santa and Mrs. Claus to play around with K-Centroids Clustering and receive a PDF of the results.
Data is provided by the built-in 2010 Census data in the Demographic Analysis palette.
* Rudolf, unfortunately, was unable to be cloned. The genetic mutation that gave him a shiny nose created….complications. These…complications…will be the driving plot in season 13 of Stranger Things.
Thank you for this challenge. I hope everyone has a better 2021 than 2020.
Best,
David
edited later for typos and a grammar mistake
