Engineer Data in Google Cloud: Challenge Lab

Detailed walk-through of the Engineer Data in Google Cloud Skill Badge on Google Cloud Platform.

Photo by Luke Chesser on Unsplash

This medium article focuses on the detailed walk through of the steps I took to solve the challenge lab Engineer Data in Google Cloud: Challenge Lab in Google Cloud Skill Badge on the Google Cloud Platform.

This lab is only recommended for students who have completed the quest Data Engineering on Qwiklabs.

Open BigQuery Console

In the Google Cloud Console, select Navigation menu > BigQuery:

The Welcome to BigQuery in the Cloud Console message box opens. This message box provides a link to the quickstart guide and the release notes.

Click Done.

The BigQuery console opens.

Click on your project ID > Taxirides > historical_taxi_rides_raw

Task 1: Clean your training data

Copy and paste the following query into the BigQuery Query editor:

Task 2: Create a BQML model called taxirides.fare_model

Task 3: Perform a batch prediction on new data