Module Review (Quiz-3)

Module Review >> Astronomy: Exploring Time and Space

Query service

Storage service

Data Optimization service

Machine Learning service

In the BigQuery Web UI, find the table and click the details tab and view the rows.

# Run the below query:

SELECT

COUNT(*) AS total_trips

FROM

`bigquery-public-data.san_francisco_bikeshare.bikeshare_trips`

# Run the below query:

SELECT

SUM(*) AS total_trips

FROM

`bigquery-public-data.san_francisco_bikeshare.bikeshare_trips`

True

False

Consider making ride_timestamp an ARRAY of timestamp values so each ride_id row in your table could still be unique and easy to report off of.

Consider renaming the ride_id column to ‘label’ so you can use it in a BigQuery ML model to predict the ride_id of the next ride.

Consider adding lat / long geographic data points as new columns and using GIS Functions to quickly plot the distances your fleet has travelled.

Module Review >> Astronomy: Exploring Time and Space