Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data Coach Advanced Capstone

5 - Atom

Hi Everyone,


As a former Alteryx employee, I can't believe this is the first time I've ever posted to the Community. I have been blown away for years by the extraordinary people in the Community who actively engage every day and have been a mere consumer of all of the knowledge from the great things they post here. From the people who actively reach out and post questions on the Discussion forums to Alteryx ACE's like @MarqueeCrew, who once showed me that he set up alerts on his Apple Watch whenever someone posts anything to the Community so that he can jump on here and help out. Mark, you are every bit the Alteryx legend that we all know you are. To anyone reading this, YOU are the inspiration to us all to continue to use Alteryx and why we all love it and its community so much! Alteryx also has some of the best employees ever that exude passion every day, I wish I could mention you all here but that would take all day, so I want to say thank you to all of you!


Now I am working at Tessellation, one of Alteryx's Preferred Partners, as an Analyst, and I get to use Alteryx every day 😁.


tessellation_logo_2color_2021 (1).png




I also get to work with Alteryx ACE, Nick Haylund, @Nick612Haylund, and Alteryx experts like one of Tessellation's Founders, Alex Christensen. Also, Aidan Bramel @AidanBramel, Jacob Kahn @the_jake_tool , and my manager Michael Green. Go connect with Michael on LinkedIn , he posts amazing content about everything data-related and he's overall just an awesome person. Jacob Kahn, @the_jake_tool, is a prolific Community User and a 2020 Excellence Award winner who became a good friend of mine while he was at Grant Thornton and continually raises the bar on everything Alteryx. Jacob is also an amazing person and somehow gets more done in a day than most people do in a year. Everyone else at Tessellation is an expert in their respective fields and it is incredible to work alongside them and see the breathtaking business value that they bring to some of the largest corporations across the globe. 


Tessellation has one of the best training platforms on Alteryx, Tableau, Power BI, and Snowflake called Data Coach ,that I have access to now. After you complete a capstone project in Data Coach for your course, you are awarded an industry-recognized badge to post on your LinkedIn and other platforms.





I wanted to share a capstone project that I worked on recently for its Advanced Alteryx course. I got to choose the data set for this project, as it is with all of the capstone projects on Data Coach, and I wanted to make it fun. So, I downloaded a data set and I used the awesome Download Tool to connect to an NBA stats API. Two major requirements of the capstone were to create a custom Macro and build out an analytical app.


I even got to work on my photoshop skills and create the image for the Macro. I superimposed Kobe Bryant into the NBA logo and added the Tessellation logo on his jersey.






My idea was to create an app that let the user peek into the data to answer one of basketball's most asked questions, "Who is the better player, Michael Jordan, Kobe Bryant, or Lebron James?" The first part of the app attempts to answer this question to be based purely on statistics(even though I know that is not everything). *Spoiler*: Check out this article to find out who the best player is(this link is also included in my workflow and app). The second part of the app allows a user to look up stats on a single current player as far back as the 2014 season. 


Through some cleaning, even threw in some RegEx parsing in there, I was able to create the final analytical app(user interface and outputs shown below). If you want to learn more about Regular Expressions, there are some great articles already on the Community about how to use it, but leave a comment below if you want that to be the topic of my next article. 


Opening the Final Results (1).gifOpening the Final Results (2).gif

Opening the Final Results (3).gif






Output from first selection for Final Results.png

Output from second selection of app.png

Output from third selection of app.png











A Few Things I Learned


  • RegEx: learn it, live it, love it!
  • Configuring the interface tools and particularly the radio buttons that allows the user to click on separate sections of the app wasn't as intuitive as I thought it would be. Alas, Alteryx has some amazing documentation built into the platform and if you right-click most of tools, while in the toolbar, you can open up an example workflow on them. Opening up the example for the Action tool, I was able to deconstruct and recreate how to build out different sections within the app that open and close when the radio button is clicked on. 
  • Macros and Analytical Apps are very powerful tools that everyone should have in their tool belt if you plan on using Alteryx consistently. If you are interested in learning more about analytical apps, check out Jacob Kahn's webinar Become an Alteryx Wizard: Discover the Time-Saving Magic of Analytical Apps.
  • I built an analytical app that shows up in the configuration window of my macro, I didn't know that you can do that and it was really easy. 
  • A member of my team brought up that I should have created some kind of metric that shows comparisons between seasons based on who Michael Jordan, Kobe Bryant, and Lebron James had on their teams to see if that makes a difference any of the stats that each player put up during that season. There are a lot of other ways to conduct a statistical study on these players and it was fun learning a few of them and knowing that there is a lot more that can be done. 
  • I got to talk to another legendary Alteryx ACE, Ken Black, @Ken_Black, about this workflow and he let me know that he used to coach basketball in Chicago and has had the chance to meet a lot of famous Chicago sports players because of it. He also got to watch Michael play a few times at legendary Chicago Stadium, or better known as "The Madhouse on Madison." Ken, you are rad man, thank you for the awesome chat!
  • There is always something new to learn in Alteryx. Even though this was my Advanced Capstone, I know there is a lot more I can do with Alteryx and continue to improve upon and that's what makes Alteryx so much fun! Plus if you get bored, you can play acual games on it


I have attached an export of the workflow below, if you want to open it and take a look. Please feel free to post questions below and provide feedback, so I can continue to learn and grow. 


Also, add me on LinkedIn if you want to reach out directly: https://www.linkedin.com/in/jacob-miknuk/


Special Shoutout: Wanted to thank Matthew Braun @matthewbr, an Alteryx Solutions Engineer rockstar, for asking me to post this workflow/analytical app here and for reminding me to post it! Thank you, Matt!

17 - Castor
17 - Castor

Hi @TheDataDude,


It looks like your macro isn't here:




but it was very interesting. Thank you for sharing!

5 - Atom

Thanks for letting me know, Emil! I'll go back and make sure it's included as an asset in my export. 

5 - Atom

Hi @Emil_Kos, can't seem to edit the original post anymore, so let me know if the new attachment works. And again, thanks for letting me know!