Skip to Content

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

David Smith's picture

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