Alteryx Challenge & Prepping Data Alteryx Solutions Log

by Liu Zhang
This is HIVERY trademark tagline. Data Has A Better Idea. Visit to learn more about who we are.
Photo by Franki Chamaki / Unsplash

Update Time: 15/06/2021

There are 272 Alteryx Challenges and 122 Preppin' Data Challenges

Our instructor Carl Allchin (who loves Quokka) from the Data School also runs Preppin' Data blog.

Preppin’ Data
Challenge by: Carl Allchin This week’s challenge continues the focus on calculations, this time the focus is numbers. When using measur...

I want to give it a try as well, where I think it is valuable experience to practice all kinds of data, therefore this blog is keep track of my progress. The blog posts solution in Tableau Prep, while in training, I should do so in Alteryx as well as in R (will be uploaded in future after the former is done)

Note 1: This is a solution, not necessary the most efficient/robust/easiest solution. I will update if there is error or substantial improvement in the workflow while I learn more about Alteryx from Data School training.

Note 2: Kelly Gilbert offers her solution in Alteryx and Python at

Google drive folder link:

Data Prep Chanllenge/Exercise – Google Drive

Google Sheet Log:

Data Prep Solution
Alteryx Challenge LinkCodeDone,In-Process,Not-AttempedNumber1,2,3,4,5,6,7,8,9,1011,12,13,14,15,16,17,18,19,2021,22,23,24,25,26,27,28,29,3031,32,33,34,35,36,37,38,39,4041,42,43,44,45,46,47,48,49,5051,52,53,54,55,56,57,58,59,6061,62,63,64,65,66,67,68,69,7071,72,73,74,75,76,77,78,79,808...

Thu 22 Jul 2021

Fri 18 Jun 2021

Wed 14 Jul 2021