Fundamental 5 Steps 小时 25 积分
Want to learn and practice machine learning and build models in minutes instead of hours using just SQL? BigQuery Machine Learning is a new feature in BigQuery where data analysts can create, train, evaluate, and predict with machine learning models with minimal coding. In this series of labs you will experiment with different model types and learn what makes a good model.
Prerequisites:
It is recommended that students have familiarity with SQL and completed the BigQuery Basics for Data Analysts Quest before attempting these labs.Quest Outline
Getting Started with BQML
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.
Implement a Helpdesk Chatbot with Dialogflow & BigQuery ML
In this lab you will train a simple machine learning model for predicting helpdesk response time using BigQuery Machine Learning.