Subhash Kumar Mishra

1. Introduction to Power BI

What is Business Intelligence?

Overview of Power BI ecosystem

Power BI Desktop vs Power BI Service

Real-time use cases in different industries



---

2. Getting Started with Power BI Desktop

Installing and navigating Power BI Desktop

Understanding data sources and connections

Import vs DirectQuery vs Live Connection

Demo: Load sample data and basic visual



---

3. Data Transformation using Power Query

Power Query Editor Overview

Applied Steps & Query Dependencies

Common transformations:

Remove/Filter Rows

Merge & Append Queries

Pivot & Unpivot


Hands-on exercise



---

4. Data Modeling in Power BI

Relationships and Cardinality

Star vs Snowflake schema

Fact and Dimension tables

Best practices for efficient data models



---

5. DAX (Data Analysis Expressions) – Deep Dive

Introduction to DAX

Calculated Columns vs Measures vs Tables

Common DAX Functions:

SUM, CALCULATE, FILTER, ALL, VALUES

Time Intelligence (YTD, MTD, QTD)


Hands-on DAX practice



---

6. Data Visualization Techniques

Choosing the right chart type

Bar, Line, Pie, Table, Matrix

KPI, Cards, Gauge

Custom visuals from marketplace

Bookmark, Drill Through, Tooltips

Designing Interactive Dashboards



---

7. Power BI Service (Cloud)

Publishing reports to Power BI Service

Workspaces, Datasets, Reports & Dashboards

Creating and Sharing Dashboards

Collaboration with Teams & SharePoint



---

8. Row-Level Security (RLS)

Static RLS vs Dynamic RLS

Implementing user-based data filtering

Testing RLS as different users



---

9. Power BI Gateways

What is a data gateway?

Installing and configuring gateway

Scheduled Refresh vs Live connection



---

10. Advanced Topics

Performance Tuning (Query Diagnostics, DAX optimization)

Parameters & What-if Analysis

Paginated Reports (Intro)

Integration with:

PowerApps

Power Automate

Azure Synapse / SQL




---

11. Real-Time Dashboards & Alerts

Streaming datasets

Power BI REST API (Overview)

Setting alerts and notifications



---

12. Hands-on Project (End-to-End)

Business requirement breakdown

Data transformation and modeling

Report building and publishing

User access and sharing

Review and feedback



---

13. Interview & Certification Preparation

Power BI Interview Questions & Answers

DA-100 / PL-300 Certification syllabus and tips

Scenario-based questions



---

14. Bonus:

Power BI vs Tableau vs Excel

Power BI Admin Portal & Licensing Overview

Best practices & industry tips for dashboard design