AIssisted Prediction Preview for Sales Planning

image_pdfimage_print

When you make a forecast, the AIssisted Predicted Forecasting Wizard takes your source data and calculates prediction data. The AIssisted Predictive Preview then shows these two data types for comparison—complete with table, graph, and accuracy percentage.

Once you have defined a particular area of a cube using the Predictive Forecasting Wizard, the Predictive Preview shows the figures of the data populating this area. Choose the Measure and Comparison version from the comboboxes to compare them with the prediction data.

The below example shows the predicted forecast for gross revenue, with Actual chosen as the comparison dimension:

You see the predicted values along with their upper and lower bounds, and the comparison version shown in orange. You can show different data by choosing a different Measure or Comparison version from the combo boxes. If you select a measure other than Actual, a blue line will appear depicting the Actual measure. (You can hide a line in the graph by clicking on the corresponding, color-coordinated labels below the graph).

Here is an example of a prediction forecast for the months of 2018 with the Comparison version set to Budget:

The fields and functionality of the Predictive Preview are described below:

Field Description
Measure (combobox) Choose the Measure element you wish to use for your predictive forecast (e.g. Gross Revenue). You can select different measure elements to show different prediction results.
Comparison Version (combobox) Choose the Comparison version element you wish to use to compare to your prediction data (e.g. Actual). You can select different Comparison Version elements to compare the predicted data to different things (if you would like to compare the accuracy of prediction of a given measure from the Actual to the Budget, for instance). 
Reset (button) The Reset button resets the duration of the your prediction to your original specification (e.g. 6 months, 01-06, 2018).
+ 3 months (button)

The +3 months button increases the duration of your prediction by addíng three previous months of data to your prediction (e.g. 09-12. 2017). The +3 months button increases the number of data points shown on the graph, allowing you to see the previous three months of data for comparison with the historical data (e.g. 09-12. 2017). If you have additional prediction data in the cube for these dates, this will likely alter the accuracy of your prediction.

Actual (source) This is the actual figures for the duration of your prediction. It is what your prediction compares itself to determine its accuracy.  The source is always the data you entered from the Version dimension, e.g. Actual, and will always be expressed in the table and graph. If the Comparison verison is not actual data, the actual data will be expressed as a blue line. 
[Actual] (comparison) This is a dynamic figure that compares to the predicted forecast. Note: If you change the Comparison version element  this change will reflect itself in the table and graph (e.g. if you change the Comparison version from Actual to Budget, the field in the table will become Budget (comparison) and Budget will be shown in the graph.
Prediction The prediction is the forecasted data produced by the AIssisted Planning Workflow Wizard.
Prediction_lower This is the lower bounds of your prediction data, i.e the lowest point your data is expected to sink below the predicted forecast.
Prediction_upper This is the upper bounds of your prediction data, i.e. the  highest point your data is expected to rise above the predicted forecast.
Accuracy The relative accuracy of your prediction and its Comparison version expressed as a percentage (e.g. the prediction above has anaccuracy of 86.29%  compared to the Budget data above).

Please note: although you can make a predictive forecast based on fewer than 36 months of data, we strongly suggest 36 months as a minimum for optimal accuracy.

image_pdfimage_print