Dashboard Week: Day 3 - Public Transport Around the World

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!

Author:
Andy Kriebel
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab