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!

Alter.Nation

Community news, customer stories, and more!
LeahK
Alteryx Alumni (Retired)

Welcome to the latest edition of Alteryx Community Highlights, an ongoing series aimed at helping you make the most of your time in the community!

 

Each month we deliver a just the right size dose of the best community happenings so that you can keep a pulse on what’s hot, who’s in, and all of the latest trends.


In Case You Missed It

*Community news & announcements.

 

Alteryx Analytics Excellence Awards | Help us reach our $20k goal

 

20k goal-ACE.pngThere's plenty of time to submit your Alteryx Use Cases to qualify for the 2018 Alteryx Analytics Excellence Awards presented at Inspire in London. Not only will you give back to the Alteryx Community by sharing your knowledge & experience, you'll also contribute to giving back to communities in need:

 

  • Alteryx will donate $250 per use case that meets minimum qualifying criteria and $500 per use case that meets qualifying criteria and includes a workflow, up to a total $20,000 donation!
  • You can submit as many as you'd like to help us meet our goal!

Read the announcement for further details and instructions. Submission Deadline: August 17th

 

 

rti-race-london.gifRoad to Inspire Europe

 

We're on the road to inspire yet again, and this time we're heading to London! Submit your life altering analytics story for a chance to win a free pass to an upcoming Inspire conference and be featured in the  video series.

  

Visit roadtoinspire.alteryx.com to learn more.

 


Never. Stop. Learning.

*Alteryx Academy. All the training resources you need.

 

Alteryx_Inspire-1011-small.pngWeekly Challenge

 

Do you have what it takes to be a Grand Prix Champion? Try your hand at all three laps of the workflows used for the Grand Prix at Inspire in Anaheim!

 

 

Tackling this workflow won't compare to the experience our finalists had, but it will give you a glimpse into what it takes to compete in the Grand Prix. To make it more life-like, follow these suggestions!

1) Open up the workflow and give yourself 2 minutes to read the prompt - don't touch the mouse!
2) Time yourself - the drivers had a maximum of 12 minutes to finish.*
3) To take it to the next level, invite your friends, co-workers and neighbors over, provide them food and drinks, and put on some headphones as you solve the workflow right in front of them!

 

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.


ACADEMY-Inspire18 slide-500.pngUpcoming Live Training

 

August 7th | Chained Applications
Sometimes a workflow needs the results from another workflow before it can run. In this session, we'll see how easy it is to chain apps so that when one finishes, the next app in the chain starts!

August 14th | Parsing Dates and Times
Working with dates and times can be an issues in other applications. Learn about the tools in Alteryx to let you work easily with date and times. Learn how to quickly read in dates/times in a variety of formats. We'll also look at the many date/time formulas available to get the results you need.

 

August 21st | Alteryx for the SQL Analyst

You know how to write SQL, and have sound understanding of working with data, but how can you translate this knowledge to Alteryx? The intention of this session is to use SQL terminology and keywords to understand tools and processes in Alteryx.

 

August 28th | Tips & Tricks

You know how to write SQL, and have sound understanding of working with data, but how can you translate this knowledge to Alteryx? The intention of this session is to use SQL terminology and keywords to understand tools and processes in Alteryx.

 

If you missed a live session, or are curious to see what's available on-demand, check out the recently updated Live Training Index & Welcome.

 


<ayx-dev />DevCommunity-hex2.png

*Get the scoop on all things Code Free & Code FRIENDLY.

 

Python Spotlight

 

Tons of Python-related activity this past month including:

 

 

Python Contest Winner

 

Last, but certainly not least, congratulations to @Nick612Haylund for winning the Python tool contest! Nick built the Glassdoor Company Review Scraper to take home the custom mechanical keyboard grand prize.

 

The best part of this contest was collaborating on a pythonSDK project with others!nick-python.png

   A) bc there's no way I would have completed this in the coming weeks without the help...but also,
   B) finding dev community members that were so quick and willing to dig in and solve problems together!

 

  - Nick Hayden

Other great entries included tools for:

 

  • Sentiment analysis
  • Regex parsing
  • Sorting fields

And many more. Head over to the Python Challenge on Dev Space to check out and download these free tools!


 Nuts & Bolts

*Alteryx in Practice. Noteworthy Articles, Blog Posts + other pearls of wisdom.

 

Tool Mastery | Running TotalTool Mastery | Running TotalThis month we saw a wealth of new submissions for the Tool Mastery series, across a handful of tool categories. Major kudos to @Kenda for contributing to three of the four new Tool Mastery articles published in July!

 

 

It was also a great month for our Connector tools, adding two guides for usage of Google Big Query and Salesforce!

 

 

A priceless guide and reference for any R Tool user, @SydneyF dives deep this month with her latest article:

A Cheat Sheet of Functions to Use in the R Tool

 

And, don't forget to check out the guide she put together to help users master workflow credentials on the private gallery:

How Workflow Credentials Work on a Private Gallery

 

workflow creds.png


Read our Blogs

 

This month on Engine Works, Stephen shares his tool that sends text messages from within a workflow, Workflow Text Messages Using Twilio, and explains how he made the tool using a combination of a macro and the HTML SDK.

 

And Alteryx ACE Mark shares best practices for working with dates: MarqueeCrew's Guide to Avoiding Date Frustration.

Over on Data Science, the winners of the Alteryx BUILD hackathon describe how they took home the grand prize: Image Vectorization in Alteryx.

 

Don't miss Dr. Dan's investigation of the “World Cup Curse” - guess what? It's real: Alteryx Tackles the 2018 FIFA World Cup: Investigating the World Cup Curse  

 


Culture & Events

*Immerse yourself in data and analytics culture.

 

New episodes | Alter Everything Podcast

 

Three new episodes of the Alter Everything Podcast available for your listening pleasure!

 

In the most recent episode, 13: Innovation comes from frustration, we're joined by Pete Goldey (@PeterGoldey) for a chat about turning frustration into innovation.

 

In Episode 12: Simple is HardSteve Ahlgren (@SteveA) and Neil Ryan (@NeilR) join us for a deep dive on software engineering in the analytics industry.

 

Episode 11: When advocating becomes contagious, features Lauren Uyeno (@LaurenU), Tuvy Le (@TuvyL), and Maddie Johannsen (@MaddieJ) discussing Alteryx User Groups and the ACE program.

 

 

Visit the Alter Everything Podcast home on Community or subscribe on your app of choice: Apple Podcasts | Soundcloud & more!

 

 

TBT Philly AUG-small.jpgLearn Local. 

 

This month the Philadelphia Alteryx User Group met to discuss Inspire 2018 highlights, listened to one user's experiences conquering the Weekly Challenges, and tips & tricks.

 

The group had a blast sharing knowledge and meeting other users in person. There are still plenty of user group meetings scheduled through the rest of the quarter.

 

Check out the Alteryx User Group events calendar to discover a group near you.

 

 


Community Tips

*Tips to help you make the most of your time on the Community.

 

Marking replies as accepted solutions, is a great way to help your fellow community members find the answers they're looking for. 

 

Why is this important?

Accepted solutions helps our Community identify content that solves users’ problems and makes answers more prominent and easy to access.

 

What happens when users mark a reply as an accepted solution?

When a user marks a reply as an accepted solution:

  • A check mark icon appears next to the original post
  • The solution gets circled in bright green so that users scanning a list can easily locate it
  • A Go to Solution link is displayed in the original post to go directly to the solution
  • The post is elevated in search results

 

Accepting solutions thread-small.png

 

search for solutions-small.png

 

With Alteryx, more often than not, there is more than one way to get to a solution...

 

Did you know? 

Users who post the first message in a thread can mark one (or more!) of the replies as an accepted solution.


Thanks for tuning in to this month's edition of Community Highlights!  If you have ideas for what you'd like to see in an upcoming highlights, please comment below.

Leah Knowles
Senior Manager, Community Management & Programs

Leah is responsible for building and growing engagement programs that enable community members to make the most of the Alteryx product suite. She is passionate about building customer communities to collaborate and solve real world business problems, and believes that connecting with people and building relationships leads to better work. Follow her on twitter @LeahMKnowles

Leah is responsible for building and growing engagement programs that enable community members to make the most of the Alteryx product suite. She is passionate about building customer communities to collaborate and solve real world business problems, and believes that connecting with people and building relationships leads to better work. Follow her on twitter @LeahMKnowles

Comments
Nick612Haylund
10 - Fireball
10 - Fireball

 Woohoo! Thanks for the fun contest @NeilR + team!

 

One last shout out to @tlarsen7572, who was KEY to the success of the tool. Hope everyone enjoys it in its most final form! https://github.com/Alteryx-Python/AlteryxTools/tree/master/GlassdoorScrape

 

Can't wait to see what more the community comes up with using the PythonSDK :)