Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.


BigQuery for Machine Learning

Google via Qwiklabs


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. Looking for a hands on challenge lab to demonstrate your skills and validate your knowledge? On completing this quest, enroll in and finish the additional challenge lab at the end of this quest>/a> to receive an exclusive Google Cloud digital badge.


  • Getting Started with BigQuery Machine Learning
    • 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.
  • 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.
  • 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.
  • Bracketology with Google Machine Learning
    • In this lab you use Machine Learning (ML) to analyze the public NCAA dataset and predict NCAA tournament brackets.
  • Integrating BigQuery ML with Dialogflow ES Chatbot
    • In this lab you will train a simple machine learning model for predicting helpdesk response time using BigQuery Machine Learning.


Start your review of BigQuery for Machine Learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.