Alteryx Core designer Certification – Guide

 

The above snippet is from my Tableau Public interactive resume. The pink circles on the timeline show all the certifications I have acquired so far.

This certification was so much fun to appear for. Before the exam, make sure your local computer has Alteryx (14 days Trial) installed. Duration is 2 hrs for 80 questions. Its a mix and match of almost all the important tools used in Alteryx. For more idea please go through the syllabus here.

1. Register here, make sure to use your company email
2. Go through the prep guide here
3. The link arrives on the first day of the next month for registration
4. You have 3 attempts each month; if you can’t clear in those 3 months, try again next month
5. There are a few very good videos shared in the live training area of Alteryx

            a. Live Training: Core Certification Prep – Part I

            b. Live Training: Core Certification Prep – Part II

            c. Live Training: Core Certification Prep – Part III

d. 2018-11-20: Core Certification Prep – Part IV

The idea of the test is to get one familiarised with the Alteryx designer environment. So what we have to do (unless you know it already) is to try them out on the Alteryx designer itself. So it is very important to have the designer open in front of you. Also, if you know some of the answers, it will save you a lot of time.

The best way to prepare for this test is to play with each and every designer element. Weekly challenges are also another good way of getting yourself familiarised with the environment. If you have worked with Alteryx, this is a good way to remind yourself the basics of the tool.

Lastly there is a limit of 3 attempts every month until you clear the test. It’s free of cost. Get yourself some time and just go for an attempt; the tests themselves prepare you well for the tool.

All the best for your certification. I will be happy to answer any queries regarding the same.

To read more about Tableau Desktop Qualified Associate certification, please click here

 

 

 

 

 

 

 

 

Train Vs Plane: MakeOverMonday W38 2018

Pretty simple dataset but datavisualization can do wonders in pointing out the outliers and getting audiences focus in areas the dataviz author wants to. Here is the original viz.

I like the original viz because it’s neat and gets the message accross by comparing the ticket prices w.r.t to how many weeks ahead they were bought. So the data is a comparison of the variance of Plane and Train ticket prices for different source and destinations.

I had been itching to create a viz using Jump plot, that I have learnt after reverse engineering @NilsM09 and @MarkBradbourne vizes. This data was pretty apt for that. Had to do some dataprep using Alteryx.

In the viz, the x axis signifies the % difference between ticket prices of Train and Plane. While the hieght of the jump plot signifies the Train tickets price. The outcome is quite surprising, given that sometimes the Train ticket prices are higher than flight prices, although it’s not often.

 

Avocado Price: MakeoverMonday W40 2018

This particular one was a bit interesting as the data was in very detailed format. There was a lot of interesting and wonderful dashboards already created by the makeover monday crew and I was wondering how to visualise the data a bit more differently. Before we get there here is an overview of the original visualisation.

Its an average overall dataviz.

What I wanted to do was to compare the average and total price of avocado quarterly. In order to do so I decided to blend and edit the data in Alteryx. The idea was to get the Weeks for each date, then to which quarter of the year it belongs to and lastly count the weeks for each quarter and reset the week to 1 for each quarter.

In the final dataviz I have got a line chart comparing current quarter with the previous quater and the previous year’s same quarter as current quarter.

Look at total price of Avocado region wise. Look at QTD total price, volume, days left. Glimps of last 5 days total Avocado price. Also a quaterly metric of total price for conventional and organic Avocado.