menu

Create ML Models with BigQuery ML

Fundamental 6 个步骤 7 个小时 34 个积分

Want to build ML models in minutes instead of hours using just SQL? BigQuery ML democratizes machine learning by letting data analysts create, train, evaluate, and predict with machine learning models using existing SQL tools and skills. In this series of labs, you will experiment with different model types and learn what makes a good model. Complete this quest including the the challenge lab at the end to receive an exclusive Google Cloud digital badge. The challenge lab does not provide prescriptive steps, but require solutions to be built with minimal guidance and will put your Google Cloud technology skills to the test!

预备知识:

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)
实操实验

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.

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.

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

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.

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

Create ML Models with BigQuery ML: Challenge Lab

This challenge labs tests your skills in developing and using machine learning models using BigQuery

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

立即注册

注册该挑战任务,系统会全程跟踪进度,直到您赢得徽章为止。