This article was last updated May 2018
A heat map highlights different levels of data (e.g. population size) per region on a map. To create a heat map, use eSpatial and follow the instructions below. Sign up for a free eSpatial trial here to start heat mapping your data!
Two Types of Heat Map
As you can see from the images above, eSpatial can create two types of heat map. Each type of heat map can give you different views of your data depending on the question you’re asking and the result you’re looking for.
Hot Spot Heat Map – This is a data styling option in eSpatial which takes data plotted on a map and reveals a density attribute (e.g., sales volumes per year, etc.) in a region that is not restricted to fixed geographic boundaries.
Regional Heat Map – This type of heat map summarizes and expresses data plotted within a defined region – state, country, etc. Levels of data present are distinguished by colors or shades (e.g., red = high volume, pink =- low volume).
Create a Hot Spot Heat Map
- Log in to your eSpatial account (get a free trial here). Upload your Excel spreadsheet data (or use the sample data in the Add Data panel, to see how it works)
- Click on the Style icon on the Control Panel to open the Style and Color Panel.
- On the Style & Color panel, which appears on the right side of the screen, make sure you have the correct dataset selected from the drop down menu on the top left of the Style and Color Panel and Select the Heatmap option.
Below, I’ve highlighted the heat map customization options. Experiment with these to create the best visualization for your data.
- (Optional) Tick Overlay pins, at the bottom of the Style & Color panel, if you wish to see the original mapped uploaded data expressed as pins on top of the heat map. Tick Color Snapping if you wish to smooth out the edges of the heat map:
- Save your heat map and give it a title. It will be saved to your Library, then click Close.
Create a Regional Heat Map
You can quickly create a regional heat map using eSpatial (sign up here for a free trial).
Once you’ve uploaded your data or used our built-in sample data (available on the Add Data panel) you can create an Excel regional heat map (like the one above) by simply clicking on the Analyze Data button.
Next, select Regional Heatmap:
Now you need to select the data that you want to express on your heat map, as well as the region dataset.
Region datasets can be composed of pre-existing regions (e.g. US States, UK Counties, etc.) or on territory datasets you have previously created.
If you have no region datasets in your account, you can add the relevant region by clicking the Add Region Datasets button. In the panel (Add from Library), click the eSpatial datastore tab, find the dataset you want and then click Add to Map:
Close this panel and you can see that the region dataset is now available from the Select region dataset drop-down menu.
(For more on datasets and the eSpatial datastore, go to our help pages).
Now simply click Complete to generate a heat map of your point data. If you use the sample data for your point dataset and the US States as your region dataset, as I have done, your Workspace should look like this:
You’ll notice that, by default, the map has retained the original pin data (the green markers). You can toggle these points on and off by clicking on the eye in the legend menu.
If you are sharing the map and only want to show the heat map analysis (and not the point dataset), simply use the Save As button in the control panel, which is found when you click the Save icon.
This allows you to save the Workspace heat map view as a unique map (you will still have the original – as long as you have saved it). And that’s how easy it is to create an Excel heat map using eSpatial. Take a look at the other types of maps you can create with eSpatial here
Are you a Salesforce User? Check out eSpatial for Salesforce on the AppExchange!
READY TO GET STARTED?
Create your first excel heat map in minutes