Displaying BigQuery results on Google Maps using Data Studio

Data Studio has a Google Maps layer

What if you want a map that looks like this?

The query above consists of these parts:

The resulting data looks like this:

In the BigQuery web console, click the button to “Explore Data” and choose Data Studio.

Select the Google Maps layer (see figure below)

Change the Bubble location to “marker” and edit the type to be Geo > Latitude, Longitude.

Remove the Bubble size — we want all dots to be the same size.

Change the Bubble color field to be mobility.

Then, switch over to the Style tab. Increase the number of bubbles to 5000. Then, change the colors so that max=Red, medium=yellow, and min=green as shown below.

You will now have a dashboard that looks like the one at the beginning of this article. Let’s now build a dashboard that also shows the number of cases.

Use this query to join the confirmed case counts from the New York Times (it’s also public dataset in BigQuery):

The result will look something like this:

Note the differences in behavior and outcomes between Colorado and Texas …

Enjoy!

Related posts:

Many of us are trying to decipher some level of meaning in the Covid-19 crisis. I must admit, I’m unable to find any. This is an act of nature, an act of environment. I see no message in either the…

AEternity blockchain is an Erlang-based scalable smart contract platform engineered by programming pioneers to address some of the most fundamental challenges native to earlier blockchains. By…

Una doctora de confianza me cuenta que sus padres y su hermano dieron positivo en los test de coronavirus. Su padre estuvo tres días en cuidados intensivos. A pesar de eso, los casos que anuncian en…