Dashboard Week Day 1 - Prudential Ride London

by Luisa Bez

The infamous Dashboard Week has started! Today we looked at results of the Prudential London cycling event which took place at the end of July. Their website contains results of every cyclist who took part in the race, including age group, time needed to complete the race and event (46 miles and 100 miles).

All of us expected to be working on our Alteryx workflows until the late afternoon, but managed to be done by lunch time! If you’d like to know more about how we scraped tha data, take a look at Alex’s blog where he describes the workflow in detail.

For my viz I decided to give every cyclist the opportunity to compare themselves against the competition within their age group. Using the RANDOM() function on the x-axis I created a jitter plot to compare how long each cyclist took until they finished the race. Jitter plots are useful when dealing with lots of marks that would otherwise overlap each other. Check out Michael’s blog for a detailed step-by-step guide.

Here’s today’s viz, let’s see what tomorrow brings!

 

Fri 17 Aug 2018

Thu 16 Aug 2018