Predictive Analytics/Forecasting

Predictive Analytics can be applied to any of your datasets to derive best fit forecasts based on historical data.

This tests a given dataset against a variety of forecasting models to determine the best model best suited to the data based on historical data with the least Sum of Absolute Errors (SAE).

Models used behind the scenes include:

Predictions can be applied to any of your datasets (or during query time) using Cloud9QL.

To predict 1 point in the future:

select PREDICT(<field to predict>, <date field>, <start date for prediction>[, <prediction model>])

To predict multiple data point in the future:

select PREDICT(<Field to Predict>, <Date Field>, <Start Date for Prediction>,
    <Prediction Frequency>, <Prediction Data Points>[, <prediction model>])

This:

Example:

For advanced predictive modeling and machine learning algorithms, including using your own custom prediction models, please contact your account manager.