ML Study Jam — Forecasting model in BQML

Predict Taxi Fare with a BigQuery ML Forecasting Model

What is ML Study Jam?

A free machine learning program using Qwiklabs.

What is BigQuery?

BigQuery is Google’s fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage, or needing a database administrator.

BigQuery Machine Learning (BQML, product in beta) is a new feature in BigQuery where data analysts can create, train, evaluate, and predict with machine learning models with minimal coding.

The flow of BigQuery ML Forecasting

The flow of ML forecasting is like the flowchart above.

1. Select valuable fields from your raw data table for predictions.
2. Choose a suitable classfication model to train your model.
3. Evaluate the model performance.
4. If the model performance is not good enough, try to filter the data or change the needed table column.
5. If the model is good enough, use it to predict data.
6. Get the predictions.