A retail company wants to forecast weekly sales for each of its 500 stores. The data includes historical sales, promotions, holidays, and local weather. The company needs to update forecasts every week with new data. Which ML approach should they use?
Trap 1: Use BigQuery ML to create a linear regression model on historical…
Linear regression does not capture seasonality and temporal patterns effectively.
Trap 2: Export data to AutoML Tables and train a regression model
AutoML Tables is not optimized for time series; it treats each row independently.
Trap 3: Build a custom LSTM model using TensorFlow on Vertex AI Workbench
While possible, it requires more effort and maintenance than a managed service.
- A
Use BigQuery ML to create a linear regression model on historical data
Why wrong: Linear regression does not capture seasonality and temporal patterns effectively.
- B
Use Vertex AI Forecasting to train a time-series model with holiday and weather features
Vertex AI Forecasting is designed for time series with multiple features and supports automatic retraining.
- C
Export data to AutoML Tables and train a regression model
Why wrong: AutoML Tables is not optimized for time series; it treats each row independently.
- D
Build a custom LSTM model using TensorFlow on Vertex AI Workbench
Why wrong: While possible, it requires more effort and maintenance than a managed service.