Tableau

Tableau Business Intelligence Training
Total Duration: 2 days,



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