Applying BQML's Classification, Regression, and Demand Forecasting for Retail Applications
Advanced 5 Steps 5 hours 25 Credits
In this quest you will learn how to use several BQML features to improve retail use cases. Predict the demand for bike rentals in NYC with demand forecasting, leverage regression to estimate the time it will take for a ticket to be solved with the help of an automated agent developed using Dialogflow, and see how to use BQML for a classification task that predicts the likelihood of a website visitor making a purchase.
In this lab you will learn fundamental SQL clauses and will get hands on practice running structured queries on BigQuery and Cloud SQL.
In this lab you will train a simple machine learning model for predicting helpdesk response time using BigQuery Machine Learning.
In this lab you will build a time series model to forcast demand of multiple products using BigQuery ML. This lab is based on a blog post and featured in an episode of Cloud OnAir.
In this lab you will use a newly available ecommerce dataset to run some typical queries that businesses would want to know about their customers’ purchasing habits.
In this lab you will explore millions of New York City yellow taxi cab trips available in a BigQuery Public Dataset, create a ML model inside of BigQuery to predict the fare, and evaluate the performance of your model to make predictions.