4 Weekends Tableau BI Training in Charlestown | May 30, 2020 - June 21, 2020.

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.

• All Published Ticket Prices are in US Dollars
• The course will be taught in English language

4 Weekends Tableau BI Training Schedule

• May 30 - June 21, 2020 US Pacific Time
• 4 weekends | Saturday, Sunday every weekend US Pacific time
• 8:30 AM - 10:30 AM US Pacific time each of those days.
• Please click here to add your location and find your local date and time for the 1st session to be held on May 30, 2020 at 8:30 AM US Pacific Time

Features and Benefits

• 4 Weekends, 8 sessions, 16 Hours of total Instructor-led and guided training
• Training material, instructor handouts and access to useful resources on the cloud provided
• Practical Hands-on Lab exercises provided
• Actual code and scripts provided
• Real-life Scenarios

Prerequisites

Any IT Professional who is interested in learning Tableau BI.

Course Objectives

• Create Interactive dashboards
• The necessity of reporting and analytics ETL
• Understand the Tableau architecture and components
• Gain knowledge of using R scripts in Tableau
• Simplify and organize data with data connections

Course Curriculum

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.