Many moons ago in a previous position as a budget analyst I used SAS in previous position to budget and forecast expenses, including workload. Yes, this was on the mainframe. SAS had (still has) great time series analysis functions.
Now I am trying it with Predictive Analysis. Has SAP made this accessible to non-statistician types like me? See below.
In Figure 1, I create a new folder
In Figure 2 create a new Analysis
In Figure 3 I select a .CSV file as a data source
I recommend previewing the data, in case there might be bad characters
Figure 5 execute/run view the visualization
At the prompt, say Yes to the Visualization perspective
Select Adhoc Chart
A familiar interface appears for those using Analysis Office or Design Studio
Open up the Algorithms and select Time Series Exponential Smoothing
Figure 9 select Output Mode, dependent column Expenses, and predict period is 12 months
Figure 10 is the familiar prompt and say Yes
Figure 11 shows the predicted expense values
Figure 12 shows to write the forecast results out to a file
Overall I found this easy to use and I am not a statistician. First I want to thank the many people who helped me including SAP’s Scott Leaver, Vishwanath Belur , and fellow Mentors/IBMers Vijay Vijayasankar and Tomas Krojzl