Forecasting overview
Forecasting is a technique where you analyze historical data in order to make an informed prediction about future trends. For example, you might analyze historical sales data from several store locations in order to predict future sales at those locations. In BigQuery ML, you perform forecasting on time series data.
You can perform forecasting in the following ways:
- By using the
AI.FORECASTfunction with the built-in TimesFM model . Use this approach when you need to forecast future values for a single variable. This approach doesn't require you to create and manage a model. - By using the
ML.FORECASTfunction with theARIMA_PLUSmodel . Use this approach when you need to run an ARIMA-based modeling pipeline and decompose the time series into multiple components in order to explain the results. This approach requires you to create and manage a model. - By using the
ML.FORECASTfunction with theARIMA_PLUS_XREGmodel . Use this approach when you need to forecast future values for multiple variables. This approach requires you to create and manage a model.
In addition to forecasting, you can use ARIMA_PLUS
and ARIMA_PLUS_XREG
models for anomaly detection. For more information, see the following
documents:
- Anomaly detection overview
- Perform anomaly detection with a multivariate time-series forecasting model
Compare ARIMA_PLUS
models and the TimesFM model
Use the following table to determine whether to use TimesFM, ARIMA_PLUS
, or ARIMA_PLUS_XREG
model for your use case:
ARIMA_PLUS
and ARIMA_PLUS_XREG
TimesFM
ARIMA
algorithm for the
trend component, and a variety of other algorithms for non-trend
components. For more information, see Time series modeling pipeline
and publication below.ARIMA_PLUS
or ARIMA_PLUS_XREG
model is trained for each time series.CREATE MODEL
statement and a
function call.CREATE MODEL
statement
offers arguments that let you tune many model settings, such as the
following: - Seasonality
- Holiday effects
- Step changes
- Trend
- Spikes and dips removal
- Forecasting upper and lower bounds
- You want full control of the model including customization.
- You need explainability for model output.
- You want minimal setup -- doing forecast without creating a model first.
Recommended knowledge
By using the default settings of BigQuery ML's statements and functions, you can create and use a forecasting model even without much ML knowledge. However, having basic knowledge about ML development, and forecasting models in particular, helps you optimize both your data and your model to deliver better results. We recommend using the following resources to develop familiarity with ML techniques and processes:
