Machine Learning & Big Data Blog

How To Create a Heat Map Chart in Tableau Online

Banner
3 minute read
Walker Rowe

In the chart below, the data points are too close together—a common problem that prevents you from reading the chart and gaining any intelligent meaning.

A heat map solves this problem by adding color to illustrate where individual points overlap. The color changes or intensifies as the number of data points in a region increases. The heat map also lets us put an additional metric on the otherwise 2-dimensional chart.

So, let’s look at how you can create a heat map in your Tableau Online chart.

Tableau Online chart

(This article is part of our Tableau Online Guide. Use the right-hand menu to navigate.)

Creating a heat map

To make a simple heat map, open Tableau Online and create a new worksheet. Choose the Superstore Datasource, which is included with Tableau.

new worksheet

Now go to the worksheet editor:

Worksheet editor

We want to figure out which sales offices are producing the highest sales and profits. We need to look at both sales and profits together. This is because, for examples, sales can be high while profits low, which may indicate that the sales office is giving too many discounts or operating at too high a cost.

So, we plot three metrics:

  • Average sales
  • Average profit
  • Office location (city)

Drag sales to columns and profit to rows. Change SUM() to AVE(Sales) and AVE(profit). Then drag city onto the detail mark. Then change the chart type to density.

We then get this heat map:

Heatmap

Of course, the data is still too close together to read all the data points. But that is not the point in this exercise: if we wanted to read individual metrics, we could have made a cross table with just text. Instead we use the heat map to identify both outliers as well as the profitability at which most offices are operating.

To drill in to read single office details, click on the chart to get the data point located there.

Chart

To zoom into an area, thus removing the outliers, we can adjust the axes by setting the axis range to fixed and entering a value there.

Heatmap settings

That results in a chart zoomed into a closer level like this. Now we can click on the data points in that zoomed-in region to more closely inspect that tightly packed region.

Heatmap Zoomed in region

We could also drop the cities, only look at the states, but then there is less need for a heat map—that chart would not be as dense.

Heatmap Results

Learn ML with our free downloadable guide

This e-book teaches machine learning in the simplest way possible. This book is for managers, programmers, directors – and anyone else who wants to learn machine learning. We start with very basic stats and algebra and build upon that.


These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing blogs@bmc.com.

Business, Faster than Humanly Possible

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
Learn more about BMC ›

About the author

Walker Rowe

Walker Rowe is an American freelancer tech writer and programmer living in Cyprus. He writes tutorials on analytics and big data and specializes in documenting SDKs and APIs. He is the founder of the Hypatia Academy Cyprus, an online school to teach secondary school children programming. You can find Walker here and here.