/machine-learning-bigquery-gcp

These SQL are based on available ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into BigQuery.

Applying Machine Learning with Google Cloud Platform

These SQL are based on available ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into BigQuery.

Predicting Ecommerce Visitor Purchases with a Classification Model

  1. Out of the total visitors who visited our website, what % made a purchase?
  2. What are the top 5 selling products?
  3. How many visitors bought on subsequent visits to our website?
  4. What are the risks of only using the above two fields?

Classification Models

  1. Creating a classification model
  2. Evaluating the classification model performance
  3. Improve performance
  4. Predict which new visitors will come back and purchase