Launch, grow, and unlock your career in data

August 24, 2018

Makeover Monday: Africa's Deadliest Armed Conflicts - Density Map vs. Heat Maps

No comments
It's Friday night and I'm learning rather than watching TV or wasting time on other activities that don't exercise my brain. Earlier this week, I posted my Makeover Monday viz about armed conflict in Africa using the upcoming density map feature in Tableau. As part of my plan to improve my Alteryx skills, I wanted to recreate Tableau's density maps as heat maps in Alteryx as closely as I could. In Alteryx, it all starts with the workflow:

The workflow is simple and I'm sure there's a more elegant want to create it. The guts of the workflow:

  1. Create spatial points from the latitude and longitude of each record.
  2. Convert the spatial points into a heat map by grouping the points into grids. 
  3. Union the four streams back together.
  4. Export the data as a shapefile.

The reason I have four streams in the workflow is because I didn't see a way of doing a grouping by the event type within the heatmap tool.

The Alteryx heatmaps are easy to adjust; I played with the grid size and maximum distance a few times until I got something close to Tableau's density maps (without fiddling with the settings endlessly). I settled on a grid of 33 miles and a max size of 75 miles.

I also chose to create the shapes as donuts so that they wouldn't stack on top of each other. Here's the result:

Density Maps vs. Heat Maps

Let's start by looking at the difference between the density map and the heat map.

Here are some of the differences I have noted:

  1. Density maps in Tableau are completely dependent upon the number of marks in the view. The more accurate you want the density, the more marks you need to include. That's 9229 marks in this case.
  2. Since the heat maps Alteryx generates are shapefiles, they will render much faster as there are only 28 marks.
  3. The Alteryx heat maps clearly encompass all points, meaning you can see EVERYWHERE that there was an incident.
  4. Tableau's density maps hide the outliers.
  5. You can't have highlight actions on a density map as there no dimension categorizing the heat.
  6. The density maps looks much cleaner than the heat maps.

I like both version and they both have their benefits. The point of me doing this, though, was to improve my skills. The only way I'll get really good at Alteryx is to use it more. Focused time helps me develop. Removing distractions like social media (those things that don't help you learn) are a good way to free up wasted time. Make time to learn and you'll rarely regret it.

No comments

Post a Comment