In this tip, I show you how to create a hexbin map in Tableau. But first, let me explain the purpose, benefits and drawback of a hexbin map.

There are countless times when I have been asked to display way too much data on a map. Sometimes I’ve been asked to display thousands of points on a map..but why? I know no one will understand it. 

A hexbin map uses hexagons to divide an area into multiple parts and assign a color gradient to each hexagon. This chart type is used to visualize density, where the hexagons dividing the whole space into discrete units of equal size. 

This video is going to help you communicate the concentration of data on maps more effectively and give you another option for visualizing geospatial data. I’ll show you how to create a hexbin map based on both the value and the rank, giving you two options depending on your use case.

If you want to follow along, these are the data sources I used:

1. Austin Bike Accidents - https://bit.ly/AustinBikeAccidents

2. Austin Zip Codes Shapefile - https://bit.ly/AustinZipCodes

3. Price Summary - https://bit.ly/PriceSummary

I couldn't find too much to do with this week's data set, so I ended up with some simple BANs and line charts that take the original and reorganize them a bit to make them more clear.

Resources:

1. Data set - https://data.world/makeovermonday/2021w32
2. Chart Guide - https://chart.guide/
3. Final Viz - https://bit.ly/mm2021w32

#MakeoverMonday week 44 is another #Viz5 initiative. The topic this week is access to the internet and mobile phones by gender and country.

First, sorry about the video cutting out at the very end. My mistake.

In this video, I first review the initial visualization and talk about what works and what does. In the end, I went with a quadrant chart, which is a scatter plot with broken up into four quadrants. The viz focuses on only two of the quadrants to highlight the significant difference in the number of countries where women have more access to men for both technologies vs. the opposite.

I showed several methods for visualizing the data:

1. Side-by-Side Bar
2. Bar in bar
3. Bar Graph vs. Reference Line
4. Barbell
5. Peas in a pod
6. Floating bar chart
7. Slope graph (terrible choice)
8. Ranked slope graph (even worse choice)
9. Histograms
10. Box plot
11. Scatter plot

Resources:

1. Final workbook - LINK
2. Data set - https://data.world/makeovermonday/2020w44
3. Country and region information (Be careful joining this as some country names don't match. You'll want to using data blending and alias the country names to match.) - https://data.world/vizwiz/country-region-codes
4. Chart Guide - https://chart.guide/
5. Interactive chart chooser - https://depictdatastudio.com/charts/ 

People love maps. Putting dots on a map gives a sense of precision. There are lots of methods for displaying maps. In this video, I show you four:

1. The exact locations
2. Density map
3. Using the ROUND function to generalize the points
4. Using the HEXBIN functions to generalize the points, but at a level controllable by the user

What works well?

What could be improved?