Skip to Content
Author's profile photo Tammy Powlas

Working with Association Analysis SAP Predictive Analytics 2.0 using R

First, there is this nice blog here about how it works with HANA Basket Analysis with SAP Predictive Analysis and SAP HANA – Part 1

I also looked at Wikipedia for Association Rules: Association rule learning – Wikipedia, the free encyclopedia

But if you don’t have HANA, and are unfamiliar, using a text file is an easy way to get started.  This time I am using the Expert Analytics part of Predictive Analytics (although I am not an expert, really)


Figure 1

First I realize that I can’t access any Association algorithms because I haven’t installed R.  Fortunately that is fairly easy and quick in this version.


Figure 2

After installing, you are asked if you want to Configure R – please press OK (and not cancel like I first did)


Figure 3

The only configuration item is to select “Enable Open-Source R Algorithms”.  Select that and click OK


Figure 4

Initially when I launched SAP Predictive Expert Analytics it always took me to the “Visualize” room.  I decided I wanted to go to the Predict room first so I change that in Preferences.


Figure 5

In the Predict room, I select R-Apriori under association and configure as shown above.  I have a CSV file that has products and “baskets” (transactions)


Figure 6

Once the items are “configured” you see a checkbox as shown above.


Figure 7

I run the model without any issues (success) and click OK


Figure 8

The above shows the results view.  I consult wikipedia about Lift and confidence.  A lift of > 1 is useful for predicting, according to Wikipedia Lift (data mining) – Wikipedia, the free encyclopedia


Figure 9

Figure 9 shows the algorithm summary with 17 transactions (baskets) – this is a small dataset.


Figure 10

Figure 10 is a cloud chart which is part of the results set.  The strongest associations are shown in large text size


Figure 11

Figure 11 shows I decide to output the results set to a CSV file so I can try more visualizations of the results.


Figure 12

Figure 12 shows the results using a heat map with Lift as the color


Figure 13

I switch the Lift and Confidence around and now with the size of the rectangle is influenced by Lift and Color is impacted by the confidence of the rule.


Figure 14

I can also try the “related visualizations”


When I hear the word “association” I can’t help but think of the group Association, the a great musical group from the 60’s:

Enjoy the music.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.