You're reading from Machine Learning with BigQuery ML Create, execute, and improve machine learning models in BigQuery using standard SQL queries

Product type Paperback

Published in Jun 2021

Publisher Packt

ISBN-13 9781800560307

Length 344 pages

Edition 1st Edition

Languages

Python

Tools

BigQuery

Concepts

Machine Learning

Author (1):

Alessandro Marrandino

View More author details

Table of Contents (20) Chapters

Preface

1. Section 1: Introduction and Environment Setup

2. Chapter 1: Introduction to Google Cloud and BigQuery FREE CHAPTER

3. Chapter 2: Setting Up Your GCP and BigQuery Environment

4. Chapter 3: Introducing BigQuery Syntax

5. Section 2: Deep Learning Networks

6. Chapter 4: Predicting Numerical Values with Linear Regression

7. Chapter 5: Predicting Boolean Values Using Binary Logistic Regression

8. Chapter 6: Classifying Trees with Multiclass Logistic Regression

9. Section 3: Advanced Models with BigQuery ML

10. Chapter 7: Clustering Using the K-Means Algorithm

11. Chapter 8: Forecasting Using Time Series

12. Chapter 9: Suggesting the Right Product by Using Matrix Factorization

13. Chapter 10: Predicting Boolean Values Using XGBoost

14. Chapter 11: Implementing Deep Neural Networks

15. Section 4: Further Extending Your ML Capabilities with GCP

16. Chapter 12: Using BigQuery ML with AI Notebooks

17. Chapter 13: Running TensorFlow Models with BigQuery ML

18. Chapter 14: BigQuery ML Tips and Best Practices

19. Other Books You May Enjoy

Introducing the business scenario

Imagine being a business analyst that works for the Google Merchandise e-commerce store. The website sells different Google-branded products to different users. Some of the users are registered and have their own identifier, and their clickstream activities are collected in a specific dataset.

Important note

Clickstream data is the digital footprint left by users navigating a specific website. This data typically includes the web pages they visited, the time they spent on each page, the device they used, the origin of the traffic, and other relevant information.

In this scenario, the data is collected by Google using Google Analytics 360 from the Google Merchandise e-commerce portal. This tool can be integrated with any website and allows us to gather information about the users' behavior on each page of the portal for further analysis and analytics.

The following screenshot is of the Google Merchandise Store, which sells Google-branded...

The rest of the chapter is locked

You're reading from Machine Learning with BigQuery ML Create, execute, and improve machine learning models in BigQuery using standard SQL queries

Table of Contents (20) Chapters

Introducing the business scenario

Authors (1)

Other recommended products

Personalised recommendations for you

You're reading from Machine Learning with BigQuery ML Create, execute, and improve machine learning models in BigQuery using standard SQL queries

Table of Contents (20) Chapters

Introducing the business scenario

Unlock this book and the full library FREE for 7 days

Authors (1)

Other recommended products

Personalised recommendations for you