Alter.Nation
Community news, customer stories, and more!
In Case You Missed It
*Community news & announcements.
Community Team Updates
@NeilR is kind of a big deal. In the three years that he’s been with Alteryx, he's played key roles in the Content Engineering and Product Management teams, creating interactive tutorial-style starter kits, leading a data challenge in academia, led the charge to deliver new tools and SDKs, delivered epic Tech Track talks at Inspire, and is a 2-time Innovation Days Champion.
His passion is building content and resources for advanced Alteryx users, and that’s exactly what the community needs next. We’re thrilled that Neil has joined us! His expertise and fresh perspective will help us deliver the next wave of engaging and insightful content.
Never. Stop. Learning.
*Alteryx Academy. All the training resources you need.
Weekly Challenge
Our Community reached a major milestone in early January: the 100th Weekly Challenge was posted to Alteryx Academy! When we were planning our 100th Challenge, we knew it had to be three things: challenging, badge-worthy and, most importantly, fun!
So, what was our approach to creating this Challenge? Asking @Ned for help, of course!
Challenge #100 asks challengers to find Ned's campsite, which is set up in the farthest location from any road in the state of Colorado.
Where is that exactly? Well, that's what you need to find out!
Head on over to Challenge 100 to check it out! And, while you're at it, give a shout out to our Community members who have successfully completed 100 Challenges: @NicoleJohnson, @ggruccio, @patrick_digan, @estherb47, @LordNeilLord, and @PhilipMannering!
Are there other Alteryx skills you’d like to put into practice? No problem. We’ve got you covered. You can browse all of the available challenges by difficulty and subject, right here.
Upcoming Live Training
We're gearing up for a month-long series of Live Trainings focused on Predictive Analytics!
January 30th | Data Investigation & Preparation
The Alteryx predictive tools include many interfaces to help you understand your data in a clean interactive format. This session covers the tools to assist you in understanding the story of your data and deciding what data to use in your workflow for analysis.
February 6th | Regression Modeling
Ready to dive into Advanced Analytics? Using a real-world application, this course will cover the objectives behind regression modeling, some of the important tools used in creating predictive models, and the interpretation of a model's results.
February 13th | Time Series Analysis
Have a rich history of data based on time? Learn to create time-based predictive models to project future values using your crystal ball: Alteryx!
February 27th | Cluster Analysis
Grouping often serves as a means to an end. However, the processes should not go unconsidered in your next predictive analysis. Join this training to find out why grouping is important and how it can improve your analysis.
If you missed a live session or would like to revisit a prior one, all recordings are available on the Alteryx Academy Live Training page.
Advanced Certification - Now Available!
Are you Core certified and wondering what's next on your drag-and-drop horizons? Register for the Advanced Certification Exam to prove your higher-level abilities!
Check out the Certification page on Alteryx Academy for more information on the structure of the exam, the topics covered on the test and the registration process. Remember, before you can register for the Advanced Exam, you need to first be Core certified!
Inspire 2018 | Training
We are excited to be offering two full dedicated days of platform training at Inspire this summer in Anaheim! This year’s training offerings will include expanded topics and a greater number of session rooms to accommodate everyone’s needs. There are full day courses (6 hours) and Elective Courses (2 hours). Mix and match to customize your perfect training experience. Make sure to sign up early within the registration process to secure your seat. Learn more here.
Not yet registered for Inspire 2018? Sign up before February 28th to take advantage of early bird discounts. Register Now.
Featured Solutions
*Accepted Solutions that caught our eye…
Solved: Using 'IN' within a Contains function?
In addition to solving the immediate need, Mark not only took the time to share a macro he thought others would find useful, he even created a series of tutorials on YouTube that dive into the details:
Contains in-List: (1) Solve the Problem
Contains in-List: (2) Macro Overview & Workflow
Contains in-List: (3) Macro Interface
A large part of our Knowledge Base publication process is driven by questions asked and solutions granted in our discussion forums. Our customer support engineers play a huge role in perusing both the community and support cases to ensure the content we create is aligned with the experience of our customers. Here are a few recent ones we think you’ll find helpful:
@lepome provides some helpful tips & best practices for handling BIG numbers in Alteryx.
@DurgaS provides a solution to bulk load data into snowflake using the snowflake internal stage.
*Alteryx in Practice. Noteworthy Articles, Blog Posts + other pearls of wisdom.
New KB Articles
Learn all about our new and improved licensing model.
Thanks to @JessicaS, we have two new additions to the Tips & Tricks series:
@PaulT shares his own take, and sense of humor, on how to get started creating iterative macros:
@SydneyF releases Part 3 of the pre-predictive series!
Read our Blogs
Learn how to build a succesful data catalog
What is a data catalog and how do organizations successfully build one? @DavidM shares some tips in his latest blog: 10 Tips to Build a Successful Data Catalog
Comparing Datasets
Comparing two datasets is a common challenge that comes in many forms -- either in understanding what fields are different across data sets; checking how field types are different (diagnosing issues with truncation or text field issues) or even in reconciling two data sets. There's no single tool to do this directly in Alteryx, but with some ingenuity you can do this yourself - Check out @SeanAdams blog to find out how: Compare 2 Datasets
Fantasy Football & Alteryx
Looking to gain a competitive edge over colleagues, friends, and family playing Fantasy Premier League? @NickC shows you how in his latest blog: Optimizing Fantasy Football (Soccer) Using Alteryx
Because It Feels Great To Do Good
*Alteryx For Good news.
The Journey to Solving Continues...
Solving problems is all the more thrilling when it benefits a worthy cause.
This past December Alteryx For Good sponsored four teams of motivated associates and ACE's to Help Uncover Data-Driven Solutions to the Opioid Epidemic.
Check out the post Code-a-Thon blog series to find out more:
- HHS Opioid Epidemic Code-a-Thon: Alteryx ACE Team
- Optimally Locating Opioid Treatment Facilities
- Exploring Hidden Relationships: Alteryx Team 1's Journey at the HHS Opioid Code-a-Thon
- Alteryx + Predictive Analytics + Caffeine = Opiate Prescriber App
Thank you @MarqueeCrew, @DrDan, @DavidW, and @BridgetT for sharing your experience with the community!
We hope you enjoyed the first Community Highlights blog of 2018! If you have ideas for what you'd like to see in upcoming highlights, please comment below.
