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

📊 Project 1: Power BI Enterprise Project

Retail Sales & Executive Business Intelligence Dashboard 

🏥 Domain
Healthcare
Business Problem

Hospital management wants to monitor patient admissions, doctor performance, operational efficiency, treatment outcomes, revenue, and resource utilization using interactive dashboards.

Data Sources 

• SQL Server
• Oracle
• Excel
• CSV
• Salesforce
• Web Data Connector

Deliverables

• Tableau Workbook (.twb/.twbx)
• Tableau Prep Flow
• SQL Scripts
• Dashboard Documentation
• Business Requirement Document (BRD)
• KPI Document
• Resume Points

🎯 Career Guidance 

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

Learning Outcomes

After completing these projects, learners will be able to:

• Design enterprise BI solutions from scratch.
• Build executive dashboards with real business KPIs.
• Create scalable semantic data models.
• Develop advanced visualizations and analytical reports.
• Publish and manage reports on Power BI Service and Tableau Server/Cloud.
• Present portfolio-ready projects that strengthen resumes and prepare them for Senior Data Analyst interviews at MNCs.