Machine Learning Times
Machine Learning Times
BizML: Bridging the Gap Between Data Science and Business
  Eric Siegel, author of The AI Playbook, was...
The AI Hype Cycle Is Distracting Companies
 Originally published in Harvard Business Review. Machine learning has...
HR Analytics: Measuring Acquisition, Retention & Satisfaction
 Your firm is growing rapidly, and to maintain pace,...
To Avoid Wasting Money on Artificial Intelligence, Business Leaders Need More AI Acumen
 Originally published in Analytics Magazine, July 19, 2023. Business...

10 years ago
What does Business Intelligence integration with R really mean


Do the BI vendors’ claims really stack up?

“A little prediction goes a long way” wrote Eric Siegel in his popular Predictive Analytics book. True, predictive analytics is now part and parcel of most Business Intelligence (BI), analytics and Big Data platforms and applications.

Forrester Research anecdotal evidence finds that open source R is by far the most ubiquitous predictive analytics platform. Independent findings and surveys like the ones by KDNuggets and RexerAnalytics confirm our conclusions (and I quote) “The proportion of data miners using R is rapidly growing, and since 2010, R has been the most-used data mining tool. While R is frequently used along with other tools, an increasing number of data miners also select R as their primary tool.”

To jump on this R feeding frenzy most leading BI vendors claim that they “integrate with R”, but what does that claim really mean? Our take on this – not all BI/R integration is created equal. When evaluating BI platforms for R integration, Forrester recommends considering the following integration capabilities:

  • Point and click GUI to create R scripts. Since R is a scripting language, does the BI vendor provide point-and-click GUI to generate R code? Beyond just generating code, there’s the whole business of model design, test, management, and execution, which is usually the realm of advanced analytics platforms. How much of these capabilities does the BI vendor provide?
  • Passing variables from BI to R. Can R routines leverage and take advantage of all of the BI metadata (data structures, definitions, etc.) without having to redefine it again just for R? A related question: does the BI vendor provide an open source utility to generate R script headers to facilitate passing variables and parameters to/from BI and R?
  • Passing variables from R to BI. Can the output from R calculations (scores, rankings) be passed back to BI platform and embedded in the BI reports and dashboards? A related question: does the BI vendor provide an open source utility to parse R script and identify variables and parameters to pass to/from BI and R?
  • Intercepting error and other messages from R. Can the BI platform intercept, interpret and act on error messages and alerts from R models/scripts?
  • PMML import/export. Can the BI vendor import/export R models based on PMML?
  • Native execution. What server are R models executed in? R server? BI server? Database server? Natively in a Hadoop server?
  • Content management. Does the BI vendor treat R scripts as part of its metadata and content, and therefore include R scripts in its content management processes such as versioning, migration (from development to test to prod environments, etc)?

Do these sound just about right? Are we missing anything? All comments are welcome.

By: Boris Evelson, Vice President, Principal Analyst serving Application Development & Delivery PROFESSIONALS, Forrester
Originally published at

Leave a Reply