From the course: Learning BigQuery

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Integrating BigQuery with Data Studio

Integrating BigQuery with Data Studio - BigQuery Tutorial

From the course: Learning BigQuery

Integrating BigQuery with Data Studio

- [Instructor] Now that we've covered different types of BigQuery tables. Let's focus on how we can analyze them using visualizations. We already have the results of a SELECT query in here. And to perform additional analysis of the data, we can expand the Explore Data menu. Here, you will note that the only option present is to explore the data using Data Studio, which is the Google Cloud Platform's visualization service. When we make this selection, you will note that an interface has come up, which already has a table containing some aggregated information. We have the state field along with a record count indicating the number of occurrences of a specific value in the state column. However, for our visualization, it is a different type of aggregation which we will need rather than a record count for different state values. First though, let's select a visualization before we configure it to present the information which…

Contents