5 Top Tips for anyone taking the Alteryx Expert Exam

As one of the lucky 13 people to have passed the expert exam in 2018, I have been asked for advice ahead of the 2019 Expert sittings in Nashville and London. There was another person pass at Inspire APAC in Sydney making the number Expert Certified 14.

Prior to working in analytics, I was a secondary school teacher, so I’m much more familiar with preparing others for exams than I am taking them myself. It’s not easy to know the best, most appropriate, and most efficient way to prepare and can sometimes feel quite intimidating. Despite a track record of having zero students listen to my advice before an exam, I thought I’d try my luck with a slightly more forgiving audience…the Alteryx Community.

Everyone learns and prepares for exams in different ways; this is how I prepared for the certification, but there’s many other (probably better) ways to prepare. I was really proud to hear I’d passed, but for me the most rewarding part was seeing the 12 other people listed as the other experts: not because I was pleased for them (I struggle with empathy), but because I’d met many of the other 12 through conferences/user groups, so am well aware how expert (and much better than me) they actually are.

What Is the Exam? 

For context, the Expert exam is the 3rd and final installment in the certification trilogy, so you’ll need to make sure you’ve passed the Core and Advanced exams first.

The first two exams follow a fairly similar structure: a series of multiple-choice questions which test your knowledge on pre-determined aspects of the platform, and in the case of the advanced exam only, require some need to go into Alteryx and solve some interesting problems about UFO sightings and Pilots (separate sightings and questions, or so Alteryx want us to believe).

 You may have used the spatial palette to help locate UFOs in the Advanced exam, but what other spatial tools and analytic techniques are you yet to be tested on?

5 Top Tips for the Expert Exam 

1 Understand What’s Expected of You Ahead of the Exam

• All the questions are practical and none of the questions are multiple choice (unlike the previous exams)
• There are only six questions
• You can only answer 5 out of the 6 questions, intentionally disregarding one of your choice
• The questions cover any and all aspects of Alteryx designer, so you need to (in theory) be familiar with all tools in the palette
• You can (right now anyway) only take the exam at the INSPIRE conferences
• You must get 4/5 or 5/5 to pass

2 Pace Yourself and Do the Questions in the Order That Suits You

• The exam is two hours long. In theory this divides into 5 x 20 min sections (+ some time for checking at the end). Pacing like this is useful in timed exams, but the reality is that some questions can be done much quicker than this, and others might take longer
• Before the exam timer officially starts, the invigilator will talk the whole room through all the of the questions. Pay attention here (don’t start skipping ahead to read the questions yourself) as the invigilator will be offering invaluable advice on ways in which you might wish to interpret the questions, plus any hazards you need to be aware of (e.g. banned tools or techniques that will score you 0, or ways to present your answers to get the correct mark)
• You need to get at least all but one question correct. I was confident after having read all the questions that there were three clear brackets: some questions I was confident I could answer; one I had a good idea of how to approach (but not whether I’d be able to do it in time); and one that felt quite intimidating. It was clear which I’d be leaving as the ‘untouched’ question, so I could get underway with the others. Though I was tempted to dive straight in with the questions I knew I’d find the most challenging (as really these would be the crux of whether I’d pass or not), I resisted temptation and quickly got the ones I knew I out of the way early. This allowed me to have a realistic perception of how long I had for any remaining questions I knew would be more challenging
• As stated above, I rushed through the first two questions to move onto the harder ones. Make sure you leave even 10 minutes at the end to check your answers. I found a really basic error in my rushed logic on Q1 in this check; I suspect if I hadn’t checked and corrected this in the final minutes, my exam outcome would’ve been very different!
• Mark your own work: use the time you’ve allocated at the end to decide which answers you think are correct, which will in turn inform how to spend those vital final minutes

3 Revision

• How do you revise for something where anything could come up? If only there were existing resources that cover all the possible topics…the Alteryx weekly challenges are an excellent resource! In fact, they are now conveniently bucketed into tool types (spatial, predictive etc.), as well as suggested difficulty. There are 100s of brilliant challenges available here; you don’t need to do them all, but it’s probably worth having a go at the sections you know you’re less familiar with in your day-to-day Alteryx-ing.
• Anything could come up, but what might actually come up? You’ve already done two exams to get to this point; what would you consider an ‘advanced or expert’ technique that hasn’t come up yet? Naturally I can’t say what came up on my exam, but I probably am allowed to say that many of the questions required tools from the palettes not tested on the advanced exam.
• Revision doesn’t end when you enter the exam room. Like the other exams, this is 'open book'. I genuinely left the expert exam knowing how to use more tools than I did when I went into it. If you’re truly an Alteryx Expert (which I suspect the other 13 experts are) then you can probably complete the exam in half the time you’re given. So why do they give you two hours to do it? Because that’s what real-world Alteryx-ing is about: use the community and use the Alteryx Help to cross check you’re using some of the more complex tools in the correct ways! I used Alteryx’s own help workflows during the exams to help check that I was approaching the exam in the best way. The reality is, you don’t necessarily need to know how to use every single tool, you just need to know what tool it is you would use (and learn on the job!)

4 Go in Expecting to Learn, Not to Pass

• This is more a mindset than a technical tip. I looked around in the room and saw some brilliant analysts, but rather than feel out of my depth, I decided I’d treat the exam as a learning experience (and like I’ve said, I learnt some new skills during the exam itself) – this mindset really help you relax throughout the exam; panicked thinking really isn’t going to help you with some of these questions

5 Don’t Let It Become Your Conference’s Only Priority

• As you know, you can only take the Expert Exam during the Alteryx INSPIRE conferences. But the exam is one of many brilliant learning experiences at the conference; I was tempted to miss the sessions leading up to the exam, so I could ‘prepare’, but I’m pleased I didn’t. There’s so much going on, and you never know, you might learn something that you need for the exam at the end of the conference!

Good luck to anyone taking the exam this year in Nashville or London!

For more info, check out the full blog on the Alteryx Community here