For #MakeoverMonday week 26, it was huge dataset about London’s Cycle hire usage (Boris Bikes) :
Here is the original viz was created by Sophie Sparkles:
To access the entire data from 2012 to 2018, one can use Exasol data source shared here or one can download the dataset for 2017 from data.world
Here is what I did:
- I wanted to see correlation between weekday and hourly data hence use heat map with bar charts to see the data.
- Added highest and lowest hour highlight
- Use filter of year to filter for the year and use the map to see all the pick up points in London
- added interactivity on graphs and maps to provide option to filter on any pick up point and analyze the data
Here is the Gif of the visualisation I created (download on the gif to download the Tableau file):
Use following steps to connect to database post of file:
- Navigate to the sign-up page to register
- You will receive an email with your credentials
- Download the EXASOL driver (Tableau 32 bit; Tableau 64 bit; Tableau Mac OS)
- A connection prompt will appear once you start dragging fields onto your worksheet. Enter your credentials (from the above email) in the connection prompt
- start your analysis
Thanks for visiting blog. Please do let me know your feedback and if any particular topic you would like me to write on.
Do subscribe to Tabvizexplorer.com to keep receive regular updates.