Tableau

Tableau Course Content
1.    Introduction to Data Where housing

• What is Database evaluation?
• Database Evaluation types
• What is Data where Housing
• Data where Housing Characteristics and Architecture
• Difference between OLTP And OLAP
• What is Dimension table
• When to use Dimension
• Types of Dimension Tables
• What is Fact table and types
• When to use Fact table
• Types of Fact tables
• What is Star schema and snowflake schema?

2.    Introduction to Business Intelligence

• What is Business Intelligence and Visual Intelligence?
• Gartner Magic quadrant for BI

3.    Tableau Introduction

• Why Tableau
• History of Tableau
• Characteristics of Tableau
• Tableau versions.
• Differences between different versions of tableau.
• What is Vizql
• Use of Vizql in Tableau.
• Tableau Architecture and components.

4.    Tableau Components

• What is Tableau Desktop, Server, Prep
• 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 

5.    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

6.    Dash Board Components
7.    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

8.    Data Joins in Tableau

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

9.    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 

10.    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

11.    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

12.    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

13.    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 

14.    Calculated Fields

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

15.    Trend Analysis

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

16.    Fore Casting and Reference Lines

• What is Fore Casting and implementation
• What is Reference Line and types

17.    Annotations
18.    Drop Lines
19.    Actions in Tableau

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

20.    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

21.    Tableau Advanced Charts
22.    Tableau Advanced topics
23.    Publishing workbook to online
24.    Interview Preparation