Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Advanced Analytics with R and Tableau
Advanced Analytics with R and Tableau

Advanced Analytics with R and Tableau: Advanced analytics using data classification, unsupervised learning and data visualization

Arrow left icon
Profile Icon Roberto Rösler Profile Icon Jen Stirrup Profile Icon Ruben Oliva Ramos
Arrow right icon
€26.99
Full star icon Half star icon Empty star icon Empty star icon Empty star icon 1.3 (7 Ratings)
eBook Aug 2017 178 pages 1st Edition
eBook
€26.99
Paperback
€32.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Roberto Rösler Profile Icon Jen Stirrup Profile Icon Ruben Oliva Ramos
Arrow right icon
€26.99
Full star icon Half star icon Empty star icon Empty star icon Empty star icon 1.3 (7 Ratings)
eBook Aug 2017 178 pages 1st Edition
eBook
€26.99
Paperback
€32.99
Subscription
Free Trial
Renews at €18.99p/m
eBook
€26.99
Paperback
€32.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents Preview book icon Preview Book

Advanced Analytics with R and Tableau

Chapter 1. Advanced Analytics with R and Tableau

Moving from data visualization into deeper, more advanced analytics? This book will intensify data skills for a data-savvy user who wants to move into analytics and data science in order to make a difference to their businesses, by harnessing the analytical power of R and the stunning visualization capabilities of Tableau.

Together, Tableau and R offer accessible analytics by allowing a combination of easy-to-use data visualization along with industry-standard, robust statistical computation. Readers will come across a wide range of machine learning algorithms and learn how descriptive, prescriptive, and predictive visually appealing analytical solutions can be designed solutions with R and Tableau.

Let's get ready to start our transition from being a data-savvy user to a data analyst using sound statistical tools to perform advanced analytics. To do this, we need to get the tools ready. In this topic, we will commence our journey of conducting Tableau analytics with the industry-standard, statistical prowess of R. As the first step on our journey, we will cover the installation of R, including key points about ensuring the right bitness before we start. In order to create R scripts easily, we will install RStudio for ease of use.

We need to get R and Tableau to communicate, and to achieve this communication, we will install and configure Rserve.

Installing R for Windows

The following steps shows how to download and install R on windows:

  1. The first step is to download your required version of R from the CRAN website [http://www.rproject.org/].
  2. Go to the official R website, which you can find at https://www.r-project.org/.
  3. The download link can be found on the left-hand side of the page.
  4. The next option is for you to choose the location of the server that holds R. The best option is to choose the mirror that is geographically closest to you. For example, if you are based in the UK, then you might choose the mirror that is located in Bristol.
  5. Once you click on the link, there is a section at the top of the page called Download and Install R. There is a different link for each operating system. To download the Windows-specific version of R, there is a link that specifies Download R for Windows. When you click on it, the download links will appear on the next page to download R.
  6. On the next page, there are a number of options, but it is easier to select the option that specifies install R for the first time.
  7. Finally, there is an option at the top of the page that allows you to download the latest R installation package. The install package is wrapped up in an EXE file, and both 32 bit and 64 bit options are wrapped up in the same file.

    Now that R is downloaded, the next step is to install R. The instructions are given here:

  8. Double-click on the R executable file, and select the language. In this example, we will use English. Choose your preferred language, and click OK to proceed:
    Installing R for Windows
  9. The Welcome page will appear, and you should click Next to continue:
    Installing R for Windows
  10. The next item is the general license agreement. Click Next to continue:
    Installing R for Windows
  11. The next step is to specify the destination location for R's files. In this example, the default is selected. Once the destination has been selected, click Next to proceed:
    Installing R for Windows
  12. In the next step, the components of R are configured. If you have a 32-bit machine, then you will need to select the 32-bit option from the drop-down list.
    Installing R for Windows
  13. In the next screenshot, the 64-bit User Installation option has been selected:
    Installing R for Windows
  14. The next option is to customize the startup options. Here, the default is selected. Click Next to continue.
    Installing R for Windows
  15. The next option is to select the Start Menu folder configuration. Select the default, and click Next:
    Installing R for Windows
  16. Next, it's possible to configure some of R's options, such as the creation of a desktop icon. Here, let's choose the default options and click Next:
    Installing R for Windows
  17. In the next step, the R files are copied to the computer. This step should only take a few moments:
    Installing R for Windows
  18. Finally, R is installed, and you should receive a final window. Click Finish:
    Installing R for Windows
  19. Once completed, launch RGui from the shortcut, or you can locate RGui.exe from your installation path. The default path for Windows is C:\Program Files\R\R- 2.15.1\bin\x64\Rgui.exe.
  20. Type help.start() at the R-Console prompt and press Enter. If you can see the help server page then you have successfully installed and configured your R package.

RStudio

The R interface is not particularly intuitive for beginners. For this reason, RStudio IDE, the desktop version, is an excellent option for interacting with R. The download and installation sequence is provided.

There are two versions; the RStudio Desktop version, and the paid RStudio Server version. In this book, we will focus on the RStudio Desktop IDE option, which is open source.

Prerequisites for RStudio installation

In this section, RStudio IDE is installed on the Windows 10 operating system:

  1. To download RStudio, you can retrieve it from https://www.rstudio.com/products/rstudio-desktop/.
  2. Once you have downloaded RStudio, double-click on the file to start the installation. This will display the RStudio Setup and Welcome page. Click Next to continue:
    Prerequisites for RStudio installation
  3. The next option allows the user to configure the installation location for RStudio. Here, the default option has been retained. If you do change the location, you can click Browse to select your preferred installation folder. Once you've selected your folder, click Next to continue to the next step.
    Prerequisites for RStudio installation
  4. In the next step, RStudio shortcuts are specified. Click on Install to proceed:
    Prerequisites for RStudio installation
  5. RStudio installs in the next step:
    Prerequisites for RStudio installation
  6. Once completed, launch RStudio IDE. You can find it by navigating to Start | All Programs | RStudio | RStudio.exe. Alternatively, you can type RStudio into the Cortana search box. If you specified a custom installation directory, then you can find RStudio as an EXE file. The default installation directory for RStudio IDE is C:\Program Files\RStudio\bin\rstudio.exe.
  7. Type help.start() at the RStudio prompt and press Enter. If you can see the help files on the screen then you have successfully installed and configured RStudio IDE to run with R.

Implementing the scripts for the book

Now that we have installed R and RStudio, we can download and install the scripts for this book. This book's scripts and code can be found on GitHub. If the reader hasn't got a free GitHub account, then it's recommended that Git and GitHub are set up. It's good practice for storing your own R scripts at a later date. If required, the reader is referred to the GitHub site for more details. GitHub itself can be found at github.com. Training material can be found at https://training.github.com/kit/.

After setting up Git and GitHub, you can download our data and scripts by taking a copy of this book's GitHub repository. Simply put, a fork is a copy of a repository, and it means that you can freely experiment with changes without affecting the original project. Please refer to the GitHub training material for more information on how to fork a repository, download data and scripts, and how to keep your local copy in sync with changes to the repository.

Tip

Go to the GitHub repo at https://github.com/datarelish/Advanced-AnalyticsRandTableauBook.

At the top right-hand corner of the page, click Fork. This means you have forked the repository. The next step is to download the files to your local computer. To do this, you can run the following line of code in your Git Bash:

Testing the scripting

Before we proceed, let's proceed to run a script to test that our setup works:

  1. Open the script in RStudio's script editor.
  2. Go to the Code menu item.
  3. Choose Source from the menu.
  4. Navigate to the Packt Tableau and R Book Setup.r file.
  5. Press Ctrl + A to select the whole script.
  6. In the script window, click Run.
  7. You should see the results in the output window.

Tableau and R connectivity using Rserve

Rserve is a server that allows applications to access R functionality. It allows you to use a series of functions to pass R expressions to an Rserve server and obtain a result.

If you upload a workbook that contains R functionality to the Tableau server, then the Tableau server must have a connection to an Rserve server. See R Connection, in the Tableau Desktop help, for details.

R is not supported for Tableau Reader or Tableau Online.

In this section, we will install, run, and configure Rserve.

Installing Rserve

To install and run Rserve, follow these steps:

  1. Open RStudio and go to the Install Packages tab on the interface.
  2. In the Packages textbox, type Rserve and click OK.
  3. Rserve will install, and you will see the output messages in the RStudio Console. When it is finished, you will see the chevron again.
  4. Now, open Control Panel on the server, and search for environment variable in the search box.
  5. Click on the Edit the System Environment Variables option.
  6. Add a new variable to the PATH variable path. Add the directory containing R.dll to your path environment variable. For example, C:\Program Files\R\R-3.0.2\bin\x64.
  7. You should see the new path in the Edit Environment Variable window. You can see a sample image here:
    Installing Rserve
  8. Click OK.

Let's check that Rserve is running properly:

In RStudio, let's call Rserve by running the following command in the RStudio Console:

library(Rserve)

Configuring an Rserve Connection

To configure an Rserve connection, follow these steps:

  1. On the Help menu in Tableau Desktop, choose Settings and Performance | Manage R Connection to open the Rserve connection dialog box.
  2. Enter or select a server name using a domain name or an IP address.
  3. Specify a port (Port 6311) is the default port for Rserve servers.
  4. If the server requires credentials, specify a username and password.
  5. Click Test Connection.
  6. Click OK.

Summary

In this chapter, we started on our journey of conducting Tableau analytics with the industry-standard, statistical prowess of R. In this chapter, we covered the installation of R, including a key point about ensuring the right bitness before we start. We also installed RStudio and ran a script, as a way of engaging with R. Finally, we installed and configured Rserve for Tableau.

In our next chapter, we will learn more about the underlying data structures of R so that we can make use of the analytic power of Tableau and R more effectively.

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • A comprehensive guide that will bring out the creativity in you to visualize the results of complex calculations using Tableau and R
  • Combine Tableau analytics and visualization with the power of R using this step-by-step guide
  • Wondering how R can be used with Tableau? This book is your one-stop solution.

Description

Tableau and R offer accessible analytics by allowing a combination of easy-to-use data visualization along with industry-standard, robust statistical computation. Moving from data visualization into deeper, more advanced analytics? This book will intensify data skills for data viz-savvy users who want to move into analytics and data science in order to enhance their businesses by harnessing the analytical power of R and the stunning visualization capabilities of Tableau. Readers will come across a wide range of machine learning algorithms and learn how descriptive, prescriptive, predictive, and visually appealing analytical solutions can be designed with R and Tableau. In order to maximize learning, hands-on examples will ease the transition from being a data-savvy user to a data analyst using sound statistical tools to perform advanced analytics. By the end of this book, you will get to grips with advanced calculations in R and Tableau for analytics and prediction with the help of use cases and hands-on examples.

Who is this book for?

This book will appeal to Tableau users who want to go beyond the Tableau interface and deploy the full potential of Tableau, by using R to perform advanced analytics with Tableau. A basic familiarity with R is useful but not compulsory, as the book will start off with concrete examples of R and will move quickly into more advanced spheres of analytics using online data sources to support hands-on learning. Those R developers who want to integrate R in Tableau will also benefit from this book.

What you will learn

  • Integrate Tableau s analytics with the industry-standard, statistical prowess of R.
  • Make R function calls in Tableau, and visualize R functions with Tableau using RServe.
  • Use the CRISP-DM methodology to create a roadmap for analytics investigations.
  • Implement various supervised and unsupervised learning algorithms in R to return values to Tableau.
  • Make quick, cogent, and data-driven decisions for your business using advanced analytical techniques such as forecasting, predictions, association rules, clustering, classification, and other advanced Tableau/R calculated field functions.

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 22, 2017
Length: 178 pages
Edition : 1st
Language : English
ISBN-13 : 9781786460240
Vendor :
Tableau
Category :
Languages :
Tools :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : Aug 22, 2017
Length: 178 pages
Edition : 1st
Language : English
ISBN-13 : 9781786460240
Vendor :
Tableau
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 120.97
Learning Tableau 10
€45.99
Mastering Tableau
€41.99
Advanced Analytics with R and Tableau
€32.99
Total 120.97 Stars icon

Table of Contents

9 Chapters
1. Advanced Analytics with R and Tableau Chevron down icon Chevron up icon
2. The Power of R Chevron down icon Chevron up icon
3. A Methodology for Advanced Analytics Using Tableau and R Chevron down icon Chevron up icon
4. Prediction with R and Tableau Using Regression Chevron down icon Chevron up icon
5. Classifying Data with Tableau Chevron down icon Chevron up icon
6. Advanced Analytics Using Clustering Chevron down icon Chevron up icon
7. Advanced Analytics with Unsupervised Learning Chevron down icon Chevron up icon
8. Interpreting Your Results for Your Audience Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Half star icon Empty star icon Empty star icon Empty star icon 1.3
(7 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 28.6%
1 star 71.4%
Filter icon Filter
Top Reviews

Filter reviews by




GP_user Nov 14, 2019
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
I used this book for a training. Seems that author or the editors could have spent more time before publishing this book. Texts and codes don’t always match and codes are not even consistent. Best part is on page 124, data was about flower iris, but middle in the page it reads ‘wine’ from some unknown data. You can’t help but thinking how nice it must have been thinking of flowers and wines while writing this part!
Amazon Verified review Amazon
NJ Reader Oct 30, 2017
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
Overall, the book is a fantastic overview of using R in tableau. The issue is that you cannot get your hands on the files to go along with the book. In the beginning, they have you going to Packt Publishing and/or Git Hub to get them, but when you do, there are only "read me" files and the CSV data you should have is nowhere to be found.. I contacted Packt and they sent me two emails, telling me that were trying to reach the author. The problem is that I wanted the files in order to teach classes with them. I would have given five stars to the book, if I had the files. But, as is, my students cannot use the book in the way the author says they can.
Amazon Verified review Amazon
Ray Prtha Aug 02, 2020
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
This book contains pages and pages of theory with very little practical execution or hands-on exercises. Totally useless. It is like reading a book on swimming when what you really want to do is actually swim.
Amazon Verified review Amazon
Tim Terry Feb 27, 2019
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
I don't ever want to write a negative review for a book. However, in this case, it seems warranted. The text of the e-book seems to be incomplete. The chapter summaries read as if large parts of chapters are missing. The packet of supporting files are very confusing. The sample Tableau files are missing the associated databases and have nothing to do with the chapters. I thought maybe the file set was wrong, but the databases are the correct ones. The R examples seem to be well done, but the Tableau examples are pretty poorly documented. I was hoping for a book that talked about integration of R and Tableau more. Perhaps this book does, within the missing sections, but as is, it was not 40 dollars well spent. I'm very dissatisfied.
Amazon Verified review Amazon
Huy Jan 02, 2020
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
This book has a lot of useful informations if and only if the data they use is not broken/changed.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.