Description

Introduction

• Datawarehousing & Business Intelligence primer
• Data Analysis
• Data visualization
• How does Business Reporting Work
• About Tableau
• Tableau Components
• Tableau Desktop, Server, Reader, Onlline and Public
• Tableau reporting architecture
• Measures & Dimensions

Getting data in

• Flat files (Excel, Acces)
• Database (SQL, Oracle)
• Webservices, Cloud Salesforce CRM
• Live, Extract & Hyper
  1.  Why Extracts
  2. Incremental Extracts
• Tableau Server Data Sources

Saving & Publishing

• Tableau Workbook
• Tableau Packeged workbook
• Tableau Data Extract
• Publishing data and Reoprts, Dashboard to Server

Visualizations

• Line Charts
  1. Lines (continous) charts
  2. Lines (discrete) charts
  3. Dual lines
• Bar Charts
  1. Horizontal bar charts
  2. Stacked bar charts
  3. Side-by-Side bar charts
• Text tables
• Heat maps
• Highlight tables
• Symbol maps
• Filled Maps
• Pie Charts
• Treemaps
• Circle views
• Side-by-Side Circle views
• Area Charts
  1. Area Charts (Continous)
  2. Area Charts (Discrete)
• Combination charts
• Scatter Plots
• Histogram
• Box Plots
• Gantt charts
• Bullet Charts
• Packed bubble charts

Customize Charts

• Dual Axis
• Donnut Chart
• Waterfall Chart
• Bump Chart
• Parreto chart

Dashboards

• Creation of Dashboards
• Types of Dahboards
• Real time based dashboards
• Dash board Actions
• Button on Dashboard to dashboards actions

Actions

• Worksheet Actions
• Dashboard Actions

Types of action

• Filer Actions
• Highlght Actions
• URL Actions

Filter Types

• Normal Filter
• Quick filter
• Cascading filter
• Global filter
• Data Source Filter
• Context Filter
• User Filters

Joins & Data Blending & cross Joining

• Types of Join
• Types of data blening
• Types of Querrys
  1. Custome SQL
  2. VIZ QL
• Combine data
• Groups
• Sets
• Constant set and Computed set
• Combined set
• Top & Bottom data
• Bins

Parameters

• Types of Parameters
  1. Use of parameter
  2. Global Parameter
  3. diff b/w filters and parameter
  4. Show Hide (Sheet Filter)
  5. TopN and Bottom N records

Statstical Part

• Forecasting
• Reference Bands
• Reference Lines
• Show Missing Values
• Trend Lines
• Legend Highlighting
• Highlight Actions
• Visually Grouping Data

Calculations

• Table Calculations
• Computing Totals
• Functions
• Data Claculations
• LOD Expresions(fixed, Exclude & Include)

Tableau Server

• Tableau Server Instalations and Configurations
• Tableau Server Architechure
• Users Creations
  • User Role types
• Group creation
• Assign Users to Group
• Project Creations
• Site creations

Publishing

• Publishing Worksheets
• Publishing Dashboards
• Publishing Data Base

Permission settings

• Permission Types
• Worksheet permissions
• Dashboard Permissions
• Workbook Permissions
• Data base permissions

Scheduling

• Typers of Schedulings
• Priority Task
• Assign the schedules to Data base
• Assign the schedules to Worksheets
• Assign the Schedules to Workbook

• Commands Line
• Tab CMD
• Tab ADMIN