title: Calculations in R, visualisations in Tableau - how to properly integrate these two?
body: <p>I've got a bunch of R scripts that read in a data from various sources, perform all the analyses needed and makes some visualisations. Now I need to pass the visualisation part over to Tableau and prepare the whole dashboard in the latter. </p>
  
  <p>From what I know I could save all the <code>data.frames</code> to <code>.Rdata</code> files and load them in Tableau, but it seems to be cumbersone in the long run, while the whole program should be automated as far as possible. </p>
  
  <p>The second option I got to know is to read data in Tableau, connect to R via <code>Rserve</code> and call simple R scripts from <code>Tableau</code>. It would be an option, but:</p>
  
  <ul>
  <li>R scripts can't be fully automated - they require some interaction with the user, it is the user who has to control the analysis and it should be left as that</li>
  <li>my scripts do so much data cleaning and wrangling that I think it's better to leave this job separately in R</li>
  </ul>
  
  <p>So my question is what is the best way to integrate R and Tableau so that after I perform all the analysis in R I could only update the data in prepared earlier Tableau dashboard with few plots?</p>