Tableau Business Intelligence Training

Total Duration: 2 days, Hours: 16 hours

Business Intelligence
• What is Business Intelligence and Visual Intelligence?

Tableau Introduction
• Why Tableau
• History of Tableau
• Characteristics of Tableau
• Tableau versions.
• Differences between different versions of tableau.
• Tableau Architecture and components.

Tableau Components
• What is Tableau Desktop, Server?
• What is Tableau Reader
• What is Tableau Online
• What is Tableau Public?

Tableau Extensions
• Types of Extensions
• When to use Tableau Extensions
• Differences between. Twb and .Twbx extensions

View Sections
• What is Dashboard, When to use Dashboard and Ways to use Dashboard
• What is work book and When to use Workbook
• What is work sheet and When to use worksheets
• What is stories their usage
• Ways to use Workbook, Dashboard, Worksheet, Stories

Dash Board Components
• Horizontal
• Vertical component
• Image Component
• Text Component
• Blank Component

Data Connection in Tableau Interface
• Types of Data Connections in Tableau
• Connect to Live Data connection
• Connect to Extract Data connection in Tableau
• Creation of Extract file in Tableau

Data Joins in Tableau
• What is Join
• Types of Joins
• When to use Joining
• Rules to perform the Joins in tableau.
• What is Custom SQL.
• Custom SQL Enabled Custom SQL.
• Writing
• Data Refresh

Data Blending in Tableau
• What is Data Blending
• Types of Data Blending
• When to use Data Blending
• Rules to perform the Joins in tableau
• Join vs. Data Blending

Graphs/Charts/Bars
• Line Graphs
• Single Line graphs
• Dual Line Graphs
• Blended Axis
• Difference between Dual axis and Blended axis
• Horizontal Bar Charts
• Vertical Bar charts
• Side-Side by bar charts
• Stacked Bar charts
• Pie Charts
• Gantt Charts

Maps
• What is Tree Maps
• Heat Maps
• Tree map implementation
• Filed Maps
• What is Geo-Coding and implementation
• Importing External Custom Geo coding
• Symbol Maps

Filters and Types
• What is Filters
• Filters on Dimensions
• What is Wild Card
• Filters on Measures
• Context Filters
• Global Filters
• Quick Filters
• Defining Filters at Source
• Defining Filters at Custom SQL

Creating and Using Parameters
• What is Parameter
• Creating Parameter
• Exploring Parameter Controls
• Work with the parameter
• Click interaction working with parameter
• Parameters and use with real time examples
• Dynamically Show and Hide Sheets with Parameter

Groups and Sets
• What is Group
• When to use Group
• Editing Existing Group
• Limitation of groups
• What is Set
• When to Use Sets
• Types of Sets

Calculated Fields
• What is Tableau Calculation
• If Condition
• When to use INDEX (),RANK (),LAST(),FIRST() Functions
• RUNNING_SUM Calculations
• WINDOW_SUM Calculations
• String Calculations
• Boolean Calculations
• DATE Calculations.

Trend Analysis
• What is Trend Analysis
• Logarithmic Model
• Exponential Model
• Linear Model
• Polynomial Model

Fore Casting and Reference Lines
• What is Fore Casting and implementation
• What is Reference Line
• Lines
• Bands
• Distributions
• Box Plot

Annotations
• Mark Annotation
• Point Annotation
• Area Annotation

Aggregation and Disaggregation
• What is Aggregation
• When to use Aggregation
• What is Disaggregation
• When to use Disaggregation.

Page-shelf or Automated Maps
• What is Page Shelf?
• When to use Page Shelf
• Page Shelf Customized Controls

Drop Lines
• What is Drop Lines
• When to use Drop Lines?
• What is summary Card?
• When to Use Summary Card in Tableau?

Actions in Tableau
• What is Actions & When to use Actions
• Types of Actions in tableau
• How to Trigger the Action

Hierarchy in Tableau
• What is a Hierarchy?
• Relation between Drill downs, Roll ups and Hierarchies.
• What are Automatic Hierarchies?
• How to create Custom Hierarchy in Tableau?
• Removing Hierarchy

Tableau Advanced Charts – User defined Charts (IMP)
• Water Fall charts
• Donut charts
• Funnel Charts
• Lollipops charts
• Whisker plots.
• Scatter plot