See R integrated with QlikView, Jaspersoft, Excel, and mobile apps

[This article was first published on Revolutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

In yesterday's webinar, Revolution Analytics CTO David Champagne demonstrated how to integrate statistical graphics and analytic computations created using R software with a variety of third-party applications. In each case Revolution R Enterprise Server is running as a compute server to the client application, with R scripts launched on each user interaction via the RevoDeployR Web Services API. David demonstrated five examples of such integration (watch the demo by clicking on the links below, and switch to full-screen for easier viewing).

David showed three different ways of delivering interactive sales forecasts in client applications:

  • An HTML 5 application that offers sales forecasts based on a user-selected history from product sales data. This type of interface would be suited to mobile devices like an Android smartphone or iPad. 
  • An enhanced QlikView report, including a sales forecast from patio furniture sales data, with options for the type of forecast model and with data visualization from both R and QlikView.

David also showed two examples where the end-user has even more control over the parameters of the analytic computation:

  • custom interactive web-application written in JavaScript, to perform market basket analysis on retail transaction data. The distribution of purchases is rendered on an interactive map, and products commonly purchased together (within a selected sub-region) are displayed as a tree chart and as association rules. 
  • A Microsoft Excel spreadsheet, with a custom toolbar button that displays a regression dialog, with the regression results (from R) embedded directly in the same spreadsheet the source data was taken from.

The great thing about integrating R into client applications in this way is that:

  • The R computation is run on-demand, and with the results presented in context to the end user;
  • The end user doesn't need to know R (in fact, they're probably don't even know R is involved), while still providing some control over the computation done in R.
  • R doesn't need to be installed on the client device. In fact, Revolution R Enterprise will most likely be running on a dedicated remote server, in a data center or even in the cloud.

You can see David's entire presentation (including details about the client/server architecture and the Web Services API that makes all of this possible) in the webinar replay below, or by downloading the webinar slides.


Revolution Analytics webinars: Calling All Data Scientists and Web Developers! Integrate Your Advanced Analytics into BI Apps and MS Office and Multiply Their Value

To leave a comment for the author, please follow the link and comment on their blog: Revolutions. offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)