Ch 1: Data Analyst Job Roles 

• Introduction to Data
• Data Analyst Job Roles
• Data Analyst Challenges
• Data and Databases Intro
• Power BI & Data Concepts

Ch 2: Database Intro & Installations 

• Database Types (OLTP, DWH,..)
• DBMS: Basics
• SQL Server 2025 Installations
• SSMS Tool Installation
• Server Connections, Authentications

Ch 3: SQL Basics V1 (Commands) 

• Creating Databases (GUI)
• Creating Tables, Columns (GUI)
• SQL Basics (DDL, DML, etc..)
• Creating Databases, Tables
• Data Inserts (GUI, SQL)
• Basic SELECT Queries

Ch 4: SQL Basics V2 (Commands, Operators) 

• DDL: Create, Alter, Drop, Add, modify, etc..
• DML: Insert, Update, Delete, select into, etc..
• DQL: Fetch, Insert… Select, etc..
• SQL Operations: LIKE, BETWEEN, IN, etc..
• Special Operators

Ch 5: Data Types 

• Integer Data Types
• Character, MAX Data Types
• Decimal & Money Data Types
• Boolean & Binary Data Types
• Date and Time Data Types
• SQL_Variant Type, Variables

Ch 6: Excel Data Imports 

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

Ch 7: Schemas & Batches 

• Schemas: Creation, Usage
• Schemas & Table Grouping
• Real-world Banking Database
• 2 Part, 3 Part & 4 Part Naming
• Batch Concept & “Go” Command

Ch 8: Constraints, Keys & RDBMS – Level 1 

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

Ch 9: Normal Forms & RDBMS – Level 2 

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

Ch 10: Joins & Queries 

• Joins: Table Comparisons
• Inner Joins & Matching Data
• Outer Joins: LEFT, RIGHT
• Full Outer Joins & Aliases
• Cross Join & Table Combination
• Joining more than 2 tables

Ch 11: Views & RLS 

• Views: Realtime Usage
• Storing SELECT in Views
• DML, SELECT with Views
• RLS: Row Level Security
• WITH CHECK OPTION
• Important System Views

Ch 12: 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 13: User Defined Functions 

• Using Functions in MSSQL
• Scalar Functions in Real-world
• Inline & Multiline Functions
• Parameterized Queries
• Date & Time Functions
• String Functions & Queries
• Aggregated Functions & Usage

Ch 14: Triggers & Automations 

• Need for Triggers in Real-world
• DDL & DML Triggers
• For / After Triggers
• Instead Of Triggers
• Memory Tables with Triggers
• Disabling DMLs & Triggers

Ch 15: Transactions & ACID 

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

Ch 16: CTEs & Tuning 

• Common Table Expression
• Creating and Using CTEs
• CTEs, In-Memory Processing
• Using CTEs for DML Operations
• Using CTEs for Tuning
• CTEs: Duplicate Row Deletion

Ch 17: Indexes Basics, Tuning 

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

Ch 18: 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 19: 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 20: Sub Queries 

• Sub Queries Concept
• Sub Queries & Aggregations
• Joins with Sub Queries
• Sub Queries with Aliases
• Sub Queries, Joins, Where
• Correlated Queries

Ch 21: Cursors & Fetch 

• Cursors: Realtime Usage
• Local & Global Cursors
• Scroll & Forward Only Cursors
• Static & Dynamic Cursors
• Fetch, Absolute Cursors

Ch 22: Window Functions, CASE 

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

Ch 23: Merge(Upsert) & CASE, IIF 

• Merge Statement
• Upsert Operations with Merge
• Matched and Not Matched
• IIF & CASE Statements
• Merge Statement inside SPs
• Merge with OLTP & DWH

Ch 24: Realtime Case Studies 

• Case Study 1: Medicare: Tasks, Solutions
• Case Study 2: ECommerce: Task, Solutions

Ch 1: Power BI Intro, Installation 

• Power BI & Data Analysis
• 5 Design Tools, 3 Techniques
• 2 Hosting Solutions
• Power BI with Co-Pilot & AI
• Power BI Installation

Ch 2: Report Design Concepts 

• Basic Report Design (PBIX)
• Get Data, Canvas (Design)
• Data View, Data Models
• Data Points, Spotlight
• Focus Mode, PDF Exports

Ch 3: Visual Interactions, PBIT 

• Visual Interactions & Edits
• Limitations with Visual Edits
• Creating Power BI Templates
• CSV Exports & PBIT Imports

Ch 4: Grouping, Hierarchies 

• 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
• 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

Ch 7: Filters & Drill Thru 

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

Ch 8: Bookmarks, Buttons 

• Power BI Bookmarks
• 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
• Azure (Big Data) Access & Formatting

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
• Missing Values, Duplicate Records
• Wrong Data Types, Outliers
• Close, Apply & Visualize

Ch 12: Power Query: Table Transformations 

• Table Duplicate, Header Promotion
• Group By Transformation
• Aggregate, Pivot Operation
• Reverse Rows, Count Rows
• Advanced Power Query Mode
• Data Cleaning, Null Handling

Ch 13: Power Query: Column Transformations 

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

Ch 14: Power Query: Text, Date Transformations 

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

Ch 15: Power Query: Parameters, Expressions 

• Parameters in Power Query
• Static Parameters, Defaults
• Dynamic Dropdowns, Lists
• Linking with Table Queries
• Step Edits, Type Conversions
• API & Web Data Sources

Ch 16: Power BI Cloud & Fabric 

• Power BI Cloud, Microsoft Fabric
• Microsoft Fabric Concepts
• Fabric One Lake
• Fabric Warehouse
• Fabric LakeHouse
• Fabric Analytics

Ch 17: Power BI Cloud Deployments 

• Microsoft Fabric Workspace
• Report Publish Cloud
• Power BI Desktop Connections
• Report Uploads (PBIX)
• Report Edits
• Semantic Models & Usage

Ch 18: Power BI Cloud Dashboards 

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

Ch 19: Power BI Cloud Operations 

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

Ch 20: Power BI Cloud Gateways 

• Data Gateways, Data Refresh
• Install, Configure Gateways
• Data Refresh & Scheduling
• Gateway Optimizations
• Incremental Refresh
• Large Dataset Optimization

Ch 21: Power BI Cloud Apps 

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

Ch 22: Power BI Report Server 

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

Ch 23: Paginated Reports 

• Report Builder Tool
• Paginated Report (RDL)
• Report Expressions (RDL)
• Tablix, Chart Wizards
• Fields & Drill-Down
• RDL Report Publish

Ch 24: DAX Concepts (Basics) 

• DAX Concepts: Intro & Realtime Need
• DAX Columns: Creation, Use
• DAX Measures: Creation, Use
• DAX Functions: IIF, ISBLANK
• SUM, CALCULATE Functions

Ch 25: DAX Quick Measures 

• Quick Measures in Power BI
• Running Totals
• Star Rating Calculations
• DAX Measures in Data View
• DAX in Cloud Reports

Ch 26: Data Modelling, DAX 

• Dimensions Tables
• Fact Tables & DAX Measures
• Data Models & DDAX Joins
• Star & Snowflake Schemas
• Many-to-Many Relationships
• Composite Models
• Calculation Groups
• Field Parameters, Aggregations

Ch 27: DAX Joins, Variables 

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

Ch 28: DAX Models & Calculations 

• VAR, SWITCH
• SUMMARIZE
• ADDCOLUMNS
• TREATAS
• USERELATIONSHIP
• CROSSFILTER
• GENERATE
• RANKX, TOPN
• WINDOW
• OFFSET, INDEX

Ch 29: 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 30: DAX – Row Level Security 

• RLS: Row Level Security
• Data Modelling & Roles
• Add Cloud Users to Roles
• Dynamic Row Level Security

Ch 31: KPI Design 

• Revenue
• Profit & Margin
• Customer Retention
• Churn
• Conversion Rate
• Sales Growth
• ROI
• YoY Growth
• MoM Growth

Ch 32: Analytical Reports & AI 

• Analytical Report Concepts
• Excel with Power BI Cloud
• SQL, AVRO, JSON Sources
• Analyse in Excel (Cloud)
• Excel Reports to Cloud

Ch 33: Analytical Reports & AI – 2 

• AI Fundamentals
• AI in Realtime
• Microsoft Copilot
• Copilot Architecture
• Copilot with Power BI Desktop
• CoPilot in Power BI Cloud

Ch 34: Analytical Reports & AI – 3 

• Key Influencers
• Decomposition Tree
• Smart Narrative
• Q&A Visual
• Anomaly Detection
• Forecasting
• AI Visuals
• Azure AI Integration

Ch 35: PL-300 Exam Guidance 

• PL-300 Exam Guidance
• Exam Samples
• Exam Scenarios
• Fabric Integrations
• Azure Integrations

CH 1: TABLEAU INTRO, INSTALLATION 

• Introduction to Tableau
• Report Types in Real-time
• Data Sources for Report Design
• Tableau as a Self Service BI
• Tableau Features
• Power BI Licensing Plans

CH 2: TABLEAU ARCHITECTURE 

• Data Sources, Connectors
• Tableau Clients
• Tableau Server Components
• VizQL Server & Data Engine
• Backgrounder, Data Server
• Fast Data Engine
• Gateway Components

CH 3: TABLEAU INTRO, INSTALLATION 

• Tableau Public Desktop
• Report Development
• Data Sources Types
• Tableau Prep Tools
• Data Modelling
• Drilldown Reports

CH 4: TABLEAU REPORTS & JOINS 

• Data Search
• Alias, Bins, Workbooks
• Bookmarks, Calculations
• Tableau File Type
• Pages, Rows, Columns
• Joins in Tableau Sources
• Inner, Left / Right Outer Joins

CH 5: TABLAU REPORT DESIGN 

• Cross Tabs, Dashboards,
• Visual Sync
• Sets, Marks, Workbooks
• Data Pane, Dimensions
• Extract, Filters

CH 6: BIG DATA ACCESS, BLENDING 

• SQL Data Access
• Remote Data Sources
• Remote Joins
• SQL Queries in Tableau
• Data Blending
• Multiple Data Sources
• Combine, Aggregations
• Data Grouping
• Tableau Operators

CH 7: TABLEAU CALCULATIONS 

• Tableau Calculations
• Numerical Calculations
• Aggregated Calculations
• Calculations From Shelves
• Calculation Edits, Identifications

CH 8: STRING, DATE FUNCTIONS 

• Tableau Functions
• String Functions
• Date Functions
• Time Functions
• Aggregation Functions
• Other Functions

CH 9: TABLE CALCULATIONS 

• Calculations For Year, Quarter, Month
• Custom Calculations
• Data Appending
• Custom Date and Time Formats
• Calculations Reuse and Edits
• Date and Time Conversions
• Running Total
• Row Number, Case Statements

CH 10: LOD CALCULATIONS 

• Table Calculations
• Level of Details
• Table Calculations
• Partitioning, FIXED LOD
• INCLUDE LOD Expressions
• EXCLUDE LOD Expressions

CH 11: TABLEAU VISUALIZATIONS – 1 

• Tableau Visualizations
• Tableau Bar Charts
• Horizontal & Colored Charts
• Interactive Charts & Filters
• Continuous Charts
• Dual Line Chart, Area Charts
• CrossTab Charts, Pie Charts

CH 12: TABLEAU VISUALIZATIONS – 2 

• Divergence, Color Palettes
• Box & Wishker Plots
• Text Tables;
• Heat Maps, Treemaps
• Motion Charts
• Bullet Graphs

CH 13: TABLEAU FILTERS 

• Tableau Filters
• Extract Filters, TDE (hyper)
• twb Files, History, TDE
• Context Filters
• Dimension Filters
• Measure Filters
• Filters Scope and Quick Filters

CH 14: PARAMETERS, SETS 

• Tableau Parameters
• Parameters, Conditions
• Calculations, Dynamic Filters
• Dynamic Dimensions
• Dynamic Measures With Sets
• IN and OUT Concepts

CH 15: TABLEAU FORECASTS, ACTIONS 

• Tableau Trend Lines
• Reference Lines
• Forecasts, Exponential Smoothing
• Forecasts, Bookmarks
• Tableau Action Types
• Static/Dynamic Actions
• URL and Parameter Action Types
• Tableau Actions & Dashboards

CH 16: DASHBOARDS & STORIES 

• Dashboards and Stories
• Building Dashboards
• Legends and Quick Filters
• Floating Layouts
• Layout Containers
• Dashboard Extensions, API
• Device Designer
• Customizing Layouts
• Bollinger Bands

CH 17: Tableau Prep 

• Installation ETL
• Tableau Desktop Store
• Server Store

CH 18: TABLEAU SERVER 

• Tableau Server – Architecture
• Installation Process
• Workbook, Sharing and Layouts
• Custom Layouts
• Tableau Online Vs Table Server
• Device Layouts in Tableau Online

CH 19: COLLOBORATE TABLEAU ONLINE 

• Tableau Online, LIVE Reports
• Projects and Workbooks
• Report Views in Tableau Online
• Searching Content
• Account Settings, Drill Down
• Sharing, Subscription
• Web Authoring
• Phone Marks and Maps

CH 20: MANAGE TABLEAU SERVER 

• Tableau Server – Administration Concepts
• Tableau Sites, Users, Groups Security
• Group Rules, Web Edits
• Project Permission and Locking
• Data Security with user Filters
• Filters and Hybrid Models in Server
• Access Roles, Schedules, Extraction
• TSM : Tableau Services Manager
• GUI and CLI; Backups and Restores
• Tabcmd : Imports; Tabcmd

This course is ideal for data analysts, BI developers, Excel/SQL professionals, and freshers with basic analytical skills who want to move into a senior analytics role by mastering SQL, Power BI, and Tableau together.

The course runs for 3 months and covers 4 modules — SQL Server (T-SQL), Power BI with AI & Copilot, Tableau, and a Realtime Enterprise Project.

No prior experience is required. The course starts from SQL Server basics (Ch 1–2) and progressively builds up to advanced topics like DAX, Power Query, and Tableau Server administration.

You’ll learn SQL Server (T-SQL), Power BI (including AI, Microsoft Copilot, DAX, Power Query, and Cloud deployments), and Tableau Desktop & Server — a rare combination that most institutes teach separately.

Yes, Module 4 includes an end-to-end Enterprise Project covering a healthcare domain business case, with deliverables like Tableau workbooks, SQL scripts, a Business Requirement Document (BRD), KPI documentation, and resume points.

Yes — the program includes mock interviews, resume optimization, LinkedIn optimization, ATS-friendly resume building, salary negotiation guidance, interview strategy, and job assistance/placement support.

This module covers standard Power BI reporting plus AI-driven features like Key Influencers, Decomposition Tree, Smart Narrative, Anomaly Detection, Forecasting, and Microsoft Copilot integration — along with PL-300 exam guidance.