Analyze BigQuery data in Connected Sheets: Challenge Lab
Challenge scenario
You are just starting your junior data analyst role. So far you have been helping teams create and manage Google Sheets and data resources.
You are asked to help a newly formed development team with some of their initial work on a new project around analyzing taxi data in New York City. You have been asked to assist the Taxi team with their analysis using Google Sheets; you receive the following request to complete the following tasks:
Connect a BigQuery dataset to Google Sheets.
Use a formula to find the number of taxi trips that include an airport fee.
Create a chart of the percentages of all payment types.
Extract raw data from BigQuery to Connected Sheets.
Calculate a column to create a new column from transformations/combinations of existing columns.
#google #googlecloud #qwiklabs #bigquery #googlesheets #skills