4 Weekends Tableau BI training is being delivered from May 30, 2020 - June 21, 2020 for 16 hours over 4 weekends, 8 sessions, 2 sessions per weekend, 2 hours per session.
Any IT Professional who is interested in learning Tableau BI.
1. Introduction to Data warehousing
• What is Database evaluation?
• Database Evaluation types
• What is Data warehousing
• 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. Business Intelligence
• What is Business Intelligence and Visual Intelligence?
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?
• What is Tableau Reader
• What is Tableau Online
• What is Tableau Public?
5. Tableau Extensions
• Types of Extensions
• When to use Tableau Extensions
• Differences between. Twb and .Twbx extensions
6. View Sections
• What is Dashboard, when to use Dashboard and Ways to use Dashboard
• What is workbook 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
7. Dashboard Components
• Horizontal
• Vertical component
• Image Component
• Text Component
• Blank Component
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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.
17. Trend Analysis
• What is Trend Analysis
• Logarithmic Model
• Exponential Model
• Linear Model
• Polynomial Model
18. Fore Casting and Reference Lines
• What is Fore Casting and implementation
• What is Reference Line
• Lines
• Bands
• Distributions
• Box Plot
19. Annotations
• Mark Annotation
• Point Annotation
• Area Annotation
20. Aggregation and Disaggregation
• What is Aggregation
• When to use Aggregation
• What is Disaggregation
• When to use Disaggregation.
21. Page-shelf or Automated Maps
• What is Page Shelf?
• When to use Page Shelf
• Page Shelf Customized Controls
22. Drop Lines
• What is Drop Lines
• When to use Drop Lines?
• What is summary Card?
• When to Use summary Card in Tableau?
23. Actions in Tableau
• What is Actions & When to use Actions
• Types of Actions in tableau
• How to Trigger the Action
24. 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
25. Tableau Advanced Charts – User defined Charts (IMP)
• Waterfall charts
• Donut charts
• Funnel Charts
• Lollipops charts
• Whisker plots.
• Scatter plot
26. Case Study
• Resume Preparation
• Mock Interviews
• Advanced Tableau 10 New Features.
• Reporting Migration Process and Check list in Real-Time.