Analytics anyone can use.
Data prep anyone can use.
Analytics for organizations.
Cloud analytics for organizations.
R is a popular open-source environment for statistical analysis. Tableau Desktop can now connect to R through calculated fields and take advantage of R functions, libraries, packages and even saved models. These calculations dynamically invoke the R engine and pass values to R via the Rserve package, and are returned back to Tableau.
Tableau Server can also be configured to connect to an instance of Rserve through the tabadmin utility, allowing anyone to view a dashboard containing R functionality. Combining R with Tableau gives you the ability to bring deep statistical analysis into a drag-and-drop visual analytics environment.
Read this whitepaper to learn how R functions and R models is used in Tableau (version 8.1 and later).
R is a popular statistical language used to perform sophisticated statistical analysis and predictive analytics, such as linear and nonlinear modeling, statistical tests, time-series analysis, classification, clustering, etc.
The R-console primarily utilizes a command-line interface, but there are many GUI tools available for download to make it easier to write R programs (most of them are free). With R, users can create variables, formulas, functions, and graphs to visualize their analysis and predictions.
As a free, open-source language, there is a community of contributors who continually create new packages (extensions) for R that define advanced statistical functions that were not originally built in to R. These packages can be downloaded into R to expand R’s capabilities. Most of these packages are also developed and made available for free. It is for this reason that R has become so popular and why it continues to gain functionality over time.
R provides a powerful way to do statistical analysis on large sets of data. It is also free, which is a compelling factor to its growth. Because it is open source, new functions and packages are created all the time, so if you can’t find a capability initially, you can search for a package that can do it or even create a package of your own.
However, there are some limitations to R as well. In order to be as flexible as it is, R leverages a command-line interface and uses its own programming language and syntax. It does require some aptitude in coding to take advantage of the many functions. Other non-free, proprietary statistics packages often have graphical user interfaces that are much more friendly and do not require programming skills.¹ These solutions are intended for those users who are not as apt to learn the R programming language, or do not need the sophisticated capabilities that are possible with R.
R functions and models can now be used in Tableau by creating new calculated fields that dynamically invoke the R engine and pass values to R. The results are then returned back to Tableau for use by the Tableau visualization engine.
This feature is primarily targeted for users who are already proficient at R. It is NOT meant for beginners with R. Anyone who wishes to use the new functions must first learn how to use R in order to leverage its capabilities in Tableau.
Users who are already proficient with R will find the integration beneficial for several reasons:
Pre-requisites for using the feature include:
There are four new built-in functions that are used to call specific R models and functions. The functions are:
These functions are distinct only in the type of result they return: a real number, a string, an integer, or a Boolean.
The arguments you pass into each of these functions include R-language scripts and function calls. You can pass 1 or more arguments to R, which are then passed dynamically via Tableau. For instance, you can pass the sales of each customer on a viz.
When using Desktop, you will need to have an R server (via Rserve³) that Tableau can access to successfully call the new functions. Additionally, you can import datasets from R directly into Tableau without using functions or calculated fields.
Tableau Server must be able to communicate with your R server in order for workbooks with R function calls to work. When this is done, you can share workbooks and views with others while still incorporating the results from the R calculations. If there is no R server running that Tableau Server can access, then these workbooks will not be able to show the correct output.
Tableau Online and Tableau Public:
At the current time, Tableau Online and Tableau Public are not supporting R, so the R statistical capabilities will not be available through these services.
Tableau provides several build-in predictive capabilities such as trending and forecasting. You can enhance your forecasting by showing prediction bands with adjustable levels of certainty, as well as forecast multiple measures per pane. In addition, users can use forecasting models with fiscal calendars and/or multiplicative models to give more precision in forecasts. Several R packages provide advanced predictive modeling capabilities, which Tableau customers can leverage with R integration.
Tableau can only integrate with R through the calculated functions described above. This means there are several core capabilities of R that users will not be able to utilize directly in Tableau itself.
For users who are already familiar with R and its capabilities, it is fairly simple to establish the connection between R and Tableau. The instructions below are for new installations using the open-source version of R. Other options may be available using other packages, such as those from Revolution Analytics.
Yes, there are several additional resources that may be helpful in getting started with R and leveraging its capabilities in Tableau.
Tableau and R (Blogs)