How can I create a heat map without writing a single line of code? It sounds very difficult, but it’s not really the case. Just use our reporting tool, FineReport, to easily create a cool heat map with an excel-like operation!
Made by FineReport

1、Find the data source

The first step in data analysis is to find the source of the data. So where can I find the data for the seismic heat map? The answer is USGS. We can obtain seismic data of various regions from it. In this article, we take the world’s seismic data from 1999 to 2019 and import it into Excel and edit it into a unified format as shown below.

2、Connect data set

The data source is found, now download our FineReport (Download) first~ After completing the download, open the designer and how to connect to the dataset? Since FineReport can’t directly connect to Excel data source, we need to put the excel data under the path of installing FineReport. At this time, re-open the designer, you will find your Excel data file, and then import it. Select file, set file type as excel, then choose local file, select the excel file just imported, on the right side select “First row contains column headings”.

3、 Template data set

Take a cell chart as an example, merge a cell, click Insert -> Cell Element -> Insert Chart, select the heat map, as shown below:
Select the chart, on the right side select the chart property table -> type, and select the heat map by default, as shown in the following figure: here I select Template Parameter, then select the GIS layer as Satellite (many other options). You can set the center point of the map display. Here I choose (101,0) to display Southeast Asia as the center.
Then set the map data, as follows

4、Template style design

Next, adjust the specific form. The legend is set to a gradient color by default. You can define the maximum and minimum according to your needs. Select Chart Property Table -> Style -> Series, you can see that the series properties are divided into two settings: Heat point and BG area. If the boundary/point selected by the user does not contain the boundary information, the setting is invalid. The series interface of the thermal point is as follows: the larger the rendering radius, the larger the display range of the heat region; the greater the blur, the higher the blur of the heat boundary. Opacity minimum and maximum, corresponding to the opacity of the minimum and maximum values in the graph, set here as follows.

5、Effect display

Finally click on the preview and all done!
Wow, the effect is great! Here is a heat map of earthquake in Southeast Asia. The darker the color, the higher the probability of an earthquake! Come and see where the earthquake is happening! Seeing here, someone may be a bit curious about how the Earth image at the beginning of the article was made. very simple! Just select structure(new) when inserting the chart. The subsequent settings can be experienced by yourself, very similar~
Follow FineReport Reporting Software on Facebook to learn more about data visualization!