POWER_BI_HERO_1920x700

#Power BI

Power BI is an awesome, colourful technology that can help us to understand the data, get the actual insights and report / showcase to the customers with ease. Using Power BI, we can design interactive visualizations, dashboards, apps and more.. !

Training Highlights

✅Power BI Desktop & Service
✅Data Modeling, DAX Functions
✅Power Query (M), Parameters
✅Interactive Dashboards, Apps
✅Big Data Access, DAX
✅Dynamic Row Level Security (RLS)
✅Power BI with Azure & Fabric
✅Power BI Deployment, IA

Modules We Learn:

✅Module 1: SQL Server TSQL (MSSQL) Queries
✅Module 2: Power BI
✅Module 3: Realtime Project (HealthCare)

Course Duration: 7 Weeks

<br />

Power BI
Course Contents:

Brochure Download Request a Callback

Module 1: SQL Server TSQL (MS SQL) Queries

Ch 1: SQL Database Job Roles

Database Intro
OLTP, DWH, OLAP
DBMS Basics
Power BI Job Roles

Ch 2: Database Intro & Installations

SQL Server Installations
Instance & Collations
SSMS Tool Installation
Connections, Authentications

Ch 3: SQL Basics V1 (Commands)

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
DML: Insert, Update, Delete
DQL: Select, Fetch
Add, Truncate Statements
SQL Operators

Ch 5: Data Types & Variables

Integer Data Types
Character, MAX Data Types
Decimal & Boolean Data Types
Date and Time Data Types
SQL_Variant Type

Ch 6: Data Imports

Data Imports with Excel
Data Imports with CSV
Data Types Detection
OLE-DB Connections
ORDER BY, TOP, OFFSET

Ch 7: Schemas & Batches

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

Ch 8: Constraints, Keys & RDBMS

Null, Not Null Constraints
Unique Key & Check
Primary Key Constraint
Foreign Keys, Default
DB Diagrams & ER Models

Ch 9: Normal Forms & RDBMS

Normal Forms: 1 NF, 2 NF
3 NF, BCNF and 4 NF
1:1, 1:M, M:1 Cardinality
Cascading Keys, Self Referencing Keys

Ch 10: Joins & Queries

Joins: Table Comparisons
Inner Joins & Matching Data
Outer Joins: LEFT, RIGHT
Full Outer Joins & Aliases
Self Joins & Aliases

Ch 11: Sub Queries

Basic Sub Queries
Aggregations
Combining Queries
Correlated Sub Queries
UNION, UNION ALL

Ch 12: Group By Queries

Group By, Distinct
GROUP BY, HAVING
Cube( ) and Rollup( )
Sub Totals & Grand Totals
Grouping( ) & Usage
ISNULL, COALESCE

Ch 13: Joins with Group By, Sub Queries

3 Table, 4 Table Joins
Join Queries & WHERE
Join & Group By, Sub Queries
IIF(), CASE Statement
EXISTS, NOT EXISTS
Query Execution Order

Ch 14: Views & RLS

Views: Realtime Usage
DML, SELECT with Views
WITH CHECK OPTION
Row Level Security (RLS)
Important System Views

Ch 15: Functions & Queries

User Defined Functions
Scalar, Table Value Functions
Variables & Parameters
Date & Time Functions
String Functions
Aggregated Functions
Data Conversion Functions

Ch 16: Advanced SQL & Window Functions

Window Functions (Rank)
Row_Number, DenseRank
Partition By & Order By
Lag & Lead Functions
Pivot, UnPivot
Running Totals
Moving Average

Ch 17: Stored Procedures – 1

Stored Procedures: Realtime Use
Parameters Concept with SPs
Procedures with SELECT
System Stored Procedures
Stored Procedures, Tuning

Ch 18: Stored Procedures – 2

Merge Statement (Upsert)
Merge with OLTP & DWH
Matched and Not Matched
Merge & SP Recompilations

Ch 19: Triggers & Automations

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

Ch 20: Transactions & ACID

Auto Commit Transaction
Explicit Transactions
COMMIT, ROLLBACK
Checkpoint & Query Blocking
READPAST, LOCKHINT
TRY…CATCH & Error Handling

Ch 21: SQL Query Performance & Indexing

Clustered vs Nonclustered Indexes
Index Seek vs Scan
Execution Plans
SARGable Queries
Tuning Queries
Avoiding SELECT *
Indexing JOIN/WHERE columns
Statistics Basics
Query Optimization Examples

Ch 22: CTEs & Tuning

Common Table Expression
CTEs for Data Retrieval
CTEs for DML Operations
Data Cleansing Techniques
Duplicate Detection/Removal

Ch 23: Temp Tables & Query Techniques

Local & Global Temp Tables
SELECT..INTO Statement
Cursor Basics – When to Use & Avoid
NULLIF
Basic Execution-Plan Reading

Ch 24: Bonus / Advanced Module: SQL Server Internals

Database Engine Components
Parser, Compiler & Optimizer
Parsing and Compilation
Memory Manager & IO Managers

Real-Time Project on HealthCare Domain
Project Requirement:
Solve 20+ Real-World Healthcare Business Requirements.

Project Workflow:
Database Design → SQL Development → Data Analysis → Performance Optimization

Project Operational Flow:
Healthcare DB → Patients → Doctors → Appointments → Treatments → Billing → Insurance → SQL
Analysis → Stored Procedures → Performance Tuning → Business Reports

Business Requirements:
Monthly Hospital Revenue, Top Doctors By Patients Treated, Repeat Patients, Department
Performance, Average Treatment Cost, Unpaid Bills, Insurance Claim Analysis, Patient Trends,
Month-Over-Month Revenue And Top Procedures…

Module 2: Power BI

Ch 1: Power BI Intro, Installation

Power BI & Data Analysis
Power BI Design Tools
Power BI Design Techniques
Power BI 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
Close, Apply & Visualize

Ch 12: Power Query: Table Tfns

Table Duplicate, Header Promotion
Group By Transformation
Aggregate, Pivot Operation
Reverse Rows, Count Rows
Advanced Power Query Mode

Ch 13: Power Query: Column Tfn

Any Column Transformations
Data Type Detection, Change
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
Step Edits, Type Conversions

Ch 16: Power BI Cloud: Publish

Power BI Cloud Concepts
Workspace Creation, Usage
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
Report 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
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, Favourites
App URL, End User Access

Ch 21: Power BI Report Server

SQL Server 2025 (Mandatory Installations)
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)
Report Expressions (RDL)
Tablix, Chart Wizards
Fields & Drill-Down
RDL Report Publish

Ch 23: DAX Concepts (Basics)

DAX Concepts: Intro & Realtime Need
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
Analyse in Excel (Cloud)
Excel Reports to Cloud

Ch 30: Power BI AI, CoPilot

AI Components in Power BI
CoPilot Practical Uses
CoPilot with Desktop
CoPilot with Cloud
Need for AI Analytics (Fabric)
PL 300 Exam (Microsoft Certified Data Analyst) Guidance
PL 300 Exam Mocks

Module 3: Realtime Project (HealthCare)

Project Objective
Design and implement a modern Healthcare Data Platform using Azure Data Engineering
services to process patient, hospital, clinical, and operational data for reporting, analytics,
and decision-making

Technologies Used