menu
arrow_back
返回

Building Demand Forecasting with BigQuery ML

—/100

Checkpoints

arrow_forward

Explore the NYC Citi Bike Trips dataset

Cleaned training data

Training a Model

Evaluate the time series model

Make Predictions using the model

Building Demand Forecasting with BigQuery ML

1 个小时 5 个积分

GSP852

Google Cloud Self-Paced Labs

Overview

BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage, or needing a database administrator.

BigQuery Machine Learning (BQML) is a feature in BigQuery where data analysts can create, train, evaluate, and predict with machine learning models with minimal coding. Watch this video to learn more about BigQuery ML.

In this lab, you will learn how to build a time series model to forecast the demand of multiple products using BigQuery ML. Using the NYC Citi Bike Trips public dataset, learn how to use historical data to forecast demand in the next 30 days. Imagine the bikes are retail items for sale, and the bike stations are stores.

Watch this video to understand some example use cases for demand forecasting.

Objectives

In this lab, you will learn to perform the following tasks:

  • Use BigQuery to find public datasets.

  • Query and explore the public NYC Citi Bike Trips dataset.

  • Create a training and evaluation dataset to be used for batch prediction.

  • Create a forecasting (time series) model in BQML.

  • Evaluate the performance of your machine learning model.

加入 Qwiklabs 即可阅读本实验的剩余内容…以及更多精彩内容!

  • 获取对“Google Cloud Console”的临时访问权限。
  • 200 多项实验,从入门级实验到高级实验,应有尽有。
  • 内容短小精悍,便于您按照自己的节奏进行学习。
加入以开始此实验