Nested Sort in Tableau with Rank Table Calculation

Nested Sort in Tableau with Rank Table Calculation

Sorting the measures is an important step in building a vizualisation as it helps us digest the data on display quicker.  Nested sorting is required when there is more than one dimension in the view. I’m using superstore data set for this exercise, I want to find the...
Dashboard Week Day 4: Boston 311 Service Requests

Dashboard Week Day 4: Boston 311 Service Requests

Last day of Dashboard Week!! Today, we only had 5 hours to build the dashboard, luckily we didn’t need to use Alteryx.  The data we were given was on 311 Service requests for Boston, one csv per year starting from 2014.  This was a big data set. In Tableau, I...
Dashboard Week Day 3: Museum of Modern Arts

Dashboard Week Day 3: Museum of Modern Arts

Three down, One more to go! Today, we were given the data on Museum of Modern Arts Collection. At first glance, it looks like the data doesn’t need a lot of cleaning but that wasn’t the case.  When multiples Artists were associated with one item in the...
Dashboard Week Day 2: YouTube Trending data

Dashboard Week Day 2: YouTube Trending data

We have survived Day 1 of the dashboard week. For Day 2 we were given the data on the videos that were trending on YouTube. There were lots of files in the csv and JSON formats. I used Alteryx to combine all the csv files using wildcard input first, then did the same...
Dashboard Week Day 1: Game of Thrones

Dashboard Week Day 1: Game of Thrones

It’s the first day of our much-dreaded dashboard week.  Our challenge for today was to use an API to get data on Game of Thrones (GoT). We could choose from data on GoT characters, the books and the Houses.  I chose to look at the characters. I have extracted the data...
How I prepared for the Alteryx Designer Core Exam

How I prepared for the Alteryx Designer Core Exam

I recently passed the core exam and here is how I prepared for it.  It is a free exam to take, you can sit it once to get a feel for what will be in the exam. How you prepare for the Alteryx Designer Core Exam depends on how much experience you have in using Alteryx...