Tableau Training in Pune

Best Data Analytics Tool with Online & offline classes

Duration of Training : 32 hrs

Batch type : Weekdays/Weekends

Mode of Training : Classroom/Online/Corporate Training

Tableau Training & Certification in Pune

Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry

Realtime Projects, Scenarios & Assignments

Pre-Requisites :
The best thing about Tableau is that there is no prerequisite to learn this software. With zero technical or any programming skills, one can learn and master this tool suite

Learning Objectives :

At the end of this class, the student will be able to :

Build advanced chart types and visualizations
Build complex calculations to manipulate your data
Work with statistics and statistical techniques
Work with parameters and input controls
Implement advanced geographic mapping techniques and use custom images to build spatial visualizations of non-geographic data
Implement all options in working with data: Joining multiple tables, data blending, performance considerations and working with the Data Engine, and understand when to implement which connection method.
Build better dashboards using techniques for guided analytics, interactive dashboard design and visual best practices
Implement many efficiency tips and tricks
Understand the basics of Tableau Server and other options for sharing your results

Is SQL required to learn Tableau?

You must have to have a basic knowledge of SQL, and this would help in writing custom queries which is not possible through to frag and drop functionality to achieve complex data set building.

COURSE CONTENT :

1. Introduction and Getting Started

Why Tableau? Why Visualization?
The Tableau Product Line
Level Setting – Terminology
Getting Started – creating some powerful visualizations quickly
Review of some Key Fundamental Concepts
What is Tableau?
What does the Tableau product suite comprise of? How Does Tableau Work?
Tableau Architecture
Connecting to Data & Introduction to data source concepts

Understanding the Tableau workspace
Dimensions and Measures
Data Types & Default Properties
Tour of Shelves & Marks Card
Using Show Me
Saving and Sharing your work-overview

2. Filtering, Sorting & Grouping

Filtering, Sorting and Grouping are fundamental concepts
when working with and analyzing data. We will briefly review these topics as they apply to Tableau

Advanced options for filtering and hiding
Understanding your many options for ordering and grouping your data: Sort, Groups, Bins, Sets
Understanding how all of these options inter-relate

3. Working with Data

In the Advanced class, we will understand the difference between joining and blending data, and when we should do each. We will also consider the implications of working with large data sets, and consider options for when and how to work with extracts and the data engine. We will also investigate best practices in “sharing” data sources for Tableau Server users.

Data Types and Roles
Dimension versus Measures
Data Types
Discrete versus Continuous
The meaning of pill colors
Database Joins
Data Blending
Working with the Data Engine / Extracts and scheduling extract updates
Working with Custom SQL
Adding to Context
Switching to Direct Connection

4. Working with Calculated Data and Statistics

In the Fundamentals Class, we were introduced to some basic calculations: basic string and arithmetic calculations and ratios and quick table calculations. In the Advanced class, we will extend those concepts to understand the intricacies of manipulating data within Tableau

5. A Quick Review of Basic Calculations

Arithmetic Calculations

String Manipulation

Date Calculations

Quick Table Calculations

Custom Aggregations

Custom Calculated Fields

Logic and Conditional Calculations

Conditional Filters

6. Advanced Table Calculations

Understanding Scope and Direction

Calculate on Results of Table Calculations

Complex Calculations

Difference From Average

Discrete Aggregations

Index to Ratios

7. Working with Parameters

In the Fundamentals class, we were introduced to parameters – How to create a parameter and use it in a calculation. In the Advanced class, we will go into more details on how we can use parameters to modify our title, create What-If analysis, etc

Parameter Basics

Data types of parameters

Using parameters in calculated fields

Inputting parameter values and parameter control options

Advanced Usage of Parameters

Using parameters for titles, field selections, logic statements, Top X

8. Building Advanced Chart Types and Visualizations/Tips & Tricks

This topic covers how to create some of the chart types and visualizations that may be less obvious in Tableau. It also covers some of the more common tips & tricks/techniques that we use to assist customers in solving some of their more complex problems.

Bar in Bar
Box Plot
Bullet Chart
Custom Shapes
Gantt Chart
Heat Map
Pareto Chart
Spark Line
KPI Chart

9. Best Practices in Formatting and Visualizing

Formatting Tips
Drag to Legend
Edit Legend
Highlighting
Labeling
Legends
Working with Nulls
Table Options
Annotations and Display Options
Introduction to Visualization Best Practices

10. Data Analysis And Reporting

Data Analysis using Pivot Tables – use of row and column shelf, values and filters
Difference between data layering and cross tabulation, summary reports, advantages and limitations
Change aggregation types and summarisation
Creating groups and bins in pivot data
Concept of calculated fields, usage and limitations
Changing report layouts – Outline, compact and tabular forms
Show and hide grand totals and subtotals
Creating summary reports using pivot tables

11. SQL : Data Manipulation (DML Commands)

Insert, Update & Delete statements
Select statement – Subsetting, Filters, Sorting. Removing Duplicates, grouping and aggregations etc
Where, Group By, Order by & Having clauses
SQL Functions – Number, Text, Date, etc
SQL Keywords – Top, Distinct, Null, etc
SQL Operators – Relational (single valued and multi valued), Logical (and, or, not), Use of wildcard operators and wildcard characters, etc

12. SQL : Accessing Data From Multiple Tables Using SELECT

Append and JoinsUnion and Union All – Use & constraints
Intersect and Except statements
Table Joins – inner join, left join, right join, full join
Cross joins/cartesian products, self joins, natural joins etc
Inline views and sub-queries
Optimizing your work

13. Tableau : Data Handling & Summaries

Date Aggregations and Date parts
Cross tab & Tabular charts
Totals & Subtotals
Bar Charts & Stacked Bars
Line Graphs with Date & Without Date
Tree maps
Scatter Plots
Individual Axes, Blended Axes, Dual Axes & Combination chart
Parts of Views
Sorting
Trend lines/ Forecasting
Reference Lines
Filters/Context filters
Sets
- In/Out Sets
- Combined Sets
Grouping
Bins/Histograms
Drilling up/down – drill through
Hierarchies
View data
Actions (across sheets)

14. Tableau : Building Advanced Reports/ Maps

Explain latitude and longitude
Default location/Edit locations
Building geographical maps
Using Map layers

15. Tableau : Calculated Fields

Working with aggregate versus disaggregate data
Explain – #Number of Rows
Basic Functions (String, Date, Numbers etc)
Usage of Logical conditions

16. Tableau : Table Calculations

Explain scope and direction
Percent of Total, Running / Cumulative calculations
Introduction to LOD (Level of Detail) Expressions
User applications of Table calculations

17. Tableau : Parameters

Using Parameters in
- Calculated fieldsBins
- Reference Lines
- Filters/Sets
Display Options (Dynamic Dimension/Measure Selection)
Create What-If/Scenario analysis

18. Tableau : Building Interactive Dashboards

Combining multiple visualizations into a dashboard (overview)
Making your worksheet interactive by using actions
- Filter
- URL
- Highlight
Complete Interactive Dashboard for Sales & Services

19. Tableau : Formatting

Options in Formatting your Visualization
Working with Labels and Annotations
Effective Use of Titles and Captions

20. Tableau : Working With Data

Multiple Table Joins
Data Blending
Difference between joining and blending data, and when we should do each
Toggle between to Direct Connection and Extracts

RECOMMENDED COMBO :

TABLEAU + BUSINEES ANALYTICS

ORACLE SQL+ INFORMATICA + TABLEAU

Depending on the selection of the BI tool we train you to crack the first step of Data Analytics certification (Developer) with the guidance of the trainer and the most expected questions in the certification along with the tips and tricks to quickly make your answers by interpreting the questions asked in the certification.

The trainer has 10+ years of experience into Business Intelligence blended with Data Analytics and real time BI implementations of Banking,Retail and Pharma domain which implement BI on a very high scale. Along with the industrial experience he carries a suite of different use cases in the industry and their solutions as a part of the training. The past candidates have successfully been able to grasp the tool after being taught and keep receiving solutions for existing problems in the Real time experience and bond shared by the trainer.

Radical believes in giving Quality to their candidates by gelling up the real time industry experience shared by the trainers. We believe in taking the tour of the technology to a deep level assuming that it provides value in the long rum to its students and they keep up a good bond with the institute and the trainer in their long journey. Swift responses to queries, Alternate solutions to problems and real time use cases of business makes it unique as a training institute.

The next path after Tableau is to enter as a business Analyst role and start with the slice and dice reporting along with self driven reporting. Gradually we need to enter into Analytics by knowing the inbuilt K-means algorithm of Tableau and then proceed towards ‘R’ followed by machine learning and Artificial Intelligence.

TABLEAU