SQL School

#Tableau

Tableau is a leading data visualization and business intelligence tool used to turn raw data into interactive insights. It allows users to create dashboards, charts, and reports without deep technical knowledge. Learning Tableau opens up roles like BI Analyst, Data Analyst, and Dashboard Developer across industries.

Training Schedules

S No	Time (IST, Mon - Fri)	Start Date
1	6 AM - 7 AM	Sep 2nd
2	10 AM - 11 AM	Aug 26th
3	11 AM - 12 PM	Aug 12th
4	8 PM -9 PM	Aug 18th

Tableau Training
Course Contents:

Brochure Download Register Now

Module 1 : SQL Server & TSQL Queries

Ch 1: SQL SERVER INTRODUCTION

Database Introduction
Types of Databases
Need for & ETL, DWH
BI Implementations
SQL Server Advantages
Version, Editions of MSSQL
Data Analyst Job Roles

Ch 2: SQL SERVER INSTALLATIONS

SQL Server 2019, 2017
SSMS Tools Installation
Database Engine (OLTP)
SCM, Configuration Tools
Instance Types, Uses
Authentication Modes
Collation, File Stream

Ch 3: SQL BASICS – 1

Need for Databases, Tables
Need for SQL Commands
DDL, DML & DQL Statements
Database Creation @ GUI
Data Operations @ GUI
Session ID, SQL Context
DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

DDL Variants in MSSQL
DML Variants in MSSQL
INSERT & INSERT INTO
SELECT & SELECT INTO
Basic Operators in SQL
Special Operators in MSSQL
ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

Data Imports with Excel
ORDER BY & UNION
UNION ALL For Sorting Data
Creating, Using Schemas
Real-world Banking Database
Table Migrations @ Schemas
2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

Need for Constraints, Keys
NULL, NOT NULL, UNIQUE
Primary Key & Foreign Key
RDBMS and ER Models
Identity Property, Default
Clustered Index, Primary Key
Non Clustered Index, Unique

Ch 7: Joins & Views Basics

JOINS: Purpose. Inner Joins
Left / Right / Full Outer Joins
Cross Joins, Query Tuning
Creating & Using Views
DML, SELECT with Views
RLS : WITH CHECK OPTION
System Views & Metadata

Ch 8: Functions(UDF), Data Types

Using Functions in MSSQL
Scalar Value Functions
Inline & Multiline Functions
Date & Time Functions
String, Aggregate Functions
Data Types : Integer, Char, Bit
SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

Stored Procedures & Usage
Creating, Testing Procedures
Encryption, Deferred Names
SPs for Validations, Analysis
System SPs, Recompilation
Normal Forms & Types
Data Models, Self-References

Ch 10: Triggers, Temp Tables

Need for Triggers
DDL & DML Triggers
Using Memory Tables
Data Replication, Automation
Local & Global Temp Tables
Testing & Using Temp Tables
SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

Planning VLDBs : Files, Sizing
Filegroups, Extents & Types
Log Files : VLF, Mini LSN
Table Location, Performance
Schemas, Transfer, Synonyms
Transactions Types, Lock Hint
Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

Cursors : Realtime Use
Fetch & Access Cursor Rows
CTEs for SELECT, DML
CTEs: Scenarios & Tuning
Linked Servers, Remote Joins
Linked Servers: MSDTC, RPC
Tuning Remote Queries

Ch 13: Merge, Upsert & Rank

Need for Merge in ETL
Incremental Loads with SQL
MERGE and RANK Functions
Window Functions, Partition
Identify, Remove Duplicates

Ch 14: Grouping & Cube

Group By & HAVING
Cube, Rollup & Grouping
Joins with Group By
3 Table, 4 Table Joins
Query Execution Order

Ch 15: Self Joins, Excel Analysis

Self Joins & Self References
UNION, UNION ALL
Sub Queries with Joins
IIF, CASE, EXISTS Statements
Excel Analytics, Pivot Reports

Module 2: Tableau Training Content

Part 1: Tableau Report Design – 1

Ch 1 : TABLEAU INTRO, INSTALLATION

Introduction to Tableau, Reporting Tools
Report Types in Real-time: Interactive
Paginated, Analytical and Mobile Reports
Data Sources for Report Design Process
Databases & Types: OLTP, DWH, OLAP
Tableau : Basic Understanding, Workflow
Tableau as a Self Service BI Tool
Tableau Features, Technical Advantages
Tableau Public Desktop : Installation
Development, Production and Access
Data Sources Types in Tableau
Tableau Prep Tools – Data Modelling
Power BI Licensing Plans – Types
Tableau Training : Course Plan, Lab
Study Material, Certifications, FAQs

Ch 2: BASIC REPORTS, GROUPING

Tableau Public Desktop : Installation
Tableau Workbook Creation, Data Sources
Tableau Worksheets : Creation, Options
Row Shelf & Column Shelf, Details View
Marks : Text, Detail, Tooltip, Colors
VizQL : Vizualization Query Language
Tableau In-Memory Database Usage
Dimensions, Measures Identification
Working with Data Sources, WorkBooks
Worksheets, Marks, Shelves, Axis
Basic Report Design Terminology
Grouping : Data Categorization
Creating Groups on Static Data
Dynamic Data Grouping, Binnig
Hierarchies: Creation, Real-time Use
Drilldown Reports in Tableau

Ch 3 : TABLEAU ARCHITECTURE, JOINS

Data Sources, Connectors, Clients
Tableau Server Components and Use
Application Server and Repository
VizQL Server and Data Engine
Backgrounder, Data Server, Search
Fast Data Engine, Gateway Components
Alias, Bins, Bookmarks, Calcualtions
Tableau File Types and Workbooks
CrossTabs, Dashboards, Data Pane
Data Source Page and Dimensions
Extract, Filters, Pages, Rows, Columns
Visual Sync Limitations with Slicer
Level of Detail, Sets, Marks, Workbooks
Using Joins in Tableau Sources
Inner, Left / Right Outer Joins

Ch 4 : BIG DATA ACCESS, BLENDING

Azure Data Access with Tableau
Remote Data Sources and Joins
Using SQL Queries in Tableau
Use Azure SQL Warehouse (DWH)
Data Blending Options in Tableau
Working with Multiple Data Sources
Data Combinations & Aggregations
Show Data & Data Grouping Options
Tableau Operators and Types
Tableau Functions and Real-time Use
Tableau Calculations and Formats
Numerical Calculatins & Examples
Aggregated Calculations in Tableau
Creating Calculations From Shelfs
Calculation Edits, Identifications

Ch 5 : STRING, DATE FUNCTIONS

String Functions in Tableau
ASCII, CHAR, LEN, ENDSWITH
FIND, FINDNTH, LEFT, CONTAINS
LOWER, UPPER, LTRIM, RTRIM
MID, MIN, REPLACE, RIGHT
SPACE, SPLIT, UPPER, MAX
STARTSWITH, AND, CASE
ELSE, ELSEIF, END, IF, IIF
IFNULL, ISDATE, ISNULL, MAX
MIN, NOT, OR, THEN, WHEN, ZN
DATEADD, DATEDIFF, DATENAME
DATEPART, DATETRUNC, DAY
ISDATE, MAKEDATE, MONTH
NOW, QUARTER, TODAY, YEAR

Ch 6 : TABLE, LOD CALCULATIONS

Calcualtions For Year, Quarter, Month
Custom Calculations, Data Appending
Custom Date and Time Formatting
Calculations Reuse and Edits
Date and Time Conversions To INT
Two Digit Conversions with Date
Table Functions with Tableau
Running Total and Row Number
Case Statements, FIRST, LOOKUP
Table Calculations, Level of Details
Real-time Use of Table Calculations
Partitioning, Addressing Benefits
LOD : Types of Level Of Detail
FIXED LOD Expressions – Examples
INCLUDE LOD Expressions – Examples
EXCLUDE LOD Expressions – Examples

Part 2: Tableau Report Design – 2

Ch 7 : TABLEAU VIZ – LEVEL 1

Tableau Visualizations – Types
Visualization Categories, Usage
Tableau Bar Charts and Types
Simple Bar Charts and Usage
Horizontal & Colored Bar Charts
Stacked Bar Charts, Measures
Side By Side Bar Charts and Use
Interactive Bar Charts & Filters
Line Charts and Data Points
Continous Line Charts and Usage
Discrete Line Charts and Usage
Dual Line Chart and Types
Area Charts : Discrete, Continous
Stacked Area Charts, Reports
Combine Area Charts & Line Charts

Ch 8 : TABLEAU VIZ – LEVEL 2

Tableau Pie Charts, Real-time Use
Simple Pie Charts – Examples
Stacked Pie Charts – Examples
Side By Side Pie Charts
Reverse Rows and Row Count
Donut Charts and Agle Properties
Inner / Outer Pie Charts, Stacking
Drill-down Pie Charts and Usage
CrossTab Charts and Text Properties
Rows, Columns and Marks : Text
Conditional Formatting, Divergence
Using Quick Claculations in Tableau
Highlight Tables and Color Palettes
Box & Wishker Plots – Text Tables
Heat Maps and Real-time Usage
Size Controls and Color Options

Ch 9 : TABLEAU VIZ – LEVEL 3

Tableau Treemaps & Nested Rectangles
Marks Type, Color, Size and Label
Comparing Treemaps with Bars & Tables
Circle View Vizualization and Usage
Side By Side Circle View, Usage
Scatter Plot – Labels, Axis Items
Packed Bubbles and Circles – Lables
Tableau Symbol Maps – Examples
Tableau Filled Maps – Examples
Using Quick Table Calculations
Histogram Charts and Properties
Measures and Value Comparisions
Tableau Motion Charts and Axis
Bullet Graphs and Limitations
Dimension – Measure Considerations

Ch 10 : TABLEAU FILTERS

Tableau Filters – Types & Usage
Extract Filters and TDE (hyper)
Data Source Filters (twb Files)
String and Numerical Data Fields
Date/ Time Data Fields, Usage
All Rows, Too & Bottom Rows
Aggregated Extracts and Usage
Extract History, TDE Files
Context Fitlers and Realtime Use
Context Filters: Performance Benefit
Dimension Filters & Limitations
Measure Filters and Aggregations
Measure Name Filters, Measure Values
Table Calculation Filters, Usage
Tableau Filters – Execution Order
Fiters Scope and Quick Filters

Ch 11 : PARAMETERS, SETS

Tableau Parameters – Working
Creating Parameters, Conditions
Linking Parameters to Calculations
Using Calculations in Fields/View
Dynamic Filters using Parameters
Dynamic Dimension using Parameters
Dynamic Measures using Parameters
Creating, Using Sets in Tableau
IN and OUT Concepts in Sets
Working with Filters and Sets
Show Set Options and Exclude
Comparing Tableau Sets & Groups
Comparing Tableau Sets & Hierarchies
Dynamic Sets : Creation & Usage

Ch 12 : TABLEAU FORECASTS, ACTIONS

Tableau Trend Lines and Usage
Reference Lines and Show Data
Forecasts, Exponential Smooting
Creating and Using Forecasts
Describing, Controlling Forecasts
Adding / Editing Bookmarks
Using Data Analytics in Tableau
Tableau Actions and Real-time Use
Tableau Action Types, Limitations
Filter Actions: Static/Dynamic
Highlight Actions, Dynamic Types
URL and Parameter Action Types
Set Actions, Runtime Actions
Tableau Actions & Dashboards
Use Field and Filter Actions

Part 3: Tableau Prep, Server, Online

Ch 13 : DASHBOARDS & STORIES

Dashboards and Stories in Tableau
Bulding Dashboards – Views, Sheets
Dashboard Size, Views, Objects
Legends and Quick Filters in Tableau
Tiles, Floating Layouts in Tableau
Layout Containers, Images, Web Pages
Dashboard Extensions, Management
API Extensions – Usage in Tableau
Device Designer – Default Layout
Adding and Customizing Layouts
Story Points – Creation and Updates
Bollinger Bands – Views, Summary
Data Cleansing – Bulk Re-aliasing
Tableau Prep : Installation ETL
Tableau Desktop Store, Server Store

Ch 14 : TABLEAU SERVER

Tableau Server – Architecture
Tableau Server – Installation Process
Publish Tableau Workbook, Verify
Sharing Options and Layouts
Adding Device Layouts in Tableu Server
Adding Custom Layouts in Tableau Server
Adding Content to Custom Layouts
Java Script API in Table Server
Tableau Online Versus Table Server
Security Advantages @ Tableau Server
Tableau Online – Architecture
Publish Tableau Workbook, Verify
Sharing Options and Layouts
Adding Device Layouts in Tableu Online
Adding Custom Layouts in Tableau Online
Adding Content to Custom Layouts
Security Advantages @ Tableau Online

Ch 15 : Colloborate TABLEAU ONLINE

Tableau Online – Purpose, LIVE Reports
Projects and Workbooks in Tableau Online
Tableau Report Views in Tableau Online
Searching Content, Data Sources, Sites
Account Settings, Drill Down, Actions
Custom Views, Comments – Tableau Online
Downloads, Exports – Tableau Online
Sharing, Subscription and favorites
Web Authoring, Edits and Publish Online
Data Driven Alerts – Refining, Managing
Stacked Bars and Views For Alerting
Navigations, Snapshots, Searching
Mobile Reports – Phone Marks and Maps
Interacting with Content on Tableau Online

Ch 16: Colloborate TABLEAU SERVER

Tableau Server – Purpose, LIVE Reports
Projects, Workbooks in Tableau Server
Tableau Report Views in Tableau Server
Searching Content, Data Sources, Sites
Account Settings, Drill Down, Actions
Custom Views, Comments in Tableau Server
Downloads and Exports in Tableau Server
Sharing, Subscription and favorites
Web Authoring, Edits and Publish Online
Data Driven Alerts – Refining, Managing
Stacked Bars, Alerting Views in Server
Navigations, Snapshots, Searching in Server
Mobile Reports – Phone Marks and Maps
Interacting with Content on Tableau Server

Ch 17 : MANAGE TABLEAU SERVER

Tableau Server – Administration Concepts
Tableau Sites, Users, Groups Security
Group Rules, Web Edits in Tableau Server
Project Permission and Locking Options
Data Security with user Filters in Server
user Filters and Hybrid Models in Server
Access Roles, Schedules, Extraction
TSM : Tableau Services Manager
TSM Configuration for Real-time Use
Browser, Maintenance, GUI and CLI
Backups and Restores with Tableau TSM
TSM Upgrades For Tableau Report Config
Tabcmd : Command Line Utility – Imports
Tabcmd : user Import via CSV File
Comparing Tableau & Microsoft Power BI

Ch 18 : REAL-TIME PROJECT

Project Requirement Analysis
Implementing SDLC Phases
Requirement Gathering, FSA

Phase 1:

TABLEAU Report Design
Visualizations, Properties
Analytics and Formating

Phase 2:

Data Modeling, Tableau Prep
Dynamic Connections, Azure DB
Parameters and VizQL Scripts

Phase 3:

Tableau Online Analysis
Cloud and Tableau Server
Project FAQs and Solutions

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Tableau Training FAQs

What is Tableau Job Role?

A Tableau Developer / Analyst is responsible for creating interactive dashboards, reports, and data visualizations that help businesses make data-driven decisions. The role involves connecting to various data sources, transforming data, building meaningful KPIs and charts, and delivering insights through engaging visual storytelling. Tableau professionals collaborate closely with data engineers, business stakeholders, and analysts to design secure, scalable, and insightful BI solutions.

What are the Job Roles of a Tableau Professional?

1️⃣ Connect to various data sources (databases, cloud, Excel, APIs)
2️⃣ Design and develop dashboards, reports, and visual analytics
3️⃣ Implement calculations, parameters, filters, and actions for interactive reports
4️⃣ Optimize workbook performance and design best practices
5️⃣ Apply Row-Level Security (RLS) and permissions to protect sensitive data
6️⃣ Collaborate with teams to gather requirements and deliver BI solutions and more ..!

What does our Tableau Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: Microsoft SQL (TSQL)
👉🏻Module 2: Tableau

Who can join this course?

Freshers starting a career in data analytics and BI
SQL / Excel professionals wanting to upskill in data visualization
Business analysts who want to master Tableau for reporting
Data engineers integrating Tableau into data pipelines
Anyone interested in transforming data into insights

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1: LIVE Online Training (100% Interactive, step by step, assignments)

Option 2: Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for Tableau training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice. Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Why Choose SQL School

100% Real-Time and Practical
ISO 9001:2008 Certified
Concept wise FAQs
TWO Real-time Case Studies, One Project
Weekly Mock Interviews
24/7 LIVE Server Access
Realtime Project FAQs
Course Completion Certificate
Placement Assistance
Job Support
Realtime Project Solution
MS Certification Guidance