Google Cloud Skills Boost

BigQuery for Machine Learning

5 hours Introductory universal_currency_alt 2 Credits
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 to receive an exclusive Google Cloud digital badge.
Badge for BigQuery for Machine Learning

Complete this activity and earn a badge! Boost your cloud career by showing the world the skills you’ve developed.

  • Lab

    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.

  • Lab

    Predict Visitor Purchases with a Classification Model in BigQuery ML

    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.

  • Lab

    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.

  • Lab

    Bracketology with Google Machine Learning

    In this lab you use Machine Learning (ML) to analyze the public NCAA dataset and predict NCAA tournament brackets.

  • Lab

    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.

  • info
    Quest Info
    It is recommended that students have familiarity with SQL and completed the BigQuery Basics for Data Analysts Quest before attempting these labs.
    Available languages
    English, português (Brasil), 日本語, français ve español (Latinoamérica)
    Bu görevi tamamladıktan sonra ne yapmam gerekiyor?
    Bu görevi tamamladıktan sonra öğrenim yolunuzdaki ek içerikleri keşfedebilir veya öğrenim kataloğuna göz atabilirsiniz
    Hangi rozetleri kazanabilirim?
    Bir görevi tamamladığınızda tamamlama rozeti kazanırsınız. Bazı görevlerde, son bir değerlendirme olarak yarışma laboratuvarı bulunur. Görevde edindiğiniz bilgiler, bu laboratuvarda uygulamalı olarak test edilir. Bu görevlerde beceri rozeti kazanırsınız. Rozetler profilinizde görünür ve sosyal ağlarınızda paylaşılabilir.