In this example, we want to explain how we can create a Heatmap (Worldmap) using EazyBI (in this case for Jira).

As prerequisite we need a CSV with at least 3 fields: one for the ID of the row and other two fields for the longitude and geographical latitude.

Captura de pantalla 2018-05-17 a las 16.28.00

We need a special dimension for the ID column, and use the Measures dimension for the latitude and longitude.

Once imported in the EazyBI account….

Captura de pantalla 2018-05-17 a las 16.29.09

We can start creating the Report, in this case a Map report.

Captura de pantalla 2018-05-17 a las 16.27.03

It’s mandatory the two first columns must be the latitude and longitude/length, now we can show the Map points.

It’s beautiful!!! I love the ZOOM feature!

Captura de pantalla 2018-05-17 a las 16.26.24

It’s usual to unknown the geographical coordinates,  so for this reason we usually cross databases to obtain this value, for example we can obtain a database of the Spain villages here.

Once downloaded, import the tables in some MySQL server in your laptop. Just transform your source file CSV in “INSERT” sentences using Excel or Google Sheets.

Import the SQLINSERT” sentences in your MySQL and just JOIN the tables. Export the results in another CSV and you will be ready to import to EazyBI

Another way to do Heatmaps with EazyBI is using the ISO code of the Region/Country. I will explain in a future post… 😉

That’s all!

By MrAddon

 

Advertisements
Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s