Machine learning is an amazingly powerful tool — and a tool that should be available to as many practitioners as possible. BigQuery ML puts the power of machine learning into the hands of SQL users. In this hands-on lab, you’ll use BigQuery ML to create, evaluate, and predict the likelihood that a visitor to a particular site will make a transaction, all based on a public dataset.
Successfully complete this lab by achieving the following learning objectives:
- Create the BigQuery Dataset
Create the dataset in BigQuery.
- Create and Train the ML Model
Run a SQL function to create and train a logistic regression model.
- Evaluate the ML Model
Evaluate the predicted values against the current data via SQL.
- Predict Using the ML Model
Use BigQuery ML SQL to predict the number of transactions for various countries.