Introduction
This week we are live at DataFam Europe in London and we have paired up with Preppin Data to make sure our data is in the best format ready to go for building our visualisation. If you want to take part in the PreppinData challenge, you can find it here.
As we are in London, we thought it would be a good time to focus on London’s Top Attractions, their popularity, nearest tube stops and other close by attractions. This interactive dashboard will allow you to find an Attraction and the nearest tube stops to help you plan your next adventure.
As it is a live challenge, I am going to break it down into key steps to achieve this dashboard
Requirements
- Relate the 3 data sources together, plus add an additional attractions connection
- NOTE: Due to Spatial relationships not being a thing yet, you can just do a relationship calculation of 1 to 1, and the calculations will do the rest
- Also for the other attractions, you don’t want the name to equal each other
- The map should show a Selected Attraction as a Star
- Tube Stations & Other Attractions within X miles of the Selected Attraction
- Tube Stations & Other Attractions within X * 1.5 miles of Selected Attraction
- Attractions by 5 Year Average Footfall
- Top X Tube Stations & Other Attractions by closest distance
- Bring all charts onto a dashboard (1200×700)
- Create a Parameter action to enable Main Attraction to be selected
- Create Rank of Tube Stations, Convert to Letters (you may need to +64 within a calculation)
- Only Show Top X Stations & Other Attractions as Letters & Icons on the Map
Dataset
This data set comes from the outputs of the PreppinData Challenge, but can also be found here
Attribute
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2024 in your description to make it searchable!
Share
After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2024 #Tableau and tag @WorkoutWednsday