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: Python Introduction

• Python Introduction
• Python Versions
• Python for Data Analysts
• Python Architecture

Ch 2: Python Installations

• Python Introduction
• Python Installations
• Anaconda Installation
• Python IDE & Usage
• Jupyter Notebooks

Ch 3: Python Print Statement

• Python Print Statement
• print(), print()
• Testing Case Sensitivity
• Single Line, Multi Line prints
• print() with single quotations
• Debug with AI (AI Assistants)

Ch 4: Python Variables

• Python Variables
• Assigning values
• Variable Value Reads
• Multiple Variables & Print()

Ch 5: Python Operators

• Athematic Operators
• Python String Literals
• Single, Double Quotes
• Format Strings (f string)
• Comparison, Indexing Operators

Ch 6: Python Data Types

• Python Data Types
• Integer, Float, String Data Types
• Type Casting
• Type Identification
• Multi Value Assignments

Ch 7: Python Lists

• Creating Python Lists
• Printing List Items
• Print List Slices
• Empty Lists, Append
• Loops, List Updates

Ch 8: Python Dictionaries

• Python Dictionary
• Indexing Dictionaries
• Edit Key Values
• Lists inside Dictionaries
• Delete & Clear

Ch 9: Python Tuples

• Python Tuples
• Defining, Indexing
• Length(), Type()
• Mixed Values in Tuples
• Overwriting Tuples

Ch 10: Python IF..ELSE Condition

• If..Else conditions
• if..elif..else & Shorthand if
• composite conditions
• Indent, pass statement
• in & negation operators
• range conditions

Ch 11: Python Loops

• Python For Loop
• For Loop @ Range
• For Loop @ Sequence Values
• While Loop, Exit Conditions
• Break, Continue, Paas

Ch 12: Python File Handling

• File Handling, Activities
• Loop, Write, Close Files
• Appending, Overwriting
• import os, path.exists
• if.open, f.write, f.close

Ch 13: Python Dataframes

• Dataframes: Creation
• Pandas Dataframes
• Dataframes From Single List
• Dataframes from Dictionary
• Display Dataframes, List Items
• Identify, Replace Nulls, NumPy

Ch 14: Python SQL DB Access

• SQL DB Access with Python
• import pandas.DataFrame
• pyodbc module, sql functions
• SQL Query Executions: DDL, DML
• Filters, Aggregations with SQL
• Dataframe Usage with SQL

Ch 15: Dataframe Transformations – 1

• Dataframe Transformations
• Concat & Append
• Merge Function
• Join with Multiple Dataframes
• Data Type Checks, Conversions
• Loops with Dataframes

Ch 16: Dataframe Transformations – 2

• Pandas – Cleaning Data
• Replace, Transform Columns
• Data Discovery & Column Fill
• Identify & Remove Duplicates
• dropna(), fillna() Functions

Ch 17: Dataframe Transformations – 3

• Python Functions for date, time
• Now() Function in Python
• date, time Functions
• Calendar Data Generation

Ch 18: Python Functions & Lambda

• Python Functions & Usage
• Function Parameters
• Default & List Parameters
• Python Lambda Functions
• Recursive Functions, Usage
• Return & Print @ Lamdba

Ch 1: Excel Concepts, Basic Functions

• Excel Basics & Concepts
• Excel Functions
• Excel Operations

Ch 2: Formatting and Proofing

• Currency Format
• Format Painter
• Formatting Dates
• Custom and Special Formats
• Formatting Cells
• Absolute, Mixed
• Relative Referencing

Ch 3: Functions

• SUMIF, SUMIFS, COUNTIF
• COUNTIFS, AVERAGEIF
• AVERAGEIFS, NESTED IF
• IFERROR STATEMENT
• AND, OR, NOT

Ch 4: Protecting Excel

• File Level Protection
• Workbook
• Worksheet Protection
• Security Concepts
• Realtime Issues, Solutions

Ch 5: Text Functions

• Upper, Lower, Proper
• Left, Mid, Right
• Trim, Len, Exact
• Concatenate
• Find, Substitute

Ch 6: Date & Time Functions

•  Today, Now
• Day, Month, Year
• Date, Date if, Date Add
• EOMONTH
• Weekday Functions

Ch 7: Adv. Techniques

• Paste Formulas
• Paste Formats
• Paste Validations
• Transpose Tables

Ch 8: New in Excel & 365

• Charts – Tree map & Waterfall
• Sunburst, Box and whisker Charts
• Combo Charts – Secondary Axis
• Adding Slicers Tool in Pivot & Tables
• Using Power Map and Power View
• Forecast Sheet, park lines

Ch 9: New in Excel & 365

• Using 3-D Map
• New Controls in Pivot Table
• Various Time Lines
• Auto complete a data range
• Quick Analysis Tool
• Smart Lookup manage Store

Ch 10: Printing Workbooks

• Setting Up Print Area
• Customizing Headers
• Templates
• Print Titles –Repeat Rows

Ch 11: Sorting and Filtering

• Filtering on Text
• Numbers & Colors
• Sorting Options
• Advanced Filters
• Filter Criteria

Ch 12: What If Analysis

• Goal Seek
• Scenario Analysis
• Data Tables (PMT Function)
• Solver Tool

Ch 13: Logical Functions

• If Function
• How to Fix Errors – if error
• Nested If
• Complex if and or functions

Ch 14: Data Validation

• Number, Date & Time
• Text and List Validation
• Custom validations formulas
• Dynamic Dropdowns

Ch 15: Lookup Functions

• V lookup / H Lookup
• Index and Match
• Smooth User Interface
• Nested V Lookup
• Reverse Lookup
• Worksheet linking
• V lookup with Helper Column

Ch 16: Pivot Tables – 1

• Creating Simple Pivot Tables
• Classic Pivot table
• Filtering PivotTables
• Modifying PivotTable Data
• Grouping
• Calculated Fields

Ch 17: Pivot Tables – 2

• Array with IF, LEN
• MID function formulas.
• Array with Lookup functions.
• Various Charts
• SLICERS, Filter data
• Manage Primary Axis
• Manage Secondary Axis

Ch 18: Excel Dashboard

• Planning a Dashboard
• Adding Tables and Charts to Dashboard
• Adding Dynamic Contents to Dashboard

Ch 19: VBA Macro – Level 1

• Using Outlook Namespace
• Send automated mail
• Outlook Configurations, MAPI
• Worksheet Operations
• Workbook Operations

Ch 20: VBA Macro – Level 2

• Merge Worksheets using Macro
• Merge multiple excel files into one sheet
• Split worksheets using VBA
• Worksheet copiers

Ch 21: Statistics For Data Analysis – 1

• Mean
• Median
• Mode
• Variance
• Standard Deviation
• Correlation

Ch 22: Statistics For Data Analysis – 2

• Probability Basics
• Hypothesis Testing
• A/B Testing
• Confidence Interval
• Outliers
• Normal Distribution

Ch 1: Copilot Introduction

• AI Concepts
• AI Fundamentals
• AI in Realtime
• Microsoft Copilot

Ch 2: Copilot Architecture

• Copilot Architecture
• Anatomy of a copilot
• Prompts in Copilot
• Data Security
• Copilot Configurations

Ch 3: Building Prompts

• Copilot Usage
• Building Good Prompts
• Dos & Don’ts
• Undo Options

Ch 4: Copilot in Power BI Desktop

• Copilot for Data Modelling
• Copilot for Visuals
• Copilot for Formatting
• Visual Interactions
• Visual Sync

Ch 5: Copilot in Power Query

• Copilot for M Language
• Copilot for ETL
• Copilot with Expressions

Ch 6: Copilot in Power BI Cloud

• Copilot in Cloud Service
• Visual Analytics
• Semantic Models
• Power BI Dashboards
• Power BI Apps

Ch 7: Copilot in DAX

• DAX with Copilot
• Big Data Analytics
• DAX Constructs with Copilot
• Q & A Concepts

Ch 8: Analytical Reports & AI – 1

• Copilot with Power BI Desktop
• CoPilot in Power BI Cloud
• Key Influencers
• Decomposition Tree
• Smart Narrative

Ch 9: Analytical Reports & AI – 1

• Q&A Visual
• Anomaly Detection
• Forecasting
• AI Visuals
• Azure AI Integration

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

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
• 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
• Project Permission and Locking
• Data Security with user Filters
• Filters and Hybrid Models in Server
• TSM : Tableau Services Manager
• GUI and CLI; Backups and Restores
• Tabcmd : Imports; Tabcmd

Realtime Project – 1

• Finance Domain
• Project Requirement
• Project Solution
• Project FAQs
• AI Sales Dashboard

Realtime Project – 2

• Finance Domain
• Project Requirement
• Project Solution
• Project FAQs
• AI Financial Forecast

 Career Guidance

• Resume Optimization
• LinkedIn Optimization
• ATS-Friendly Resume
• Salary Negotiation
• Interview Strategy
• Job Search Platforms
• AI Components For Resume

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.