---- Microsoft Power BI · Instructor-Led Workshop
Turn Data
into Decisions
with Power BI.
into Decisions
with Power BI.
From raw spreadsheets to boardroom-ready dashboards — master Power BI Desktop, DAX, Power Query, and Microsoft Fabric across three progressive workshop levels.
PL-300 CertifiedDP-500 CertifiedMicrosoft Fabric
3×Workshop Levels
40+Hands-on Labs
2×Microsoft Exams Covered
96%PL-300 Pass Rate
---- Three Levels
Choose Your
Power BI Level.
Power BI Level.
Level 01 — Beginner
Power BI Fundamentals
Build your first interactive report from scratch. Connect to Excel, SQL Server, and SharePoint data sources, shape data in Power Query, design visuals, and publish to Power BI Service with row-level security.
Key Modules
Power BI Desktop interface & data connectors
Power Query — cleaning & transforming data
Building visuals: charts, slicers, maps
Publishing to Power BI Service & sharing
Row-Level Security (RLS) basics
PL-900 PrepPL-300 Foundation
⭐ Most Popular
DAX & Advanced Data Modelling
Go deep on DAX — calculated columns, measures, time intelligence, CALCULATE, and iterator functions. Design star schemas, optimise VertiPaq storage, and build robust semantic models that scale.
Key Modules
Star schema & relationship modelling
DAX fundamentals — measures vs. columns
Time intelligence: YTD, QoQ, rolling avg
CALCULATE, FILTER, ALL, ALLEXCEPT
VertiPaq profiling & DAX Studio
Advanced RLS & dynamic security
PL-300 Deep Prep
Level 03 — Advanced
Microsoft Fabric & Enterprise Analytics
Build end-to-end analytics solutions on Microsoft Fabric. Design Lakehouses, Data Warehouses, Dataflows Gen2, and Direct Lake datasets. Integrate with Azure Synapse, real-time analytics with Kusto, and govern data with Purview.
Key Modules
Microsoft Fabric architecture & workspaces
Lakehouse & Data Warehouse design
Dataflows Gen2 & data pipelines
Direct Lake mode — Power BI on Fabric
Real-time analytics with Kusto (KQL)
Microsoft Purview & data governance
DP-500
Corporate & Custom
Bespoke Power BI Training
We design fully custom Power BI programmes for enterprise analytics teams — combining any modules from all three levels, tailored to your data stack, business domain, and certification goals.
Level 01 — Beginner
Power BI Fundamentals
Build your first interactive report from scratch. Connect to Excel, SQL Server, and SharePoint data sources, shape data in Power Query, design visuals, and publish to Power BI Service with row-level security.
Key Modules
Power BI Desktop interface & data connectors
Power Query — cleaning & transforming data
Building visuals: charts, slicers, maps
Publishing to Power BI Service & sharing
Row-Level Security (RLS) basics
PL-900 PrepPL-300 Foundation
Corporate & Custom
Bespoke Power BI Training
We design fully custom Power BI programmes for enterprise analytics teams — combining any modules from all three levels, tailored to your data stack, business domain, and certification goals.
⭐ Most Popular
Level 02 — Intermediate
DAX & Advanced Data Modelling
Go deep on DAX — calculated columns, measures, time intelligence, CALCULATE, and iterator functions. Design star schemas, optimise VertiPaq storage, and build robust semantic models that scale.
Key Modules
Star schema & relationship modelling
DAX fundamentals — measures vs. columns
Time intelligence: YTD, QoQ, rolling avg
CALCULATE, FILTER, ALL, ALLEXCEPT
VertiPaq profiling & DAX Studio
Advanced RLS & dynamic security
PL-300 Deep Prep
Corporate & Custom
Bespoke Power BI Training
We design fully custom Power BI programmes for enterprise analytics teams — combining any modules from all three levels, tailored to your data stack, business domain, and certification goals.
Level 03 — Advanced
Microsoft Fabric & Enterprise Analytics
Build end-to-end analytics solutions on Microsoft Fabric. Design Lakehouses, Data Warehouses, Dataflows Gen2, and Direct Lake datasets. Integrate with Azure Synapse, real-time analytics with Kusto, and govern data with Purview.
Key Modules
Microsoft Fabric architecture & workspaces
Lakehouse & Data Warehouse design
Dataflows Gen2 & data pipelines
Direct Lake mode — Power BI on Fabric
Real-time analytics with Kusto (KQL)
Microsoft Purview & data governance
DP-500
Corporate & Custom
Bespoke Power BI Training
We design fully custom Power BI programmes for enterprise analytics teams — combining any modules from all three levels, tailored to your data stack, business domain, and certification goals.
---- Curriculum
What You'll
Actually Learn.
Actually Learn.
Every module is built around real business scenarios — not toy datasets. You’ll leave each session with something you can use at work on Monday.
Data Connection & Power Query
📋 Fundamentals Workshop
Connecting to Excel, CSV, SQL Server, SharePoint, and web sources
Power Query Editor — applied steps, query folding, and best practices
Merging & appending queries — lookup tables and union patterns
Custom M functions for reusable data transformations
Data type handling — text, dates, numbers, and locale settings
Incremental refresh — loading only new or changed rows
Data Modelling & Relationships
📋 PL-300 Foundation
Star schema design — fact tables, dimension tables, and date tables
Active vs. inactive relationships and USERELATIONSHIP()
Role-playing dimensions and bridging tables
Building a proper Calendar/Date table with DAX or M
Many-to-many relationships and bi-directional filtering risks
Calculated columns vs. measures — when to use each
DAX — Measures & Calculations
📋 PL-300 Deep Prep
CALCULATE — the most important DAX function, deeply explained
Time intelligence: TOTALYTD, DATEADD, PARALLELPERIOD, rolling 12M
FILTER, ALL, ALLEXCEPT — context manipulation patterns
Iterator functions: SUMX, AVERAGEX, RANKX, TOPN
DAX Studio — query plans, Server Timings, and performance profiling
KPI measures: Variance %, Growth %, Budget vs Actual patterns
Visualisation & Report Design
📋 All Levels
Chart selection principles — the right visual for the right question
Maps, decomposition trees, key influencers, and Q&A visual
Mobile layout — designing reports for phone and tablet
Bookmarks, buttons, drillthrough, and page navigation UX
Report theming — corporate colours, fonts, and accessibility
Row-level security — static and dynamic RLS patterns
Power BI Service & Governance
📋 PL-300 Service Topics
Workspaces, apps, and permission model — who sees what
Scheduled refresh, on-premises data gateways, and personal gateway
Paginated reports (SSRS) in Power BI Premium
Subscriptions, alerts, and data-driven alert workflows
Sensitivity labels, Microsoft Purview, and data lineage
Usage metrics — monitoring report adoption and performance
Microsoft Fabric & Enterprise Analytics
📋 DP-500 Prep
Microsoft Fabric architecture — OneLake, workspaces, and domains
Lakehouse — ingesting files, tables, and Delta Parquet via Spark
Data Warehouse — T-SQL endpoints and warehouse-native tables
Direct Lake mode — Power BI on Delta Lake without import overhead
Real-time analytics — Eventstream and KQL databases
Purview governance — lineage, sensitivity, and data catalog
---- Who Attends
Built for Every
Data Professional.
Data Professional.
Business Analysts
Replace messy Excel reports with interactive Power BI dashboards. Build self-service analytics your stakeholders can actually use.
BI Developers
Master DAX, star schema, and VertiPaq optimisation. Build semantic models that perform at scale and earn the PL-300 certification.
Data Engineers
Connect Power BI to your Azure data stack. Use Microsoft Fabric to bridge pipeline outputs with Direct Lake Power BI reports.
Managers & Leaders
Understand what Power BI can do for your team. Learn to commission effective BI projects, review reports, and drive data culture.
--- Tools & Stack
Every Tool You'll
Work With
Work With
We use real Microsoft licences in every workshop — not screenshots. Hands-on from day one.
Power BI Desktop
The primary authoring tool — data modelling, DAX, and report design. Every attendee works directly in the full Desktop app.
Free download
Power BI Service
Publish, share, and collaborate on reports. Configure workspaces, gateways, scheduled refresh, and row-level security in the cloud.
Microsoft 365
DAX Studio
Profile DAX queries, measure performance with Server Timings, and debug complex expressions. Essential for intermediate & advanced learners.
Free tool
Microsoft Fabric
End-to-end analytics platform combining Synapse, ADF, Data Factory, and Power BI in one SaaS experience. Used in the Advanced workshop.
Advanced track
Power Query (M)
Transform, clean, and shape data from dozens of connectors. Write custom M functions for reusable transformation logic.
All levels
SQL Server & Azure SQL
Connect Power BI directly to relational databases. Learn import vs. DirectQuery vs. Direct Lake modes and their trade-offs.
Intermediate+
Tabular Editor
Build calculation groups, manage object-level security, and work with XMLA endpoints for enterprise-grade Power BI deployments.
Advanced track
Microsoft Purview
Tag, classify, and govern data assets in Microsoft Fabric. Understand lineage, sensitivity labels, and compliance in the analytics estate.
Advanced track
---- Why Power BI
Why Learn
Power BI Now?
Power BI Now?
01
Gartner Leader — 17 Years Running
Microsoft has been a Gartner Magic Quadrant Leader in Analytics & BI Platforms for 17 consecutive years. Power BI is the enterprise standard — not a trend.
02
PL-300 = Premium Salary
PL-300 certified Power BI analysts in India command salaries 25–40% higher than non-certified peers. In the Gulf and UK markets, the premium is even larger.
03
Microsoft Fabric Changes Everything
Microsoft Fabric unifies Power BI, Azure Synapse, and Data Factory into a single platform. Power BI professionals who understand Fabric are positioned as full-stack analytics leaders.
97%
of Fortune 500 of companies use Power BI — making it the single most useful BI skill you can add to your CV right now.
97%
of Fortune 500 of companies use Power BI — making it the single most useful BI skill you can add to your CV right now.
04
Every Business Has Data — Few Can Read It
India’s digital economy is generating more data than ever. Companies are urgently hiring analysts who can build self-service dashboards that actually get used — not just built.
--- Learner Stories
What Our
Graduates Say.
Graduates Say.
“
The DAX workshop completely changed how I think about data. I went from writing nested IF formulas in Excel to building time-intelligence measures that my CFO now uses every Monday morning.
“
Cleared PL-300 on the first attempt two weeks after the intermediate workshop. The exam prep mock questions and the VertiPaq optimisation labs made all the difference. Highly recommend.
“
We sent our entire analytics team through the corporate batch. In three months, we retired 14 Excel-based reports and replaced them with a single Fabric lakehouse feeding Power BI dashboards.
