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 - 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.