BigQuery for Machine Learning

Fundamental 5 Steps 시간 25 크레딧

Want to learn and practice machine learning and build models in minutes instead of hours using just SQL? BigQuery Machine Learning is a new feature in BigQuery where data analysts can create, train, evaluate, and predict with machine learning models with minimal coding. In this series of labs you will experiment with different model types and learn what makes a good model.

Data Business Transformation Machine Learning


It is recommended that students have familiarity with SQL and completed the BigQuery Basics for Data Analysts Quest before attempting these labs.

Quest Outline


Getting Started with BQML

In this lab you'll learn how to use BigQuery to create machine learning models for datasets to create a model that predicts whether a visitor will make a transaction.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)

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.

Deutsch English español (Latinoamérica) français 日本語 português (Brasil)

BigQuery ML 예측 모델을 사용하여 택시 요금 예측하기

이 실습에서는 BigQuery 공개 데이터세트에서 제공되는 수백만 건의 뉴욕 옐로캡 택시 운행 데이터를 살펴보고, BigQuery 내에서 ML 모델을 생성하여 요금을 예측하며, 이러한 예측을 수행하는 모델의 성능을 평가해봅니다.

Deutsch English español (Latinoamérica) français 日本語 한국어 português (Brasil)

Bracketology with Google Machine Learning

In this lab you use Machine Learning (ML) to analyze the public NCAA dataset and predict NCAA tournament brackets.


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.

Enroll Now

Enroll in this quest to track your progress toward earning a badge.