Dashboard Week: Day 3 - Public Transport Around the World

by Andy Kriebel

We gently move into hump day and keep rolling along through Dashboard Week. So far, I’ve been super impressed with the team. In case you’re wondering why we do dashboard week, it’s basically to get them working quickly. Essentially they’re learning a new language every day. This is great practice for being a consultant. You might be in one department or one company one day and a different company or department another day. They all have their own language and you have to be able to make sense of the data very quickly.

For day 3, the team is tasked with visualising public transport data. Ideally I’d like to learn about ridership patterns. I have 8 cities for them to choose from. I’m 99% sure each of these cities has a public API to pull data from. If not, I’ll let them nominate another city, as long as it’s not London or New York.

London bus map courtesy Mark Bulling on Tableau Public

They’ll get their assigned city by picking a number out of a cup. Here are the options:

  1. Atlanta
  2. Switzerland
  3. San Francisco
  4. Madrid
  5. Paris
  6. Berlin
  7. Philadelphia
  8. Chicago

That’s it! Easy peasy!