Important: You might need additional GCP permission to use BigQueryML in Connected Sheets. For more info, visit the BQML reference documentation here.
To directly generate data forecasts and predict key business metrics, you can now use BigQuery ML with TimesFM models directly from Connected Sheets.
You can:
- Create forecasts with BQML in Connected Sheets using the TimesFM model.
- Configure inputs and customize settings with the Forecast creator interface.
- Skip model creation and training and use Google’s TimesFM model, pre-trained on billions of real-world data points.
This feature includes:
- Simple configuration: Create forecasts from any BigQuery dataset or custom query with a user-friendly configuration panel in the Sheets UI.
- Customizable parameters: Adjust forecast parameters like prediction horizon and confidence intervals. Filter input data to only predict based on subsets of historical data. Default options are available.
- Granular analysis: Break out data into multiple forecasts based on any data dimension. For example, forecasts of sales broken out by region.
- Visual insights: Automatically generate a chart for single time-series forecasts. This chart visualizes the forecast and can optionally include historical data.
Generate forecasts in Connected Sheets
The forecast data displays in a new sheet. For a single time-series forecast, Google Sheets automatically creates a chart that visualizes the forecast alongside historical data.
- On your computer, open Google Sheets.
- Select an existing Connected Sheet or create a new connection to BigQuery data.
- To create a new connection to BigQuery data, in the menu at the top, click Data
Data Analytics
- To create a new connection to BigQuery data, in the menu at the top, click Data
- Click Advanced analytics
.
- From your connection’s dataset, select a time series.
- You can automatically aggregate data points in different time windows. To see all options, next to "Group by Day," click the Down arrow
.
- You can automatically aggregate data points in different time windows. To see all options, next to "Group by Day," click the Down arrow
- Select a prediction column. This will be the value you wish to forecast.
- To change the aggregation method, next to "Aggregate by Sum," click the Down arrow
- To change the aggregation method, next to "Aggregate by Sum," click the Down arrow
- Optional: To add a breakout, click Add breakout
. This creates unique forecasts for each value in this column. For example, one forecast for every region in the dataset.
- Select an option from the dropdown.
- Under the "Enter horizon" field, enter a number. This determines how far in advance your data will be forecasted.
- The forecast interval is automatically determined by the time series aggregation, if any.
- This field has a max value of 10,000.
- Optional: To filter input data, next to "Filter input data," click Add
- Select an option from the dropdown.
- Under "Data output options," choose:
- Include historical data. To help you identify trends, this option lets you match historical data with your forecast.
- Include prediction levels. Lower and upper bounds of the forecasted value appear in additional columns.
- Modify your forecast confidence level if desired. The default value is 95%.
- Click Create.
- Sheets runs the query and creates your forecast. To edit any inputs and re-run a forecast, click the generated forecast. This opens the Forecast Editor panel.
Data Analytics 
.