Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #99: SANTALYTICS 2017 - Part 3

estherb47
15 - Aurora
15 - Aurora

@LordNeilLord, you are brilliant!!! I am floored by your creativity, and honored by having my own little dashboard :)

Thank you!!

 

Laurap1228
11 - Bolide

Here is My Periodic Table of alteryx Tools where Tool-Rank popularity is determined by the tools I used most frequently in 2017.2017-12-28_03-48-59.jpg

NicoleJohnson
ACE Emeritus
ACE Emeritus

Not the most innovative solution I've ever submitted since I more-or-less borrowed ideas from others for most of it and then re-used parts & pieces from my challenge 97 & 98 workflows... but I at least have a slightly different end product than the (TOTALLY AWESOME AMAZING AWE-INSPIRING) solutions that have already been provided! I borrowed general concepts from @LordNeilLord and @Laurap1228, then took a detour to reach my final destination.

 

Spoiler
In the spirit of making New Years Resolutions (and hopefully keeping this one!), I chose to display not the tools that I had used during the year, but instead the tools that I hadn't used in my Weekly Challenge submissions - so my resolution is to try to find creative ways to use some of these in 2018! 

I have copies of my weekly challenge submissions saved on my computer in one folder, so I just pointed to that folder to get the code for each workflow... and then I created a mapping table that converted the tool name used in the yxdb from Challenge 98 to the tool name that is actually used in the code for each workflow (a manual step... not pretty, or ideal, but being as this was my first foray into interpreting XML code in an Alteryx workflow... it was good enough for now! And gives me something else to work on in 2018 haha.)

WeeklyChallenge99.JPGWeeklyChallenge99PeriodicTable.JPG

* NOTE: I know that this is not 100% accurate, since I find it incredibly hard to believe that I haven't included Input, Output, Count Records, Select Records, or Data Cleansing in one of my 98 Weekly Challenge submissions to date... :) But the rest of the tools included in this "Haven't Used Yet" List appear to be reasonable, so I'll dig into this a little further to see if I can figure out where those few exceptions might be hiding in the XML code that I missed in the first go around.

... And as a bit of a personal note on this last submission for 2017...  I'd just like to add that it's awfully fun finishing up the year with my 99th challenge, considering I only completed my first one in March!! Truly incredible how much you can learn and grow in 9 short months, just by being involved in this incredible Community. I am so excited about the connections I've made with others, both virtually and in person... and I can't even begin to describe how thankful I am for the amazing career opportunity I was given this year that is 100% due to the skills I've learned from this Community and the connections I made at Inspire. It's hard to imagine how 2018 will be able to top this year... but hanging around with all of you, I just know it's going to be even better!

 

Thank you thank you THANK YOU to all of you for helping me grow - I love sharing this wild world of Alteryx with you!

 

Cheers & Happy New Year,

NJ

PhilipMannering
16 - Nebula
16 - Nebula

Here's my periodic table in Tableau Public

 

challenge_99 - Output Snip.PNG

 

SeanAdams
17 - Castor
17 - Castor

Super Awesome Neil - and useful too 

@LordNeilLord)

SeanAdams
17 - Castor
17 - Castor

So - there's loads that was interesting and insightful here - some highlights for me:

 

 

Spoiler

- I was so tempted to steal @patrick_digan 's mapping between tool and help-text.   Not sure if you did this the hard way Patrick, or if you found this config buried in a file somewhere?   Either way - nice!
@TaraM then did a custom style-sheet; and linked this up to the tool mastery - great idea (especially since this was not hard-coded but a dynamic pull so it will self-update)
- Super impressed with @LordNeilLord 's idea of scraping everyone's weekly submissions.   This ties back to a discussion we had at Inspire - nice play my friend!
- The idea of a personal tool inventory for learning - @Laurap1228 and @NicoleJohnson . This is also a super useful idea.
- Few of us went for Tableau viz - @ggruccio ; @PhilipMannering ; @SophiaF (who did this in challenge 98 already)
- And some Analytical Apps to filter - @Ilías 

My approach:

Spoiler

Learned from @SophiaF 's post in challenge 98 how to create the custom shapes in Tableau.
Then went about seeing what signal we can find in the data about the usage patterns.   Built a tableau dash that allows you to filter the tools by category in 2 ways - one is in the Periodic table view; and the other is in a modified frequency plot.

Unfiltered - you can see the entire tableUnfiltered - you can see the entire tableTaking out some of the categories, you can begin to see the patternTaking out some of the categories, you can begin to see the patternThis view shows the pattern most clearlyThis view shows the pattern most clearly
You can see from the last image, that some tool categories are significantly over-represented in the upper rows of the table (higher ranks of usage).   This may be an indicator that there's a bigger barrier to learning for some of the other tools.    

Also - looking at the usage, you can clearly see evidence of what was discussed at inspire - that people first use Alteryx for data prep, and then often move up the stack.

Finally - Poppy (our cat) just wanted to mention that she was exhausted after all the Alteryx-ing that she's done this year.   It's been a very busy year for Poppy - what with her first birthday; first celebrity photo appearance at Inspire EU; all the help she gave with the new computer build; and now all these weekly challenges and posing for the picture requested by @TaraM and @LeahK with the bandana!    Phew - time to get a quick snooze in!

 

20180101_085208_v2.jpg20180101_085227_v2.jpg20180101_090450_v2.jpg

 

 

 

Here's wishing everyone a little well-earned rest over the new-year (with Poppy leading the way in the resting piece)!

 

20170401_162916_v2.jpg

 

 

samN
10 - Fireball

 

Spoiler

Created my own tableau shape library and then loaded the slightly manipulated data into a tableau dashboard with a few filters.

 Full Picture.JPGFiltered.JPGMultiThread.JPG

Ready for the big 100 this upcoming week

 Also it doesnt seem to like me uploading the tableau dashboard as a result/sorry

jasperlch
12 - Quasar
 
estherb47
15 - Aurora
15 - Aurora

struggling here, and have been for several days now, to get my overlays to render to Tableau for the output. Can anybody help?

The overlay graphic looks great in a browse, but it goes completely wonky when I try to render it to a png. Thank you!


 

LordNeilLord
15 - Aurora

@estherb47

 

I can get the pics to output ok but I can't get that white background to work