Experimenting with GCP - Bigquery creating ML model. Tutorial for self learning purpose only.
For more details & instructions - https://cloud.google.com/bigquery-ml/docs/bigqueryml-web-ui-start
1 Using BigQuery create a regression model using public datasets predict whether a website visitor will make a transaction
-
create model SQL command
-
Evaluate your model
-
Predict model on the number of visitors from different countries will maka a transaction.
Create a logistic regression model using Google Analytics Sample dataset for BigQuery. This create model command trains the model using the data retrieved from select command.
It runs few iterations.
Model statistics displayed in Graph. There is also Table format available.
Evaluate the model - Lables are 0 and 1 which represents no transactions and transactions made
This query provides the prediction for website visitors from each country and number of transactions made.
