Tableau Advance Analytics with R training

Course Objectives

BISP’s  Tableau  Advance  Analytics  Training will let you gain proficiency in Tableau integration with R.  You will work on real-life industry projects in statistical computing, graphics, data mining, data visualization, analytics, report, interactive dashboards. This is an industry-designed Combo  Training Course of Tableau and R providing you the complete training in Tableau and R programming language.  R is a statistical analysis language and the Tableau Desktop can combine with it and benefit from  R  functions, libraries, packages and invoke the R engine to return values to Tableau. The Tableau Server can be configured to R to view a dashboard of R functionality. All this ensures that you get awesome statistical analysis capabilities into a simple drag and drop visualization environment.

Course Outline

 Introduction to Data Visualization

What is Data Visualization?

Identify the prerequisites, goal, objectives, methodology, and Goal.

 Architecture of Tableau

What is Tableau?

Features of Tableau.

Installation of Tableau Desktop.

The interface of Tableau(Layout/Toolbars/Data Pane/Analytics Pane etc).

Managing Data Sources

Connection to various data sources

Mysql Database connectivity and tables

ODBC and other sources connectivity

 Introduction to Visual Analytics with Tableau.

Introduction to various charts

Bar Charts, Line Graphs, Pie Charts

Maps, Scatter Plots, Gantt Charts, Bubble Charts

Treemaps and Box-and-Whisker Plots

Managing Extracts

Managing Metadata

Visual Analytics

Data Granularity using Marks Card

Highlighting

Deep dive into Visualization

Highlighting Tables, Heat Maps.

Circle Plots

Side By Sidebar charts, Dual Axis Charts, Area Charts.

Waterfall Charts, Bump Chart, Word Cloud Chart, Pareto Charts.

Parameter using sets and filter

fields: continuous and discrete visualization

Quick Sort, Sorting using measure, Sorting using header and legends, sorting

Filtering Use cases covering different options (General, Wildcard, Conditional).

Interactive Filter, Quick Filter, Context Filter.

Grouping using Data Window, Visual Grouping, Calculated Grouping

(Static and Dynamic).

Adding trend line and reference line (along with various options available for them)

 Data Organization and Scripting

Calculated Metrics, Apply Sorting on Dimension and Measures.

Calculating Total and Subtotals.

Various Aggregated measures, Percentages.

Data Spotlighting, Summary Card, Date and Time Functions.

Logical Functions.

Hierarchies, Groups, and Bins.

 Working with Time Dimension

Quick Table Calculations.

Custom Table Calculations.

YTD, Parallel Period, Moving Averages.

Running totals, Window Averages.

Trend Lines and Predictive Models.

Data Incremental Loading and Data Blending

Data Blending from multiple source systems Creating Incremental Loads

Creating File Extractions, Parameters

Dashboard and Stories

Creating a Dashboard and learning its UI component.

Changing the layout of the dashboard.

Using Device Designer to create a dashboard for devices.

Create an interactive dashboard using actions (Filter, Highlight, URL).

Creating a story with dashboard.

Tableau Server Comprehensive

Single Installer

Worker Installer

Authentication

Processes

Data Server

Create the First Admin User

Create Projects and Groups

Assign Permissions to Projects

Data Connections

Metadata management

Connecting to data with Data Server

Updating data sources

Advanced Analytic with R and Tableau

Installing R and R Studio

Installing Reserve

Environment of R

Connecting to Reserve

Power of R

Variables

Vectors and Lists

Matrices

Factors

Data Frames

Control Structures

For Loops

Functions

Using R in Tableau

Prediction with R and Tableau Using Regression

Simple Linear Regression

Comparing Actual Values with Predicted Results

Logistic Regression

Advanced Analytics Using Clustering

How Does K-Means Work?

Creating a Tableau Group from Cluster Results

Classifying Data With Tableau

Decision Trees in Tableau Using R

Multivariate  Forecasting in Tableau w