Skip to Main Content

Dahlgren Memorial Library

Creating Dashboards with Google Data Studio

Use this guide to follow along during DML's Google Data Studio Workshop

Connect to BigQuery

In your Data Studio Dashboard, click the "+Create" button at the top left. Select "Data Source". 

add a new data source

Select "BigQuery" from the list of Google Connectors.

select BigQuery Connector

If this is your first time connecting Data Studio to BigQuery, click the "Authorize" button to authorize the connection. 

authorize BigQuery

Select Public Datasets -- Your billing project -- covid19_jhu_case -- summary. Then click the "add" button to connect. 

connect to covid-19 dataset

Verify the data fields being imported. Change the "province_state" datat type from "text" to "Geo--Region". Click "Create Report" once you have confirmed the data types. 

confirm data types from JHU dataset