menu
arrow_back

Getting Started with BQML

Getting Started with BQML

45 minutes 1 Credit

GSP247

Google Cloud Self-Paced Labs

Overview

BigQuery Machine Learning (BQML, product in beta) enables users to create and execute machine learning models in BigQuery using SQL queries. The goal is to democratise machine learning by enabling SQL practitioners to build models using their existing tools and to increase development speed by eliminating the need for data movement.

There is a newly available ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into BigQuery. In this lab you will use this data to create a model that predicts whether a visitor will make a transaction.

What you'll learn

How to create, evaluate and use machine learning models in BigQuery

What you'll need

  • A Browser, such as Chrome or Firefox

  • Basic knowledge of SQL or BigQuery

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Google Cloud Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab
Score

—/100

Create a BigQuery dataset

Run Step

/ 20

Create a model to predict visitor transaction

Run Step

/ 20

Evaluate the model

Run Step

/ 20

Predict purchases per country

Run Step

/ 20

Predict purchases per user

Run Step

/ 20