Dashboard Week Day 5: U.S. Highway Traffic

by Andy Kriebel

For their final day of Dashboard Week, DS28 will need to visualize one month of hourly traffic counts at stations across the U.S. Ideally for today’s project, they will figure out how to download all of the station data for all years from the US Department of Transportation here. The data is available in STA format, but I have no idea how to use that in Alteryx. I’d like them to spend no more than 30 minutes together to try to make it work.

If not, then they can get 24 hours worth of data from Metrocosm.

Source: Metrocosm

There are two files they will need to join: (1) traffic stations, (2) hourly traffic counts. They can get the data here.

They’d be wise to read more about this project and the insights found on the Metrocosm page dedicated to this particular project. The visualization they created literally looks like heart arteries when you zoom in.


  1. Download both data sets.
  2. If data prep is required, they need to use Tableau Prep.
  3. They are more than welcome to supplement it with additional data.
  4. They can use any data visualization tool of their choice.
  5. All other standard rules apply.

It’s been a great week! The team has really taken on the challenges and realized they can do quite brilliant work in a very short amount of time. This is great preparation for life as a consultant.


Andy Kriebel

Mon 20 Jun 2022

Mon 20 Jun 2022

Tue 14 Jun 2022