Tuesday, July 5, 2016

Advanced Analytics in Oracle DV

Yes, Oracle DV gives you advanced analytics literally at the click of a button. Advanced analytics operations such as clustering, outlier detection, trend lines and forecast are built-in, and they can be simply dragged dropped on to your charts.

However access to advanced analytics is not limited to these functions exposed in the UI. You can leverage the advanced analytics framework to invoke any custom R function and seamlessly blend its results with rest of your analysis. The EVALUATE_SCRIPT function of Oracle DV can be used to execute an R script registered in the script repository.  Its powerful and easy to use.
For example, this video shows an example of using custom R script to decompose a time series data to its seasonal, trend and remainder components.




Following video is another example where use R to perform market basket analysis (rule mining) on fast foods transactions data.



Take a look at some of these examples downloadable from Oracle DV samples page on OTN.

4 comments:

mounika said...

Very nice article
Oracle SOA Online Training

Ruby Gracie said...

I was very interested in the article, it’s quite inspiring I should admit. I like visiting your site since I always come across interesting articles like this one. Keep sharing! Regards. Read more about Big data Services

Jennifer N said...

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

Unknown said...

the graphs show me a query error:
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
(HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
(HY000)
State: HY000. Code: 47092. [nQSError: 47092] The value of R_EXECUTABLE_PATH is set to C:\Program Files\R\R-3.1.1\bin\x64\R which is invalid. (HY000)
SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY = 1; SELECT
0 s_0,
XSA('weblogic'.'ORCL_STOCK')."Columns"."TIMESTAMP" s_1,
EVALUATE_SCRIPT('filerepo://obiee.TimeSeriesDecompose.xml','seasonal','metric=%1;series_date=%2;',XSA('weblogic'.'ORCL_STOCK')."Columns"."CLOSE",XSA('weblogic'.'ORCL_STOCK')."Columns"."TIMESTAMP") s_2,
REPORT_AGGREGATE(EVALUATE_SCRIPT('filerepo://obiee.TimeSeriesDecompose.xml','seasonal','metric=%1;series_date=%2;',XSA('weblogic'.'ORCL_STOCK')."Columns"."CLOSE",XSA('weblogic'.'ORCL_STOCK')."Columns"."TIMESTAMP") BY ) s_3
FROM XSA('weblogic'.'ORCL_STOCK')
FETCH FIRST 5000001 ROWS ONLY

do you know why? i saved the .xml file in the correct folder anyway.

Post a Comment