Skip to Content

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.

/wp-content/uploads/2012/09/1fig_139518.png

Figure 1

In Figure 1,  I create a new folder

/wp-content/uploads/2012/09/2fig_139519.png

Figure 2

In Figure 2 create a new Analysis

/wp-content/uploads/2012/09/3fig_139520.png

Figure 3

In Figure 3 I select a .CSV file as a data source

/wp-content/uploads/2012/09/4fig_139521.png

Figure 4

I recommend previewing the data, in case there might be bad characters

/wp-content/uploads/2012/09/5fig_139522.png

Figure 5

Figure 5 execute/run view the visualization

/wp-content/uploads/2012/09/6fig_139523.png

Figure 6

At the prompt, say Yes to the Visualization perspective

/wp-content/uploads/2012/09/7fig_139524.png

Figure 7

Select Adhoc Chart

A familiar interface appears for those using Analysis Office or Design Studio

/wp-content/uploads/2012/09/8fig_139525.png

Figure 8

Open up the Algorithms and select Time Series Exponential Smoothing

/wp-content/uploads/2012/09/9fig_139526.png

Figure 9

Figure 9 select Output Mode, dependent column Expenses, and predict period is 12 months

/wp-content/uploads/2012/09/10fig_139447.png

Figure 10

Figure 10 is the familiar prompt and say Yes

/wp-content/uploads/2012/09/11fig_139529.png

Figure 11

Figure 11 shows the predicted expense values

/wp-content/uploads/2012/09/12fig_139530.png

Figure 12

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


To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Gregory Misiorek

    Hi Tammy,

    nice overview, but i was wondering how it compares to what you have done in SAS. we all know that “there are lies, damn lies, and then there’s statistics”, but have you ever seen statistics used for financial statements?

    thx,

    greg

    (0) 
    1. Tammy Powlas Post author

      I am only comparing it to the budgeting side where in a previous position we used SAS time series analysis to forecast expenses.

      Also in a previous position we manually programmed SAS financial ratios; things have changed a great deal in that area. 

      I still remember the SAS statements

      Tammy

      (0) 
  2. Fred Verheul

    Hi Tammy,

    Thanks for sharing all your try-outs/demos of new products with the community, and doing it in great style too!

    This one certainly looks like a nice solution. Would love to get my hands on it 🙂 .

    Cheers, Fred

    (0) 
  3. Christian Happel

    Hi Tammy,

    I’m making myself familiar with HANA Studio and Predictive Analysis at the moment.

    If I understand correctly one has to manually select the forecasting algorithm (both in P.A. as well as in HANA Studio). Is that correct?

    If so I don’t really understand it. Shouldn’t P.A. be so smart to automatically pick the best forecasting algorithm for the given data set? Or at least suggest one?

    Thanks, Christian

    (0) 
    1. Tammy Powlas Post author

      Thanks for reading

      There are some trends it will pick up out of the box; I suppose I should have started with that

      Others you do have to select, you are right.

      I am new to the tool myself

      I will explain in the next blog

      Tammy

      (0) 

Leave a Reply