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

✅ Tableau Desktop Reports
✅ Tableau Server & Hosting
✅ Tableau Prep (Mashup)
✅ Functions, Blending
✅ Interactive Dashboards
✅ Advanced Charts in Big Data
✅ AI Based Visual Analytics
✅ Integrations: SQL, Python
✅ Real Time Project
✅ 1:1 Mentorship, Resume

Tableau Training
Course Contents:

Brochure Download Register Now

Module 1: Tableau

Ch 1: Tableau Intro, Installation

Introduction to Reports, Tableau
Report Types, Data Sources
Basic Understanding, Workflow
Tableau as a Self-Service BI Tool
Tableau Features, Advantages
Tableau Public Desktop Tableau Prep Tools – Modelling
Tableau Training Course Plan, Lab
Study Material, Certifications

Ch 2: Basic Report Design

Tableau Public Desktop
Worksheet Creation, Options
Row Shelf & Column Shelf
Text, Detail, Tooltip, Colours
VizQL , Dimension, Measures
Marks, Shelves, Axis
Grouping on Static Data
Dynamic Data Grouping
Hierarchies: Real-time Use

Ch 3: Architecture, Joins

Drilldown Reports
Data Sources, Connectors
Tableau Server Components
VizQL Server, Data Engine
Fast Data Engine, Gateway
Alias, Bins, Bookmarks
Dashboards, Data Pane
Data Source and Dimensions
Using Joins in Tableau

Ch 4 : Big Data Access, Blending

Azure SQL Database Access
Remote Data Sources and Joins
Using SQL Queries in Tableau
Use Azure SQL Warehouse
Data Blending in Tableau
Reports with Multiple Sources
Data Combination, Aggregation
Show Data & Data Grouping
Tableau Operators and Functions
Tableau Calculations and Formats
Calculations From Shelves

Ch 5: String, Date Functions

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
DATEPART, DATETRUNC, CH
ISDATE, MAKEDATE, MONTH
NOW, QUARTER, TOCH, YEAR

Ch 6: Table, LOD Calculations

Custom Calculations, Appends
Custom Date, Time Formatting
Calculations Reuse and Edits
Date and Time Conversions
Two Digit Conversions
Table Functions with Tableau
Running Total, Row Number
Case, FIRST, LOOKUP
Calculations, Level of Details
Partitioning, LOD
FIXED, INCLUDE, EXCLUDE

Ch 7: Tableau Viz – Level 1

Tableau Visualizations – Types
Tableau Bar Charts and Types
Horizontal, Coloured Bar Charts
Stacked Bar Charts, Measures
Side By Side Bar Charts and Use
Interactive Bar Charts & Filters
Continuous & Discrete Charts
Dual, Area, Stacked, Combined

Ch 8: Tableau Viz – Level 3

Pie, Stacked Pie Charts
Side By Side Pie Charts
Reverse and Row Count
Donut Charts and Angle
CrossTab Charts, Drill Downs
Conditional Formatting
Quick Calculations, Wishker
Heat Maps in Real-time

Ch 9: Tableau Viz – Level 3

Treemaps, Nested Rectangles
Marks Type, and Label
Treemaps with Bars & Tables
Circle View Visualization
Scatter Plot, Packed Bubbles
Symbol Maps, Filled Maps
Histograms, Motion Charts
Bullet Graphs, Dimensions

Ch 10 : Tableau Filters

Tableau Filters – Types & Usage
Extract Filters, TDE (hyper)
Data Source Filters (twb Files)
Extract History, TDE Files
Context Filters and Performance
Measure Filters and Aggregations
Filters Scope and Quick Filters

Ch 11: Parameters & Sets

Tableau Parameters
Link Parameters, Calculations
Calculations in Fields/View
Dynamic Filters & Dimension
Dynamic Measure, Parameters
Sets: IN and OUT, Filters
Sets & Groups & Hierarchies

Ch 12: Forecasts, Actions

Trend Lines, Reference Lines
Forecasts, Smoothing
Adding / Editing Bookmarks
Data Analytics in Tableau
Tableau Actions and Types
Filter Actions: Static/Dynamic
Highlights, Dynamic Types

Ch 13: Dashboards & Stories

Dashboards and Stories
Building Dashboards
Dashboard Size, Views, Objects
Legends and Quick Filters
Tiles, Layouts, Containers
Dashboard Extensions, APIs
Story Points, Bollinger Bands
Data Cleansing – Tableau Prep

Ch 14: Tableau Server

Tableau Server – Architecture
Tableau Server – Installation
Publish Workbook, Shares
Device & Custom Layouts
Java Script API in Server
Tableau Online Vs Server
Security Advantages
Adding Custom Layout

Ch 15: Tableau Online

Tableau Online: LIVE Reports
Projects and Workbooks
Tableau Report Views
Custom Views, Comments
Downloads, Exports
Share, Subscribe, favourites
Web Authoring, Publish Online
Alerts,Snapshots,Phone Marks

Ch 16: Collaborate Tableau

Collaborate Tableau Server
Account Settings, Drill Down
Custom Views, Comments
Downloads and Exports
Sharing, Subscription
Web Authoring, Edits
Data Driven Alerts
Stacked Bars, Alerting Views
Navigations, Snapshots
Interacting with Content

Ch 17: Manage Tableau

Administration Concepts
Tableau Sites, Users, Groups
Permissions & Locking
Data Security & Filters
Access Roles, Extraction
Tableau Services Manager
Browser, Maintenance, CLI
TSM Backups and Restores
TSM Upgrades for Tableau
Tabcmd & Realtime Use

Ch 18th: Realtime Project

Phase 1:
Tableau Report Design;
Visualizations; Analytics, Formatting;
Phase 2:
Data Modelling, Tableau Prep;
Dynamic Connections, Azure DB;
Parameters and VizQL Scripts
Phase 3:
Cloud and Server;
Project FAQs and Solutions

Module 2: Database Basics, SQL Server & T-SQL Concepts

Ch 1: Database Intro & Job Roles

Database Introduction
Database Types: OLTP, DWH
DBMS & Realtime Use
DBMS Software & Purpose
SQL : Purpose & Use
SQL Server Versions, Editions
Job Roles & Responsibilities

Ch 2: SQL Server Installations

SQL Server 2022 Installations
SQL Server 2019 Installations
SSMS Tool Installation
Server Connections, Properties
Instance & Instance Types
Authentication Types
System Databases & Purpose

Ch 3: SQL Basics V1 (Commands)

Database, Tables & Columns
SQL Basics: Purpose
DDL Statements
DML Statements
DQL Statements
Verifications @ GUI
Basic SELECT Queries

Ch 4: SQL Basics V2 (Operators)

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

Ch 5: Excel Data Imports

Data Imports with Excel
SQL Native Client
Order By: Asc, Desc
Order By with WHERE
TOP & OFFSET
UNION ALL
UNION, Data Appends

Ch 6: Schemas & Security

Schemas: Creation, Usage
Schemas & Table Grouping
Using Default Schema
Real-world Banking Database
Table Migrations @ Schemas
2 Part, 3 Part & 4 Part Naming
Verifying Schemas in UI

Ch 7: Constraints & Keys Basics

Need for Constraints, Keys
Null, Not Null Constraints
Unique Key Constraint
Primary Key Constraint
Foreign Key & References
Default Constraint & Usage
DB Diagrams & ER Models

Ch 8: Indexes Basics, Tuning

Indexes & Tuning
Clustered Index, Primary Key
Non Clustered Index & Unique
Creating Indexes Manually
Verifying Indexes
Composite Keys, Query Optimizer
Composite Indexes & Usage

Realtime Case Study 1

Ch 9: Joins Basics

Joins: Table Comaparisons
Inner Joins & Matching Data
Outer Joins: LEFT, RIGHT
Full Outer Joins & Audits
Cross Joins & Table Combinations
Joining more than 2 tables
Joining Tables with Aliases

Ch 10: Views & RLS

Views: Realtime Usage
Storing SELECT in Views
DML, SELECT with Views
RLS: Row Level Security
WITH CHECK OPTION
Database Audits & Metadata
Important System Views

Ch 11: Stored Procedures

Stored Procedures: Realtime Use
Parameters Concept with SPs
Procedures with SELECT
System Stored Procedures
Metadata Access with SPs
SP Recompilations
Stored Procedures, Tuning

Ch 12: User Defined Functions

Using Functions in MSSQL
Scalar Value Functions
Inline & Multiline Functions
Parameterized Queries
Date & Time Functions
String Functions & Queries
Aggregated Functions & Usage

Ch 13: Triggers & Automations

Need for Triggers
DDL & DML Triggers
For / After Triggers
Instead Of Triggers
Memory Tables with Triggers
Data Replication, Automation
Disabling DMLs & Triggers

Ch 14: Transactions & ACID

Transaction Concepts in OLTP
Transaction Types in Realtime
Auto Commit, Explicit Transaction
COMMIT, ROLLBACK
Checkpoint & Logging
Lock Hints & Query Blocking
READPAST, LOCKHINT

Ch 15: Cursors & Fetch

Cursors: Realtime Usage
Cursor Declaration Types
Open Cursor, Close Cursor
Local & Global Cursors
Scroll & Forward Only Cursors
Static & Dynamic Cursors
Fetch, Absolute Cursors

Ch 16: CTEs & Tuning

CTE: Common Table Expression
Creating and Using CTEs
CTEs and In-Memory Processing
Using CTEs for DML Operations
Using CTEs for Data Retrieval
Using CTEs for Tuning
CTEs For Duplicate Row Deletion

Realtime Case Study 2

Ch 17: Relations, Normal Forms

Adding PK to Tables
Adding FK to Tables
Cascading Keys
Self Referencing Keys
Database Diagrams
Normal Forms : 1 NF, 2 NF
3 NF, BCNF and 4 NF

Ch 18: Self Joins, EXISTS

Joining same table
Correlated Queries
Joining Tables, Queries
Self Joins with WHERE
Self Joins with UNION
Self Joins with Order By
Self Joins with Views

Ch 19: Remote Joins

Working with Multiple Servers
Multi Server Access from SSMS
Linked Servers Creation, Tests
4 Part Naming Convention
Remote Data Access
RPC & RPC OUT
Remote Joins & Data Analysis

Ch 20: Sub Queries

Sub Queries Concept
Sub Queries & Aggregations
Joins with Sub Queries
Sub Queries with Aliases
Sub Queries with OrderBy
Sub Queries with WHERE
Sub Queries, Joins, Where

Ch 21: Group By Queries

Group By, Distinct Keywords
GROUP BY, HAVING
Cube( ) and Rollup( )
Sub Totals & Grand Totals
Grouping( ) & Usage
Group By with UNION
Group By with UNION ALL

Ch 22: Joins with Group By

Joins with Group By
3 Table, 4 Table Joins
Join Queries with Aliases
Join Queries & WHERE
Join Queries & Group By
Joins with Sub Queries
Query Execution Order

Ch 23: Data Types & Conversions

Integer Data Types
Character, MAX Data Types
Decimal & Money Data Types
Boolean & Binary Data Types
Date and Time Data Types
Table, SQL_Variant Types
Cast( ) and Convert( ) Functions

Ch 24: Window Functions, CASE

IIF Function and Usage
IIF with Tables, Joins
CASE Statement Usage
Window Functions (Rank)
Row_Number( )
Rank( ), DenseRank( )
Partition By & Order By

Realtime Case Study 3

Module 3: Power BI (Reports, Cloud, Server)

Ch 1: Power BI Intro, Installation

Power BI Eco System
Report Types & Usage
Power BI Tools, Cloud
Power BI Components
Power Query (M), DAX
Power BI: Co-Pilot & AI
Power BI Installations

Ch 2: Report Design Concepts

Basic Report Design (PBIX)
Get Data, Canvas (Design)
Data View, Data Models
Data Points, Aggregations
Focus Mode, Spotlight
PDF Exports From Power BI
ToolTip, PBIX Reports

Ch 3: Visual Interactions, PBIT

Data View Concepts
Visual Interactions & Edits
Limitations with Visual Edits
Creating Power BI Templates
CSV Exports & PBIT Imports
Optimizing Power BI : Caching
PBIX Versus PBIT

Ch 4: Grouping, Hierarchies

Power BI : Field Values
Field Value Groups
Creating Groups : Lists
Creating Groups: Bins
List Items & Group Edits
Bin Size & Bin Count

Ch 5: Slicer & Visual Sync

Slicer Visual in Power BI
Slicer: Format Options
Single Select, Multi Select
Slicer: Select All On / Off
Integer, Character Slicers
Visual Sync with Slicers

Ch 6: Hierarchies & Drill-Down

Hierarchies: Creation, Use
Hierarchies: Advantages
Drill Up, Drill Down
Conditional Drill Down
Filtered Drill Down
Table View of Data Points

Ch 7: Filters & Drill Thru

Power BI Filters
Basic, Top & Advanced
Visual Filters, Page Filters
Report Level Filters
Clear Filter Options, Resets
Drill Thru Filters & Usage

Ch 8: Bookmarks, Buttons

Power BI Bookmarks
Bookmarks Creation, Use
Images: Actions, Bookmarks
Buttons: Actions, Bookmarks
Page to Page Navigations
Score Cards, Master Pages

Ch 9: SQL DB Access & Big Data

SQL DB Access , Queries
Storage Modes: Direct Query
Formatting & Date Time
Storage Modes in Power BI
Storage Modes & Formatting
Azure (Big Data) Access

Ch 10: Power BI Visualizations

Charts, Bars, Lines, Area
TreeMaps & HeatMaps
Funnel, Card, Multrow Card
PieCharts & Waterfall
Scatter Chart, Play Axis
Infographics, Classifications

Ch 11: Power Query Introduction

Power Query (Mashup)
ETL Transformations in PBI
Power Query Expressions
Table Combine Options
Merge, Union All Options
Close, Apply & Visualize

Ch 12: Power Query : Table Tfns

Table Duplicate, Reference
Group By Transformation
Aggregate, Pivot Operation
First Row as Header
Reverse Rows, Count Rows
Advanced Power Query Mode

Ch 13: Power Query: Column Tfn

Any Column Transformations
Change Data Type
Detect Data Type
Rename, Replace, Move
Fill Up, Fil Down
Step Edits & Rollbacks

Ch 14: Power Query: Text, Date

String / Text Transformations
Split, Merge, Extract, Format
Numeric and Date Time
Add Column & Expressions
Expressions and New Columns
Column From Examples

Ch 15: Power Query: Parameters

Parameters in Power Query
Static Parameters, Defaults
Dynamic Dropdowns, Lists
Linking with Table Queries
Column From Examples
Step Edits, Type Conversions

Ch 16: Power BI Cloud: Publish

Power BI Cloud Concepts
Workspace Creation, Usage
Workspace Items
Report Publish Cloud
Report Edits in Cloud
Semantic Models & Usage

Ch 17: Power BI Cloud Dashboards

Power BI Dashboards
Dashboard Creation, Usage
Pin Visuals
Pin LIVE Pages
Add Image, Video Tiles
Q&A & Pin Tiles

Ch 18: Power BI Cloud Operations

Report Shares, Alerts
Subscriptions, Exploration
Downloads & Edits
Cloning in Cloud
QR Codes, Web Publish
Lineage & Metrics

Ch 19: Power BI Cloud Gateways

Data Gateways, Data Refresh
Install, Configure Gateways
Data Sources Configurations
Dataset Configurations
Data Refresh & Scheduling
Gateway Optimizations

Ch 20: Power BI Cloud Apps

Power BI Apps: Creation
App Sections & Content
Audience Options
App Security & Sharing
App Updates, Favorites
App URL, End User Access

Ch 21: Power BI Report Server

Power BI Report Server
Report Server Vs Cloud
Installation, Configuration
RS Config Tool Options
Report Database, TempDB
Web Service & Server URL

Ch 22: Paginated Reports

Report Builder Tool
Paginated Report (RDL)
SQL Database Access
SQL Queries For RDL
Tablix, Chart Wizards
Fields & Drill-Down
RDL Report Publish

Ch 23: DAX Concepts (Basics)

DAX Concepts (Introduction)
DAX : Realtime Use
DAX Columns: Creation, Use
DAX Measures: Creation, Use
DAX Functions: IIF, ISBLANK
SUM, CALCULATE Functions
DAX Cheat Sheet

Ch 24: DAX Quick Measures

Quick Measures in Power BI
Average & Filters
Running Totals
Star Rating Calculations
DAX Measures in Data View
DAX in Visuals
DAX in Cloud Reports

Ch 25: Data Modelling, DAX

Dimensions Tables
Fact Tables & DAX Measures
Data Models & Relations
DAX Expressions
Star & Snowflake Schemas
DAX Joins & Expressions

Ch 26: DAX Joins, Variables

CALCULATEX & Variables
COUNT, COUNTA, etc..
SUM, SUMX, etc..
SELECTED MEMEBER
Filter Context, RETRUN
Dynamic Report with DAX

Ch 27: DAX Time Intelligence

Need for Time Intelligence
Date Table Generation
Time Intelligence with DAX
PARALLELPERIOD, DATE
CALENDAR, Total Functions
YTD, QTD, MTD with DAX

Ch 28: DAX – Row Level Security

RLS: Row Level Security
Data Modelling & Roles
Verify Roles (Testing)
Add Cloud Users to Roles
Dynamic Row Level Security
Testing RLS in Power BI

Ch 29: Analytical Reports

Analytical Report Concepts
Excel Data Analytics
Excel with Power BI Cloud
SQL, AVRO, JSON Sources
Analyze in Excel (Cloud)
Excel Reports to Cloud

Ch 30: Introduction to CoPilot

AI Components in Power BI
Need for CoPilot
CoPilot Practical Uses
CoPilot with Desktop
CoPilot with Cloud
Need for AI Analytics (Fabric)

Ch 31: Realtime Project – Phase 1

Customer Requirement
Requirement Analysis
Project Planning
Creating Data Sheets
Creating Data Models
Scope of the Project
Data Sheets, Project Planning

Ch 32: Realtime Project – Phase 2

Report Design & Modelling
Power Query Implementation
DAX & Data Analytics
Power BI Cloud (Service)
Power BI Report Server
End User Take Aways
Implementation Phases

Ch 33: PL 300 Exam Guidance

PL 300 Exam Benefits
Data Analyst Exam Pattern
Type of Questions
Sample Questions, Answers
Mock Certification
Resume Guidance
Mock Interviews

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

Why Choose SQL Student learning coding on laptop in a futuristic environment representing career-focused database and data engineering training at 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