Applying BigQuery ML's Classification, Regression, and Demand Forecasting for Retail Applications

Applying BigQuery ML's Classification, Regression, and Demand Forecasting for Retail Applications

Google BDL-BQCRDF

USD 49.50
In this quest you will learn how to use several BigQuery ML features to improve retail use cases. Predict the demand for bike rentals in NYC with demand forecasting, leverage regression to estimate the time it will take for a ticket to be solved with the help of an automated agent developed using Dialogflow, and see how to use BigQuery ML for a classification task that predicts the likelihood of a website visitor making a purchase.
 

USD 49.50

Introduction to SQL for BigQuery and Cloud SQL

Module 1

Introduction to SQL for BigQuery and Cloud SQL

Introduction to SQL for BigQuery and Cloud SQL

Google LIS-GOOGLE-2194
USD 9.90
Google
Google Cloud Self-Paced Labs
English
30 days

SQL (Structured Query Language) is a standard language for data operations that allows you to ask questions and get insights from structured datasets. It's commonly used in database management and allows you to perform tasks like transaction record writing into relational databases and petabyte-scale data analysis.

This lab serves as an introduction to SQL and is intended to prepare you for the many labs and quests in Qwiklabs on data science topics. This lab is divided into two parts: in the first half, you will learn fundamental SQL querying keywords, which you will run in the BigQuery console on a public dataset that contains information on London bikeshares.

In the second half, you will learn how to export subsets of the London bikeshare dataset into CSV files, which you will then upload to Cloud SQL. From there you will learn how to use Cloud SQL to create and manage databases and tables. Towards the end, you will get hands-on practice with additional SQL keywords that manipulate and edit data.

See more See less
Implement a Helpdesk Chatbot with Dialogflow & BigQuery ML

Module 2

Implement a Helpdesk Chatbot with Dialogflow & BigQuery ML

Implement a Helpdesk Chatbot with Dialogflow & BigQuery ML

Google LIS-GOOGLE-2249
USD 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
In this lab you will train a simple machine learning model for predicting helpdesk response time using BigQuery Machine Learning.
See more See less
Building Demand Forecasting with BigQuery ML

Module 3

Building Demand Forecasting with BigQuery ML

Building Demand Forecasting with BigQuery ML

Google LIS-GOOGLE-2414
USD 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
In this lab you will build a time series model to forcast demand of multiple products using BigQuery ML. This lab is based on a blog post and featured in an episode of Cloud OnAir.
See more See less
Predict Visitor Purchases with a Classification Model in BQML

Module 4

Predict Visitor Purchases with a Classification Model in BQML

Predict Visitor Purchases with a Classification Model in BQML

Google LIS-GOOGLE-2152
USD 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
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.
See more See less
Predict Taxi Fare with a BigQuery ML Forecasting Model

Module 5

Predict Taxi Fare with a BigQuery ML Forecasting Model

Predict Taxi Fare with a BigQuery ML Forecasting Model

Google LIS-GOOGLE-2154
USD 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
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.
See more See less

* Required Fields