Visualizing Geographic Data using Google Data Studio

Geographic Data in Data Studio

I’ll provide some examples of how to visualize Geographic data using Google Data Studio.

I’ll use a table listing the world’s tallest buildings.

Here’s an example of how the table is structured:

RankBuildingCityCountryHeight (m)Height (ft)FloorsBuilt
1Burj KhalifaDubaiUnited Arab Emirates8282,7171632010
2Shanghai TowerShanghaiChina6322,0731282015
3Abraj Al-Bait Clock TowerMeccaSaudi Arabia6011,9711202012
4Ping An Finance CentreShenzhenChina5991,9651152017
5Lotte World TowerSeoulSouth Korea554.51,8191232016

Now let’s see if we can visualize the data in Google Data Studio.

The first step is to add the data, which I’ve placed in a Google Sheet.

We’ll need to make sure that the field City is listed as a Geo data type. This will allow the data to be displayed on Geo Maps in Data Studio.

When then need to confirm we are fine with having City as a ‘Town/City’ geo data type.

We now add the data to the report.

We click ‘Add to Report’ to add to Data Studio.

Creating a ‘Count’ Custom Field

But we need a count of all the different Building.

To do this we create a custom field called ‘Count’.

We click ‘Add a Field’ and then use the following formula:

COUNT_DISTINCT(Building)

This counts each individual Building name as ‘1’.


Creating Geo Maps in Google Data Studio

Once we have our Count field we can create some maps.

Click on ‘Add a chart’ and then choose a custom Geo Map.

Visualizing Geographic Data using Google Data Studio

To create the map we will use the dimension Country and the metric Count.

Visualizing Geographic Data using Google Data Studio

We now have a world map counting the number of buildings in each country.

But we’d also like to create a world map showing which cities have the most tall buildings.

So we can copy and paste the world map we already created.

Visualizing Geographic Data using Google Data Studio

We then change the dimension ‘Country’ to ‘City for the map.

We now have two different world maps. One showing the number of tall buildings in each country, while the other shows the number of tall buildings in each city.

Visualizing Geographic Data using Google Data Studio

Below is the finished Data Studio report, with a table listing the world’s tallest buildings.

Michael

Author Michael

More posts by Michael

Join the discussion 2 Comments

  • Lee Hurst says:

    Hi Michael, Very nice and clear series of posts! One possible tip – I found it cool to overlay the city view over the country or region view , then set the opacity for the city map to about 30. This allows showing both the views in a little less space. The tradeoff is you only get interaction with the top layer but sometimes it is a good trade!

Leave a Reply