ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alter.Nation

Community news, customer stories, and more!
WillM
Community Manager
Community Manager

I want to start out by saying how thrilled I am with the participation that we got in Santalytics for 2020! We had some amazing entries from all around the community; people worked individually, in teams, and we had some fantastic user group submissions as well. I'd like to give a big "Thank you" to @DanM and @CristonS who helped judge the entries (and believe me this was not an easy task). We'll be announcing the winners in this blog, but before we do that, I'd like to run through some of our entries to give some shout outs to those that participated.

 

We had several entries that were great examples of the classic "Santa Route Optimizer" or some variation of that. Santa will no longer need help figuring out his timing or his most efficient route to deliver presents with all the help from the Alteryx Community!

 

 

  • @Aaron_Harter's ETA to North Pole app included a mathematical proof and was very well structured
  • @jtwmoore created an app that explains the Sleigh Pocket-Dimension Time.  It isn't necessarily a route optimizer, but gives the Murphy's Law explanation for how he can move so fast and maybe not need to optimize his route so much
  • @David-Carnes didn't create a route optimizer per se, but his usage of prepositioning and the K-Centroids tool (which we LOVE) was a fantastic look at how to be effective at delivery in other ways
  • @AkimasaKajitani created an optimized route app that was definitely a best practice example of the classic route optimizer
  • @NeilR showed us an app based around equidistant locations, which could be an incredibly versatile tool in a lot of scenarios
  • @phottovy gave Santa some options by providing multiple routes so he can decide which suits him best at any given moment.  It's also some of the most festive reporting that we saw!

There were also a few entries we received around media consumption and partnering with Amazon around the holidays.  Whether it's which music to listen to, which movie to watch, or what type of gift to order the Alteryx Community has your back!

 

 

  • @cplewis90 showed a great way for Santa to distribute toys based on their rating from Amazon as well as the "niceness" score from tweets
  • @T_Willins used some great tools to help Santa decide on which movie to watch with Mrs. Claus after a long night delivering presents.  Getting to narrow results by genre and decade is definitely a step up from endlessly scrolling through Netflix!
  • @KevinHarrison paired the naughty and nice list with Amazon reviews to decide who's getting what this year.  Even though Bezos has enough money as it is, at least everyone's getting a toy!
  • @ADerbak@DerangedVisions@EricMartinson, @RMohr88@brandon7932, and @Mike_Fitz worked together in the NA Central User Group meeting to put together an app the helps narrow the workshop's production list based on item-performance data.

And we even had a few entries that can't be readily grouped into larger categories; they certainly still deserve some major kudos for all of the work that went into them!

 

 

  • @grossal put together an incredibly useful tool for Santa to help with Alteryx version updating.  This is a really cool idea, and something you might want to look into for your own day to day!
  • @marcusmontenegro and @carlosteixeira2005 worked together on a macro that should be on everyone's list if they're struggling to learn crosstab and transpose logic.  It's format is similar to a pivot table and it's super helpful to take it in!
  • @mbogusz worked on an app to help Santa double his principle and purchasing power by... not buying any presents for the year and investing the capital instead.  I love the willingness to go there and not fear the disappointment of children the world over.  Santa believes in delayed satisfaction...delayed exponential satisfaction.
  • @Dynamomo and @Amarendra   worked together to create an app that would format a letter to Santa based on input data.  This could be something really fun to do with your own kids next year, so bookmark it for the future!  This also happened to be Rafi's absolute favorite (check out his letter below)

Letter.png

 

And now it's time to announce our winners!  With all of your submissions, this was not an easy task and there was definitely lots of back and forth.  No one was on the Naughty List, that's for sure.  But a few entries rose to the top of the Nice List!

 

 

Our community members put in some truly great work to achieve very different outcomes.  I'd like to congratulate both @atcodedog05 and @Spalders for their entries, and for being selected as our runners up!  Let's take a look at what they put together for the challenge.

 

  • @atcodedog05 created an Alteryx themed holiday card maker using the Santalytics 2017 periodic table of Alteryx tools. The app creates a randomized grid ot tool icons as a background pattern for the recipient and allows the user to enter the receiver's name on the card.  This is such a fun way to bring Alteryx into the holidays; check out the card below!

    card.png

  • @Spalders took another route entirely and created a Christmas Track Selector using the Spotify API.  This app provides a lot of user control by allowing the selection of Key, Danceability, "Acousticness", Energy, "Instrumentalness", Liveness, and Tempo.  There are a lot of track selectors out there, but few have this much control, and the PDF output with the album art really sets it apart!

    tracks.png

 

And finally, it's time to announce that the winner of the 2020 Santalytics App Challenge is a team from the NA Central User Group! CONGRATULATIONS to @Deanna and the NA Central User Group members on the team who helped with the app build: Aimee, Austin, Dave, Emily, Eric, Jen, Jujlija, @JustinBabbitt, Kaush, Kelly, Kris, L. Scott, @lc_p, Pam, @DALAM20, Rachel, Raghav, Rajat, Renu, Scott, Sujana, @tareque, @mkcompton, and others!  This group took one of our sample datasets and created an app that allows a user to find the "Worst Christmas Songs" (or the best ones) based on their preferred criteria.

 

Again, a huge thank you and congratulations to everyone that participated in the challenge this year.  It was a change in form from our regularly scheduled programming, and you all really stepped up to meet the challenge in what was a particularly challenging year. Your creativity and dedication shone through and each and every person that participated put forth some incredible work. And for everyone that participate, you've got a shiny new badge on your community profile as well - here's to all of you!

Will Machin
Community Manager

Will runs community engagement programs for the Alteryx Community and wants to ensure that all members get the resources, activity, and information they need. He is always open to hear feedback and ideas and loves connecting with everyone in the community to strengthen relationships and build strong ties.

Will runs community engagement programs for the Alteryx Community and wants to ensure that all members get the resources, activity, and information they need. He is always open to hear feedback and ideas and loves connecting with everyone in the community to strengthen relationships and build strong ties.

Comments
Spalders
8 - Asteroid

Thanks, @WillM for running Sanatlytics 2020, it was fun and great to see the diversity of solutions. Congratulations to @Deanna and the NA Central User Group!

tareque
5 - Atom

This was a great event!

Running through the exercise building an app with creative and great Alteryx users really gets the creative juices flowing.

 

I appreciate all the contributors, organizers, and leads that made this event happen during, before, and after COVID!

 

Thank you!!

Deanna
11 - Bolide
11 - Bolide

Wow!!!  Thank you, @WillM and the Alteryx team for this wonderful honor!!!  Thank you to the North America Central Alteryx User Group team members who inspired and helped build our "Worst (or Best) Christmas Songs" analytic app; it was certainly a team effort, and was an amazingly fun and energetic collaborative build - all ad hoc from a Zoom breakout room and a blank Alteryx canvas!  Thanks also to our breakout room host and fellow user group leader, Jonathan Shertok @shertokj for facilitating the process and for the nice logo for our app!  It was awesome to work together with each of you, and to build such a useful app in just 20-30 minutes; congrats to our team:  Aimee, Austin, Dave, Emily, Eric, Jen, Jujlija, Junwei, @JustinBabbitt , Kaush, Kelly, Kris, L. Scott, @lc_p , Pam, @DALAM20 , Rachel, Raghav, Rajat, Renu, Scott, @SherylP , Sujana, @tareque , @mkcompton , and others!

 

Special thanks to Lauren Uyeno, our talented NA Central User Group manager at Alteryx, for hosting all of our meetings and setting up the breakout rooms for the teams!

 

It is a privilege to be awarded the winner, especially seeing ALL of the other outstanding app submissions for the Santalytics 2020 Challenge - each one was a top-level app in its own right!  As a GIS (Geographical Information Systems) professional, I was particularly impressed with all of the route optimization and spatial analytics submissions.  🙂  Many of these I will need to explore further and be genuinely inspired by the depth of spatial knowledge within!

 

Excellent work to all who submitted an app for the 2020 contest; just like the Weekly Challenges, I believe these Santalytics apps can also be a wealth of learning opportunities and knowledge sharing!  Maybe we can have a "Christmas in July" contest mid-year as well?

 

Thank you again with heartfelt gratitude; Happy New Year, and let's collaborate on more Alteryx solutions that can change the world for the better!

 

@Deanna 

 

atcodedog05
17 - Castor

Thank you so much Alteryx Community Team and @WillM for this year's Santalytics. It was a blast 😁

 

Excited to be one of runner-ups. And this Santalytics also gave me an opportunity to create this Alteryx flavored Holiday card (was great way to showcase my passion and at the same time share holiday wishes) and send to my friends and connections. Which was soo much fun 🙂

 

Congratulations to @Deanna and the NA Central User Group on the winning, by collaborating and building an awesome project with amazing team efforts 😊

 

So many people collaborating, working together and making it happen is a feat by itself. Definitely something to learn from and looking forward too 🙂

 

Thank you again for this event 🙂

 

Cheers and Happy Analyzing 😀

Amarendra
10 - Fireball

Wohoo! Congrats everyone!  @WillM and team, thank you so much, this was a lot of fun!!