From data to metrics in minutes with an Illustrative use case

Now let’s start our exercise – we will try to use data visualization for exploration and reporting. You will only need Looker Studio and BigQuery as the data sources for the exercise in this chapter.

We’ll perform two main tasks in this section:

• Exploring the BigQuery INFORMATION_SCHEMA table using Looker Studio
• Creating a Looker Studio report using data from a bike-sharing data warehouse

Before trying out Looker Studio, let’s become familiar with INFORMATION_SCHEMA in BigQuery.

Understanding what BigQuery INFORMATION_SCHEMA is

INFORMATION_SCHEMA is a collection of tables in BigQuery that stores your BigQuery metadata. For example, if you want to know how many tables exist in your project, you can use the table INFORMATION_SCHEMA view. The other common example is that you might be wondering how much a query costs per job, day, or month. For that, you can access the...