Book Image

Advanced Analytics with R and Tableau

By : Ruben Oliva Ramos, Jen Stirrup, Roberto Rösler
Book Image

Advanced Analytics with R and Tableau

By: Ruben Oliva Ramos, Jen Stirrup, Roberto Rösler

Overview of this book

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.
Table of Contents (16 chapters)
Advanced Analytics with R and Tableau
About the Authors
About the Reviewers
Customer Feedback

Introduction to dplyr

What is dplyr? Well, dplyr can be perceived as a grammar of data manipulation. It has been created for the R community by Hadley Wickham, Romain Francois, and RStudio.

What does dplyr give the Tableau user? We will use dplyr in order to cleanse, summarize, group, chain, filter, and visualize our data in Tableau.

Summarizing the data with dplyr

Firstly, let's import the packages that we need. These packages are listed in the following table, followed by the code itself.

Packages required for the hands-on exercise:

Package Name




Search, extract, and format data from the World Bank's World Development Indicators


dplyr is a grammar of data manipulation


As we walk through the script, the first thing we need to do is install the packages.

Once you have installed the packages, we need to call each library.

Once we have called the libraries, then we need to obtain the data from the...