- \n
- Download and install software:<\/li>\n<\/ul>\n
To integrate R with Tableau, we would need R Studio:<\/p>\n
R download link: https:\/\/cran.r-project.org\/bin\/windows\/base\/<\/a><\/p>\n
R Studio download link: https:\/\/www.rstudio.com\/products\/rstudio\/download\/<\/a><\/p>\n
We would also need Tableau desktop: https:\/\/www.tableau.com\/products\/desktop<\/a><\/p>\n
- \n
- Open R Studio and Type below commands on R command line:<\/li>\n<\/ul>\n
install.packages(“Rserve”);<\/p>\n
library(Rserve);<\/p>\n
Rserve()<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/1.-Install-Rserve.png?resize=414%2C174&ssl=1\")
<\/p>\n- \n
- Open Tableau desktop and goto Help Menu -> Settings and performance -> Manage External Service Connection<\/li>\n<\/ul>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/2.-Connect-Tableau-with-Rserve.png?resize=300%2C204&ssl=1\")
<\/p>\n- \n
- \u00a0Select Localhost and port 6311<\/li>\n<\/ul>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/3.-Configure-the-connection.png?resize=264%2C192&ssl=1\")
<\/p>\n- \n
- Test Connection and Ok.<\/li>\n<\/ul>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/4.-Test-Connection.png?resize=300%2C86&ssl=1\")
<\/p>\nDevelopment of Linear Regression Model:<\/strong><\/p>\n
After integrating RServe and Tableau, we are all set to embed the R code for linear regression model creation into R calculated fields.<\/p>\n
The sample data used here is an open source data available for download from Duke university\u2019s website: http:\/\/www2.stat.duke.edu\/~mc301\/data\/movies.html<\/a><\/p>\n
The data contains a sample of 651 movies, their reviews, critics score etc. (The data dictionary is also present at above link).<\/p>\n
Let us try to develop a regression model to predict the audience score from various other dependent variables like IMDB Rating or Critics Score.<\/p>\n
We will first analyze the relationships among these variables via a scatter plot among them in Tableau:<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/5.-Scatter-plot-of-Variables.png?resize=300%2C190&ssl=1\")
<\/p>\n<\/p>\n
Above figure shows two plots:<\/p>\n
IMDB votes Vs Audience Score<\/p>\n
Critics Score Vs Audience Score<\/p>\n
Clearly, Critics Score seems to have a greater linear relationship with Audience Score. That simply means that Critics Score is a better predictor of Audience Score rather than IMDB Votes.<\/p>\n
Let us write a calculated field called \u201cPredicted Audience Score\u201d<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/6.-Regression-Model.png?resize=300%2C175&ssl=1\")
<\/p>\nTableau\u2019s SCRIPT_REAL function can be used to embed R or Python code in Tableau\u2019s calculation.<\/p>\n
Here we have used Critics Score to Predict Audience Score.<\/p>\n
Let us plot the Predicted Audience Score Vs Audience Score.<\/p>\n
![\"\"](\"https:\/\/i0.wp.com\/sprintmilestone.com\/blog\/wp-content\/uploads\/2017\/10\/7.-Predicted-Values.png?resize=395%2C362&ssl=1\")
<\/p>\nAs can be seen clearly the plot of the Predicted Audience Score Vs Audience Score comes out as a perfect straight line.<\/p>\n
\u00a0<\/strong><\/p>\n
Conclusion:<\/strong><\/p>\n
Given above is a very basic example of achieving a simple linear regression model using Tableau and R.<\/p>\n
The advanced and much more sophisticated Linear regression model has been developed in R and can be located at below GitHub URL:<\/p>\n
https:\/\/github.com\/shashibhushan86\/Linear_Regression\/blob\/master\/reg_model_project.Rmd<\/a><\/p>\n
<\/p>\n
Get started with a Tableau Desktop Trial<\/a> today<\/p>\n
<\/p>\n
Some more exciting products that we are partner with:<\/em><\/p>\n
Download Lavastorm Dataverse Trial<\/a> or visit Wherescape<\/a><\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Tableau despite being an excellent tool to quickly visualize the data can also be used for creation and verification of Linear regression models used for predictive analytics. The ability of Tableau to integrate with external statistical languages like Python or R allows it to use the Regression models built in those languages to directly beContinue reading →<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_wpscppro_dont_share_socialmedia":false,"_wpscppro_custom_social_share_image":0,"_facebook_share_type":"","_twitter_share_type":"","_linkedin_share_type":"","_pinterest_share_type":"","_linkedin_share_type_page":"","_instagram_share_type":"","_medium_share_type":"","_threads_share_type":"","_google_business_share_type":"","_selected_social_profile":[],"_wpsp_enable_custom_social_template":false,"_wpsp_social_scheduling":{"enabled":false,"datetime":null,"platforms":[],"status":"template_only","dateOption":"today","timeOption":"now","customDays":"","customHours":"","customDate":"","customTime":"","schedulingType":"absolute"},"_wpsp_active_default_template":true},"categories":[1],"tags":[15,14,16,6],"class_list":["post-230","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-analytics","tag-r","tag-regression","tag-tableau","no-thumb"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/senSqB-230","_links":{"self":[{"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/posts\/230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/comments?post=230"}],"version-history":[{"count":7,"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/posts\/230\/revisions"}],"predecessor-version":[{"id":276,"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/posts\/230\/revisions\/276"}],"wp:attachment":[{"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/media?parent=230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/categories?post=230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sprintmilestone.com\/blog\/wp-json\/wp\/v2\/tags?post=230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Test Connection and Ok.<\/li>\n<\/ul>\n
- \u00a0Select Localhost and port 6311<\/li>\n<\/ul>\n
- Open Tableau desktop and goto Help Menu -> Settings and performance -> Manage External Service Connection<\/li>\n<\/ul>\n
- Open R Studio and Type below commands on R command line:<\/li>\n<\/ul>\n