Monday, December 19, 2016

Advanced Analytics: Association Rule Mining on OracleDV using Custom R-Scripts

Association Rule Mining is a common technique used to find associations between many variables. It is intended to identify strong rules existing in data using some measures of interestingness. It is often used by grocery stores to perform Market Basket Analysis(MBA), and used by online stores to provide suggestions for purchases. 

Do you have a transactional detaset with you and would like to perform Association Rule Mining on it? You can do it very easily on OracleDV using Rule mining Custom R-Script. The R-script returns association rules in a tabular format with Support, Confidence and Lift associated with each rule. This list of association rules can also be exported/downloaded to excel format. You can also use the script in Dataflows by saving the Rule set generated from your data and consume it as a source in the dataflow. In this blog we will discuss how you can deploy this R-Script and perform Rule Mining on OracleDV Desktop.

Steps to deploy:

1) Install Advanced Analytics feature in Oracle DV by clicking on the below icon. This will install Oracle R deployment. Alternatively you can install Advanced Analytics by running install_advanced_analytics.cmd present in <DV_INSTALL_DIRECTORY>


2) If not installed arules R-Package already, please install it using following instructions
    Open R console(double click Rgui.exe present in <Advanced_Analytics_Install_Dir>\bin\x64) and
    install arules Package.
    Following are the R commands to install:
     Set Proxy:
        $ Sys.setenv(http_proxy="<your_proxy_host>:<port_number>")
           set proxy appropriate to your network config.
     Install Package:
        $ install.packages("arules")

3) Download Association_Rule_Mining_V1.zip from OracleBI Public Store and unzip it.
4) Copy R.RuleMining.xml to <DV_INSTALL_DIRECTORY>\OracleBI1\bifoundation\advanced_analytics\script_repository
5) Import the .dva project to Oracle DV. Password for the .dva is Admin123

Here is a snapshot:

Are you an Oracle Analytics customer or user?

We want to hear your story!

Please voice your experience and provide feedback with a quick product review for Oracle Analytics Cloud!
 

6 comments:

amarnath said...

The link doesn't exist / is not available in the newest link. Where can we download this fine?

Unknown said...

https://aimotion.blogspot.com/2013/01/machine-learning-and-data-mining.html?showComment=1531834155506#c3289419777881658447

Unknown said...


Great post dear. It definitely has increased my knowledge on Python. Please keep sharing similar write ups of yours. You can check this too for Python tutrial as i have recorded this recently on Python. and i'm sure it will be helpful to you.https://www.youtube.com/watch?v=gXb9ZKwx29U

Unknown said...

Thank you for sharing wonderful information with us to get some idea about that content. check it once through
Best Machine Learning Training in Chennai | best machine learning institute in chennai | Machine Learning course in chennai

lost_in_woods said...

nice blog , very helpful and visit us for VISUALIZATION SERVICES in USA

Unknown said...

This was very informational, also if you want to learn tableau then we have some best tableau courses that can be taken.

Post a Comment