Google Cloud Skills Boost

Applying BigQuery ML's Classification, Regression, and Demand Forecasting for Retail Applications

6 hours Advanced universal_currency_alt 25 Credits
In this quest you will learn how to use several BigQuery ML 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 BigQuery ML for a classification task that predicts the likelihood of a website visitor making a purchase.

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

  • Lab

    Introduction to SQL for BigQuery and Cloud SQL

    In this lab you will learn fundamental SQL clauses and will get hands on practice running structured queries on BigQuery and Cloud SQL.

  • Lab

    Implement a Helpdesk Chatbot with Dialogflow & BigQuery ML

    In this lab you will train a simple machine learning model for predicting helpdesk response time using BigQuery Machine Learning.

  • Lab

    Building Demand Forecasting with BigQuery ML

    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.

  • Lab

    Predict Visitor Purchases with a Classification Model in BQML

    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.

  • Lab

    Predict Taxi Fare with a BigQuery ML Forecasting Model

    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.

  • info
    Quest Info
    Available languages
    English
    What do I do when I finish this quest?
    After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.
    What badges can I earn?
    Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.