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!

Engine Works

Under the hood of Alteryx: tips, tricks and how-tos.
Emil_Kos
17 - Castor
17 - Castor

The goal of this article is to help professionals understand and start implementing Alteryx in their organization or team. Alteryx is a fantastic tool which allows its users to solve business problems in an elegant and scalable way. It can bring value to the organization in weeks rather than months. At the same time, it may be challenging to implement Alteryx, especially for teams that aren’t very tech-savvy. 

 

Here is a collection of tips for implementing Alteryx in your team. First off, let’s start with how to guide your team through the process.

 

How to Set Your Team Up for Alteryx Implementation

 

  • Find Advocates. One of the first things you need to do is to find individuals who will be the Alteryx specialists in your team. Ideally, they already have some technical knowledge that can help them master Alteryx Designer. For many people, learning Alteryx can open the doors for future career opportunities, so this should be a way for you to reward your most valuable employees. Once you identify them, proceed to the second step on this list. 

 

Emil_Kos_6-1617729383977.jpeg

 

  • Free up their time.  If you picked correctly, your Alteryx advocates are among the most reliable people in the organization. And you’re probably not the only one who thinks that!  Because a lot of people rely on them for many things, the advocates are constantly busy. 

If you want to take your team to the next level by implementing Alteryx, you need to free up the time of the 'ambassadors.' The concrete solution to this task this depends on your team’s circumstances. What you can try is dividing at least some of the ambassadors’ responsibilities between other team members. Even if it means spending some extra money, remember that this investment will pay itself off soon!

 

  • Give advocates a proper training: This may sound obvious, but it’s important to outline it. You don't need to hire external trainers to teach Alteryx to your team. To start with, you can task them with completing the Getting Started Learning Path in the Alteryx Academy. All the learning paths are well structured and provide a solid foundation for using Designer. Just keep in mind that people need to have enough time to learn. 

 

Emil_Kos_7-1617729383980.jpeg

 

  • Introduce them to the Alteryx Community. Beginners may spend hours finding answers to problems that more advanced users can solve in minutes. There are plenty of experts in the Alteryx Community who dedicate their time to helping others solve problems using Designer. It’s far more efficient to spend a few minutes asking a question and get an answer, instead of wasting hours trying to solve the problem alone. Show them the community and encourage everyone to use it often. Don’t forget to emphasize that they need to mask confidential data when asking questions!

  • Identify the low hanging fruits and grab them. If you want to bring change into the organization, you need to get early supporters on board. By supporters I mean senior stakeholders that have real power in the organization. The easiest way to reach them is showing the power of Alteryx in practice. Identify where you can implement a solution quickly and focus on creating a workflow to showcase the advantages of Alteryx. If you promptly deploy a working solution, you will get supporters across the organization and  empower your advocates at the same time. Remember: implementing a new business intelligence solution is complicated and expensive. That’s why positive PR along the way is vital.

 

Emil_Kos_8-1617729383983.jpeg

 

  • Establish rules that your team agrees to follow. If you want to know more about the standardization of workflows please check this article by @Michal. Standardization of your team’s processes has many benefits. The most obvious ones are a higher quality of work and time saving. Standardization should be critical as you start implementing Alteryx, but you need to keep in mind that it can be a demanding process. My advice is to start a conversation about the standardization with your team early on. Thanks to that, you’ll save a lot of time and avoid stress later. 

Best Practices For Using Alteryx Efficiently

 

Once you create agreement with your team around how to implement Alteryx, they’ll be on their way! Here are my best practices on how to use the designer, especially in the early days.

 

  • Project plan. If you require your developers to follow a project plan, pick one template for a project plan and conduct training to show how your specialists should use it. This will maximize the chances that your developers  use it as intended. 

 

Emil_Kos_9-1617729384015.jpeg

 

 

  • Four eye checks: If you think your developers should validate each other’s workflows, create a standardized process for it. This will ensure that everyone is performing similar checks. That’s especially important if the processes that your team is overseeing are crucial for the organization’s success. In case of a mistake, you’ll have evidence that you’ve done everything you could to mitigate the risk.

  • Uniform folder structure: This can be much more complicated - and also, more important - than it seems. If you have a few people with licenses and everyone has a different folder structure, it will be tedious to run/edit workflows when someone is out of the office. The lack of uniform folder structure brings risk to an organization that can be easily mitigated by addressing it before this becomes a problem. To do so, highlight this to your team and schedule a brainstorming session. I am sure that you will agree about a folder structure that the whole team will follow.

  • Remember about documentation. Proper documentation allows you to operate smoothly in case of an emergency. This doesn't mean you need to create additional files to document your workflow. Alteryx's documenting functions work pretty well but sometimes, it needs users' help. That is why you should use Annotations on tools/ Comment boxes and Containers to make it crystal clear for everyone how the workflow is working. 

 

Emil_Kos_10-1617729383982.jpeg

 

  • Use comments in the Alteryx workflows. This is especially important if there are regular expressions (an advanced data parsing topic - in short, it is a sequence of characters that specifies a pattern) that might be foreign to other users. Explain briefly what happens in each step of the workflow and why. This will make it more straightforward to maintain the workflow and allow users to implement changes quickly. Comments can also be used as brief procedures that explain the most complicated parts of the workflows.

BONUS: Ideas to Help Alteryx Stay in Your Organization for Good

 

The last point I wanted to mention is the best practices for your organization’s culture. This can help you solidify Alteryx as a go-to tool in your team and organization.

 

  • Find an Alteryx expert (ideally, from the same industry) and invite them to speak to your team.
  • Gather materials/videos related to best practices in one place. Make sure they’re easily accessible for everyone. You can also periodically send out emails with useful articles to help your team be more efficient. 
  • Ask if one of your advocates would be interested in leading an ongoing initiative focused solely on implementing best practices. This can empower your advocates and allow them to bring positive change into the organization. 
  • Encourage your advocates to visit User Groups. User groups are a perfect place to share ideas, experiences and best practices. As a bonus, your advocates can also get inspired as they might overhear a use case that will allow them to do something extraordinary with Alteryx. 

Summarize - Two Important Takeaways


The Alteryx implementation process can be challenging, so it is essential to prepare for it properly. One key takeaway from my side would be focusing on the advocates. If your ambassadors see the tool's benefits, they will go the extra mile to learn it and use it to bring value to the organization. 

 

The second important takeaway is best practices. If you can adopt them at the beginning of the implementation stage, the whole implementation process will be more efficient. 

 

And remember:

 

Emil_Kos_11-1617729384011.jpeg

 

Feel free to share your comments below. I’ll be very grateful for all ideas and suggestions that will allow the readers to achieve their goals related to the implementation process. 

 

Thank you for reading, and happy analyzing! 

Comments
NicoleJohnson
ACE Emeritus
ACE Emeritus

This is an incredibly well put together guide, @Emil_Kos!! I 100% agree with so many of your points - particularly around finding advocates and setting up best practices for documentation early on in the journey. I love how this article is so concise and scalable, regardless of the size of your potential implementation... also, my favorite might be the "Four Eye Checks", which I've not heard that term before but I love it and am probably stealing it. 🙂

 

Well done, Emil, you are a rising star in the Community - thank you for your contributions!!

 

Cheers!

NJ

SylviaP
Moderator
Moderator

I loved your article @Emil_Kos ! Very well said! 🙂

Emil_Kos
17 - Castor
17 - Castor

Hi @NicoleJohnson @SylviaP 

 

I am blushing now 😀  The truth is I spend a decent amount of time first on doing research (some Alteryx specialists helped me along the way) and then writing everything on paper.

 

I wanted to say a big thank you to everyone that responded to my LinkedIn post: @joshuaburkhow@DawnDuong @jacob_kahn @andrewdatakim @SubratDas5 and other people that I wasn't able to find in the community like Mark Thompson, Matthew Braun, Brian Coghlan and Tyler Steketee. Big thank you for your help! Your feedback was very useful. 


After I wrote the article, I have asked a couple of people for feedback, plus I received a helping hand with polishing the writing. After reading your feedback, I think it was worth it 🙂

@NicoleJohnson We have done the four eye checks in my previous role, and it was an excellent idea. We constantly challenged ourselves, and thanks to that, we could deliver solutions that we're solving some actual business problems.

 

One question to you @NicoleJohnson, If you don't mind I will use your feedback to promote my article on LinkedIn. I would be very happy if other people would be able to read it😀

NicoleJohnson
ACE Emeritus
ACE Emeritus

@Emil_Kos Absolutely! I'll promote it on LinkedIn too once I see your post there! TELL ALL THE PEOPLE!! 🙂 

Emil_Kos
17 - Castor
17 - Castor

Thank you for that! @NicoleJohnson 

rag-ryx
9 - Comet

Very well written @Emil_Kos . Love your passion.

 

--

Best,

Raghav

willhaye
8 - Asteroid

Thanks so much for the overview!  I had also tried to create a template for creating a common set of standards for your group based on community input. Link is here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-Standards-Document-Feedback-Re...  It is based only on community feedback so it is free to use as a starter doc.

SubratDas5
10 - Fireball

This is indeed a very good article. If i could, i would give it more than 1 likes.. 

 

Thanks for taking time to pen this down. 

Emil_Kos
17 - Castor
17 - Castor

Hi @willhaye,


I will definitely take a deeper look into it 🙂 Thank you for sharing!

 

@SubratDas5 @rag-ryx Thank you very much for the feedback! I am glad that you like it!

Buzz
8 - Asteroid

Hi @Emil_Kos ,

 

thank you for this post. We went through this process as well and noticed a well organized folder structure is worth the time. So 100% agree. 😁

You can then create workflows which read out the structure and the conten of the workflows inside the folders to create an automated overview. If they have then the same template with special boxes for comments etc. You do not need anything additionally.

 

Buzz_0-1618554995858.png

 

 

Nice work 

Buzz

 

 

Emil_Kos
17 - Castor
17 - Castor

Hi @Buzz,

 

Well said. I think a well-organized folder structure definitely helps a lot. Especially if we are working in a team with a couple of Alteryx professionals.

 

Making all of them work in some way of unity fashion brings a lot of benefits!

Buzz
8 - Asteroid

HI @Emil_Kos 

 

True. Also we have implemented an Alteryx Template which everybody is kindly asked to use. Are you using something like this as well?

 

Buzz

Emil_Kos
17 - Castor
17 - Castor

Hi @Buzz,

 

In my previous work I have established something like this in our small team:

 

Emil_Kos_0-1618563310376.png


We have created a super simple agreement along the way. I have written an article about it, and I have put most of the details in the PowerPoint presentation. Unfortunately, I cannot attach it to my post, but you can find it under my previous article. I think the presentation might be a good starting point around standardization.

 

https://community.alteryx.com/t5/Engine-Works/Starting-the-Conversation-Around-Workflow-and-Process/...

Alteryx_AR
12 - Quasar

Nice Article

Qiu
20 - Arcturus
20 - Arcturus

@Emil_Kos 
Excellent work.
I definitely have to borrow your work here for our new trainees on Alteryx.

Thanks a lot.

Emil_Kos
17 - Castor
17 - Castor

@Qiu I am very happy that you will do it 😀

Thableaus
17 - Castor
17 - Castor

Nice one @Emil_Kos 

 

Put that well together. Some companies need to have this before assigning licenses to end users.

Emil_Kos
17 - Castor
17 - Castor

Thank you @Thableaus.

I will make a deck from it in a future!

MarqueeCrew
20 - Arcturus
20 - Arcturus

@Emil_Kos ,

 

Find executive sponsorship!   Alteryx growth in the organization is going to take investment. Investment in people and in licenses.  With speed to value, Alteryx is generally self-funding. Not everyone will demonstrate equal value.  Some will reduce expenses and some will find new revenue.  All will become more productive. 

Publicize your use cases.  Quantify your wins and celebrate your successes. 

cheers,

 

 mark

Emil_Kos
17 - Castor
17 - Castor

Hi @MarqueeCrew,

 

Good point. 

 

Thank you for sharing this definitely should be included in this article 😀

bresejo
7 - Meteor

Super fun and simply stated, bravo!

Emil_Kos
17 - Castor
17 - Castor

Thank you @bresejo!