With BigQuery ML, you can build machine learning models without leaving the database environment and training it on massive datasets. We are going to demonstrate common marketing Machine Learning use cases we do at REEA.net to build, train, eval and predict, your own scalable machine learning models using SQL language in Google BigQuery and to address the following use cases:

• Customer Segmentation
• Customer Lifetime Value (LTV) prediction
• Conversion/Purchase prediction

The audience will get first hand experience how to write CREATE MODEL sql syntax to build machine learning models such as:

• Multiclass logistic regression for classification
• K-means clustering
• Import TensorFlow models for prediction in BigQuery

Models are trained and accessed in BigQuery using SQL — a language data analysts know. This enables business decision making through predictive analytics across the organization without leaving the query editor.