Tableau with R - The connection
Prateek Kale
Data Engineer , ETL , Data Modeling , Big Data Pipeline Solution Lead @WhizAI , Data Analysis , SQL , Python, Airflow dynamic , Druid and scalable workflow development| Helping Data to produce valuable insights.
Hi , In my First article of tableau with R i am going to discuss about how we make connection from tableau to R and leverage functionality of R within 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.
1. Download and Install R. Click here to find the file and instructions on downloading R.
2. Once you have installed R, Open R console.
3. Download and Install Rserve. You will need to install an Rserve for Tableau to connect to in order to utilize the new script functions. In the R console, enter the following commands:
>install.packages(“Rserve”)
>library(Rserve)
>Rserve()
4. Once Rserve is installed, open Tableau Desktop and follow the steps below:
a. Go to the Help menu and select “Setting and Performance” -> “Manage external service connection”.
b. Enter a server name of “localhost” (or “127.0.0.1”) and a port of “6311”.
c. Click on the “Test Connection” button to make sure everything runs smoothly. You should see a successful message. Click OK to close.
Now we are done with Tableau to connect with R , We will see how to execute R functions from tableau in Next Article.
Application Development Specialist at Accenture
7 年Informative article
Manager, Data Analytics @ AirAsia | ITIL 4 Foundation Certified | Tableau & Google Cloud Certified
7 年Very nice article. Please share more articles on analyzing data using R and Tableau