Machine Learning Model in Google sheets using BigQuery ML
As we face challenges in bringing data to/from data-warehouses during machine learning modeling especially on a daily basis, Google cloud platform (GCP) has reduced the process & time consumption by providing BigQuery ML (BQML), an extension of BigQuery – an Enterprise Data Warehouse (EDW). BigQuery ML brings the ML model to the database rather than data. Also, you can use simple SQL Queries to create an ML model, which empowers data analysts. In this session, we have discussed Introduction to BigQuery & BigQuery ML, Real-time customer Use-cases & compared ML process with & without BigQuery ML. We have also included a demo using Google’s workspace (Google Sheets) to get connected to BigQuery using Apps script Editor & doing a time-series forecasting(ARIMA) on a sample dataset.