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.

Related Content you might be interested in

Current Title:

Small book image
Advanced Analytics with R and Tableau
Ruben Oliva Ramos | Jen Stirrup | Roberto Rösler
Aug, 2017 | 178 pages
Small book image
Data Analysis with R
Anthony Fischetti
Mar, 2018 | 570 pages
Small book image
Hands-On Machine Learning with Azure
Jen Stirrup | Thomas K Abraham | Parashar Shah | Anindita Basak | Lauri Lehman
Oct, 2018 | 340 pages
Small book image
R Data Mining
Andrea Cirillo
Nov, 2017 | 442 pages
Table of Contents (16 chapters)
Advanced Analytics with R and Tableau
Advanced Analytics with R and Tableau
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Customer Feedback
Customer Feedback
Preface
Preface
Free Chapter
1
Advanced Analytics with R and Tableau
Advanced Analytics with R and Tableau
Installing R for Windows
RStudio
Implementing the scripts for the book
Tableau and R connectivity using Rserve
Summary
2
The Power of R
The Power of R
Core essentials of R programming
Data structures in R
Data frames
Control structures in R
For loops and vectorization in R
Functions
Creating your own function
Making R run more efficiently in Tableau
Summary
3
A Methodology for Advanced Analytics Using Tableau and R
A Methodology for Advanced Analytics Using Tableau and R
Industry standard methodologies for analytics
CRISP-DM
Team Data Science Process
Working with dirty data
Introduction to dplyr
Summary
4
Prediction with R and Tableau Using Regression
Prediction with R and Tableau Using Regression
Getting started with regression
Comparing actual values with predicted results
Getting started with multiple regression?
Solving the business question
Sharing our data analysis using Tableau
Summary
5
Classifying Data with Tableau
Classifying Data with Tableau
Business understanding
Understanding the data
Modeling in R
Model deployment
Decision trees in Tableau using R
Bayesian methods
Graphs
Summary
6
Advanced Analytics Using Clustering
Advanced Analytics Using Clustering
What is Clustering?
Finding clusters in data
Clustering in Tableau
Clustering example in Tableau
Interpreting your results
How Clustering Works in Tableau
Scaling
Clustering without using k-means
Statistics for Clustering
Introduction to R
Summary
7
Advanced Analytics with Unsupervised Learning
Advanced Analytics with Unsupervised Learning
What are neural networks?
Backpropagation and Feedforward neural networks
Evaluating a neural network model
Neural network performance measures
Visualizing neural network results
Neural network in R
Modeling and evaluating data in Tableau
Summary
8
Interpreting Your Results for Your Audience
Interpreting Your Results for Your Audience
Introduction to decision system and machine learning
Decision system-based Bayesian
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
Summary
References
Index
Index

About the Authors

Jen Stirrup, recently named as one of the top 9 most influential business intelligence female experts in the world by Solutions Review, is a Microsoft Data. Platform MVP, and PASS Director-At-Large, is a well-known business intelligence and data visualization expert, author, data strategist, and community advocate who has been peer-recognized as one of the top 100 most global influential tweeters on big data and analytics topics.

Specialties: business intelligence, Microsoft SQL Server, Tableau, architecture, data, R, Hadoop, and Hive. Jen is passionate about all things data and business intelligence, helping leaders derive value from data. For two decades, Jen has worked in artificial intelligence and business intelligence consultancy, architecting, and delivering and supporting complex enterprise solutions for customers all over the world.

I would like to thank the reviewers of this book for their valuable comments and suggestions. I would also like to thank the wonderful team at Packt for publishing the book and helping me all along.

I'd like to thank my son Matthew for his unending patience, and my Coton de Tuléar puppy Archie for his long walks. I'd also like to thank my parents, Margaret and Drew, for their incredible support for this globe-trotting single mother who isn't always the best daughter that they deserve. They are the parents that I want to be.

I'd like to thank the Microsoft teams for their patience and support; they deserve special recognition here. I am grateful for their love and support, and for generally humouring me when I go off and do another community venture focused on my passions for their technology and diversity in the tech community.

I'd like to thank Tableau: Bora Beran who kindly got in touch, Andy Cotgreave who keeps the Tableau community fun and engaging as well as educational, and the Tableau UK team for humouring me, too. I am seeing a pattern here.

Ruben Oliva Ramos is a computer systems engineer from Tecnologico of León Institute with a master's degree in computer and electronic systems engineering, tele informatics, and networking specialization from University of Salle Bajio in Leon, Guanajuato, Mexico. He has more than five years' experience in developing web applications to control and monitor devices connected with the Arduino and Raspberry Pi using web frameworks and cloud services to build Internet of Things applications.

He is a mechatronics teacher at University of Salle Bajio and teaches students studying for their master's degree in Design and Engineering of Mechatronics Systems. He also works at Centro de Bachillerato Tecnologico Industrial 225 in Leon, Guanajuato, Mexico, teaching electronics, robotics and control, automation, and microcontrollers at Mechatronics Technician Career.

He has worked on consultant and developer projects in areas such as monitoring systems and datalogger data using technologies such as Android, iOS, Windows Phone, Visual Studio .NET, HTML5, PHP, CSS, Ajax, JavaScript, Angular, ASP .NET databases (SQLite, MongoDB, and MySQL), and web servers (Node.js and IIS). Ruben has done hardware programming on the Arduino, Raspberry Pi, Ethernet Shield, GPS, and GSM/GPRS, ESP8266, control and monitor systems for data acquisition and programming.

He's the Author at Pack Publishing book: Internet of Things Programming with JavaScript.

Previous Section
Next Chapter