Data Viz Done Right

# Workout Wednesday: UK House Prices Hexbin Maps

Another great learning experience today for me thanks to Emma! This week required us to create hexbin maps in Tableau. I'd never done these before, so I got stuck in, knowing I'd come out of it have learned something.

1. Create the hexbin map based on the District
2. Change the size of the hexagon using a parameter
3. Match the sunrise-sunset diverging colour palette on the hexagons
4. Match the tooltips and titles
5. Set the dashboard size to 650 * 700 pixels

Fortunately Emma linked to a blog post by Matt Chambers for how to use the HEXBINX and HEXBINY functions. This made the exercise immensely easier because all I really needed to do was swap out [Ratio] in the blog post with my parameter.

I couldn't get the total in my title to match, though I knew I had done it right. It turns out Emma used an LOD that returns the average for both years, not just the year selected. I decided to use the year selected because that reflects what's in the map. I also create this value with a table calc since all of the dimensions I needed were already in the view.

Also, requirement #2 to change the size is actually a requirement to change the denstiy, i.e., how many hexabins are created. So, I decided to also size the hexagons based on how many are displayed in the view. So if you enter a smaller number, the hexagons are bigger. Enter a big number and the hexagons are smaller. I also limited the parameter to between 20-200.

Lastly, I floated everything since the color legend had to be floated above the hexmap. I find that Tableau works best when you go either 100% float or 100% tiled.

Nice fun challenge! Learned a bunch!