Our final day saw us build dashboards based on USA interstate traffic
Details here: https://www.thedataschool.co.uk/andy-kriebel/ds28-day-5
Our prep involved joining the station and volume data together in Tableau Prep. I did end of forming the spatial points in Alteryx as Tableau was acting up
Here are my Prep and Alteryx flows
The prep involved a few cleans and a pivot plus creating spatial points. Annoyingly the latitude and longitude needed some calculations as they were formatted incorrectly.
Here was my initial plan:
The plan had a map showing traffic trends at each hour of the day, some BANs and a bar chart ranking stations by state.
Here was my final Dashboard:
https://public.tableau.com/app/profile/jacob.kilroy/viz/USAInterstateTraffic/Dashboard1?publish=yes
I tried a dark theme this week which I think sort of works. Some tweaks with the colours would help a bit but overall pleased with my first attempt at a dark theme.
The final dashboard followed my plan closely and I also included a line chart to compare stations to the US average.