What is a Tableau Heat Map?
How do you create a Heat map?
To create a heat map, you need to have a data set with at least in dimension and one measure. Ideally, you must have two dimensions, of which one should be a date and one or two measures. When you select your data source, follow these steps:
- Select your dimensions and measures when holding a CRTL button.
- Press Show Me button in the top-right corner and select Heat Maps to create our Tableau heat map.
What are the best practices to use heat maps?
To use a heat map in Tableau is a go-to practice when you have some measure that you can analyze by timeline or sub-categorical dimensions that divides the sum of that measure. If you have too many rows and columns in your heat map, then you can add filters to make finding insights easier.
Example 1. Determining which region has the most sales
Tweaking the heat map
Even though a Tableau heat map is intact, we still not have the best version of the chart in front of us. Indeed, there are a few things that we can improve here. First, increase the size of a heat map so it would look more appealing. Second, switch SUM(Sales) pill in the marks field from Size to Color and choose whatever color palette you like.
Example 2. Best App Store games 2008-2019
Let’s open the 17k app store games database from Kaggle. Steps that I use to create a Tableau heat map are in this video:
Using various filters, you can determine multiple app store games that have the biggest User Rating Count. As we know that the best games get rated more, the big User Rating count can indicate the best seller games in the Apple app store. If you want to know the best Role-Playing games, filter this genre and set the minimum User Rating count such that optimal number games could appear in a worksheet. For example, after placing the minimum User Rating to 20.000, you can see a Tableau heat map consisting of probably the best Role Playing Games in App Store history. Tableau Public worksheet is shared below.
Example 3. CO2 Emissions By country in the Tableau Heat Map
This example is meant to show countries with the most significant CO2 emission and also changes in the emission numbers in the timeline. You can download the CO2 Emission data here. I am not going into further aspects of what steps I am taking to build a heat map in this case. Just watch the video below and digest it.
To summarize, a Tableau heat map is an excellent alternative over traditional excel tables with numbers. In numerous circumstances, it is easier to find patterns using the size and color of cells over numbers.