Introduction

SAP Analytics for cloud is cloud SaaS based Business Intelligence tool provided by SAP. It was formerly known as BusinessObjects for cloud. It provides all the key functionalities of an Analytics tool to SAP business users. SAP Analytics cloud provides prediction as an inbuild  functionality.

For this example, we will be using a sales data source from Kaggle. For information Kaggle, a subsidiary of Google LLC, is an online community of data scientists and machine learning practitioners. Kaggle allows users to find and publish data sets, explore, and build models in a web-based data-science environment, work with other data scientists and machine learning engineers, and enter competitions to solve data science challenges.

This model will be useful for the organisations to predict their future sales data and plan for profit over the years. Source data we use here will the historical data for sales and with Time Series Forecast Prediction Scenario we are going to predict the future sales.

Sales Forecasting on SAC Classification:

The version of SAC used here is 2021.20. SAC is integrated with Machine Learning Algorithms by using this we can perform Smart Predictions. As mentioned before, in this model we going to predict and forecast the sales data.

Now, let’s start creating the model step by step.

Importing the data set

Go to the data set tab and click on the Create New from a CSV or Excel file and import the sales data.

 

Sales%20dataset

Sales data set

Data set Overview

After importing the data, you can now be able to see the raw data in the middle and overview of the data in the right-side panel. The right-side panel display the total number of rows and columns we have with the raw data.

Dataset%20Overview

Data set Overview

 

Now switch to Columns tab to get more details about each column. The column view consists of Dimension Properties, Data Type, statistical type, data distribution and validation.

 

Statistical%20type

Statistical type

SAC has a functionality to automatically detect the data type and Statistical type. In some cases, SAC may fail to detect the data. So, it is always recommended to check the data type and statistical type and manually make changes if needed.

Statistical types and their purpose.

  1. Nominal : Unordered, discrete values (ex. Categories)
  2. Ordinal : Sortable, discrete values (ex. rankings)
  3. Continuous : Numerical, sortable, continuous values (ex. salaries, dates)
  4. Textual : Nominal values containing text (ex. sentences)

Once all details been checked Save the data set.

Create Predictive Scenario

Navigate to the Predictive Scenario tab and select Time Series Forecast since we want to forecast the sales data with respect to historical data.

For simple understanding, you want to forecast numerical values over a time period taking into account variables that may or may not be correlated.

Example: Forecast the volume of ice cream sold by a retailer for a future period using historical sales information, along with month and temperature data as variables that influence demand.

Time%20Series%20Forecast

Time Series Forecast

Create a Predictive model with the sales data. Select Sales data in Time Series Data Source.

In Predictive Goal for Target select the field to be predicted based on Date. Specify the Number of Forecast Periods. For this example, let’s select 5.

Predictive%20Goal

Predictive Goal

In Predictive model training select Train Usage. Either we can choose All Observation or Window of Observation.

Train Usage is used to define the range of observations that will be used to train the predictive model. For example, you may want to ignore very old observations to avoid that your predictive model learns based on an obsolete behavior.

For this example, let’s select Window of Observation and provide Window Size as 5 and for Years and Until as Last Observation.

Predictive%20Model%20Training

Predictive Model Training

Now click on Train and Forecast. The model will be trained and forecast the prediction.

After successful training of model forecast will be displayed.

MAPE % for the trained model is 0.87%. Any MAPE% <10 will be considered as Very Good.

MAPE % Interpretation
< 10% Very Good
10% – 20% Good
20% – 50% Ok
>50% Not Good

 

Forecast

Forecast%20vs.%20Actual

Forecast vs. Actual

Forecasts

Forecasts

Conclusion

This Blog shows step by step procedure to create a Time Series Forecast Prediction Scenario in SAP Analytics Cloud. I hope this blog help to understand the SAC Prediction with Time Series Forecast.

Thanks !

Sara Sampaio

Sara Sampaio

Author Since: March 10, 2022

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x