Makeover Monday: Tiled Heatmap of U.S. Air Quality Levels

Yesterday I was at Exasol HQ trying to help them with their hackathon. I wasn't able to access their data for the hackathon, so I decided to do some testing for them with this week's Makeover Monday data set.

I was very interested in looking at state-level air quality and built lots of heatmaps and originally built them in a single worksheet using table calcs to sort out which states go in which columns and rows.


This didn't work for me, though, because it only helped me see the states alphabetically. It's much more intuitive if they are displayed geographically. An idea popped into my head...

I wonder if I can combine a heatmap that looks at daily max reading by state across all years with a tile map.

I quickly went to Matt Chambers' great post for how build tile maps added the secondary data source, blended it by state and replaced my crazy table calcs with a simple tile map view. What a fun exercise! I learned a ton and feel like I created a much more intuitive view. Does anyone recall every seeing a tiled heat map? Have I come up with a new chart type???

Click on the image for the interactive version. Note that the viz might be slow to load as it's displaying about 460,000 marks.