Advanced Analytics with R and Tableau

Jen Stirrup, Ruben Oliva Ramos

• Publisher: Packt Publishing
• Year: 2017
• eBook ISBN: 9781786460240
• Edition: 1
• Topic: Computer Science
• Subtopic: Business Intelligence
• Index: Computer Science

Leverage the power of advanced analytics and predictive modeling in Tableau using the statistical powers of RAbout This Book• 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.Who This Book Is ForThis 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.In DetailTableau 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.Style and approachTableau (uniquely) offers excellent visualization combined with advanced analytics; R is at the pinnacle of statistical computational languages. When you want to move from one view of data to another, backed up by complex computations, the combination of R and Tableau makes the perfect solution. This example-rich guide will teach you how to combine these two to perform advanced analytics by integrating Tableau with R and create beautiful data visualizations.

Advanced Analytics with R and Tableau

---

Table of Contents

Advanced Analytics with R and Tableau

Credits

About the Authors

About the Reviewers

www.PacktPub.com

eBooks, discount offers, and more

Why subscribe?

Customer Feedback

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Advanced Analytics with R and Tableau

Installing R for Windows

RStudio

Prerequisites for RStudio installation

Implementing the scripts for the book

Testing the scripting

Tableau and R connectivity using Rserve

Installing Rserve

Configuring an Rserve Connection

Summary

2. The Power of R

Core essentials of R programming

Variables

Creating variables

Working with variables

Data structures in R

Vector

Lists

Matrices

Factors

Data frames

Control structures in R

Assignment operators

Logical operators

For loops and vectorization in R

For loops

Functions

Creating your own function

Making R run more efficiently in Tableau

Summary

3. A Methodology for Advanced Analytics Using Tableau and R

Industry standard methodologies for analytics

CRISP-DM

Business understanding/data understanding

CRISP-DM model — data preparation

CRISP-DM — modeling phase

CRISP-DM — evaluation

CRISP-DM — deployment

CRISP-DM — process restarted

CRISP-DM summary

Team Data Science Process

Business understanding

Data acquisition and understanding

Modeling

Deployment

TDSP Summary

Working with dirty data

Introduction to dplyr

Summarizing the data with dplyr

Summary

4. Prediction with R and Tableau Using Regression

Getting started with regression

Simple linear regression

Using lm() to conduct a simple linear regression

Coefficients

Residual standard error

Comparing actual values with predicted results

Investigating relationships in the data

Replicating our results using R and Tableau together

Getting started with multiple regression?

Building our multiple regression model

Confusion matrix

Prerequisites

Instructions

Solving the business question

What do the terms mean?

Understanding the performance of the result

Next steps

Sharing our data analysis using Tableau

Interpreting the results

Summary

5. Classifying Data with Tableau

Business understanding

Understanding the data

Data preparation

Describing the data

Data exploration

Modeling in R

Analyzing the results of the decision tree

Model deployment

Decision trees in Tableau using R

Bayesian methods

Graphs

Terminology and representations

Graph implementations

Summary

6. Advanced Analytics Using Clustering

What is Clustering?

Finding clusters in data

Why can't I drag my Clusters to the Analytics pane?

Clustering in Tableau

How does k-means work?

How to do Clustering in Tableau

Creating Clusters

Clustering example in Tableau

Creating a Tableau group from cluster results

Constraints on saving Clusters

Interpreting your results

How Clustering Works in Tableau

The clustering algorithm

Scaling

Clustering without using k-means

Hierarchical modeling

Statistics for Clustering

Describing Clusters – Summary tab

Testing your Clustering

Describing Clusters – Models Tab

Introduction to R

Summary

7. Advanced Analytics with Unsupervised Learning

What are neural networks?

Different types of neural networks

Backpropagation and Feedforward neural networks

Evaluating a neural network model

Neural network performance measures

Receiver Operating Characteristic curve

Precision and Recall curve

Lift scores

Visualizing neural network results

Neural network in R

Modeling and evaluating data in Tableau

Using Tableau to evaluate data

Summary

8. Interpreting Your Results for Your Audience

Introduction to decision system and machine learning

Decision system-based Bayesian

Decision system-based fuzzy logic

Bayesian Theory

Fuzzy logic

Building a simple decision system-based Bayesian theory

Integrating a decision system and IoT project

Building your own decision system-based IoT

Wiring

Writing the program

Testing

Enhancement

Summary

References

Index

Advanced Analytics with R and Tableau

Copyright © 2017 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author(s), nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: August 2017

Production reference: 1180817

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78646-011-0

www.packtpub.com

Credits

Authors

Jen Stirrup

Ruben Oliva Ramos

Reviewers

Kyl...

Table of contents

• Advanced Analytics with R and Tableau