Dashboard Week Day 4: Seattle Bike Counters

by Andy Kriebel

With Power BI day behind them, we move onto day 4 in which the team will be analyzing cycling traffic data from Seattle. I haven’t downloaded the data for them this time, so they’ll have to do a bit of data prep.

SOURCE: Seattle Bike Blog


  1. Download the data for all bike counter locations.
  2. If data prep is required, they can use either Alteryx or Tableau Prep.
  3. They are welcome to work as a team on the data prep.
  4. They are more than welcome to supplement it with additional data. They can find more data about Seattle on their open data website.
  5. Before 5pm, they must have their dashboards uploaded to Tableau Public.

A quick Google search will lead them to some fantastic articles and visualizations. I’m really interested to see what insights they find as I wonder how much of the progress Seattle has made can be incorporated into a city like London.

Good luck!

© 2022 The Information Lab Ltd. All rights reserved.