Connected Sheets brings you the power and scale of a BigQuery data warehouse to the familiar context of Google Sheets. With Connected Sheets, you can analyze billions of rows and petabytes of data in Sheets without specialized knowledge of computer languages like SQL.
This makes it easy for anyone, not just data analysts, to apply pivot tables, charts, and formulas to massive datasets and hone in on their most valuable customers or product lines; develop forecasting models, uncover trends, and perform ad hoc analysis with ease.
What you will do
In this lab, you:
Connect a BigQuery dataset to Google Sheets.
Use Formulas to find the percentage of taxi trips that included a tip.
Use Charts to inspect popularity and trends of payment types.
Use Pivot tables to find out when taxi rides are the most expensive.
Use Extracts to import raw data from BigQuery to Connected Sheets.
Use Calculated columns to create a new column from transformations/combinations of existing columns.
Use Scheduled refresh to set up automatic data refreshes for your analyses.
Lab Link:
https://www.cloudskillsboost.google/paths/18/course_templates/865/labs/523373