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
• What is Tableau Public?

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

• 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