Power BI Data Analyst
Associate
The Power BI certification for data analysts. Master Power Query, DAX, star schemas, interactive reports, AI visuals, and Copilot โ with hands-on examples and practical DAX code.
Study Guide
26 interactive modules
Modules 1-4 (Data Prep Foundation) + DAX Fundamentals + 16 practice questions. No account needed.
Start Free โPractice Exam
200 exam-style questions
Study mode with explanations + timed exam simulation. 16 free questions.
Try Free Questions โ26
Modules
200
Questions
4
Domains
Free
Domain 1 included
๐ Sample Question
A slicer is set to Region = "North". A measure uses CALCULATE(SUM(Revenue), Region = "South"). What does the measure return?
๐ What you'll cover
What you'll learn
๐
Power Query & Data Prep
Connect to 100+ sources, profile data quality, transform with merge/append/pivot, and build star schemas from raw data.
๐
DAX & Data Modelling
Master CALCULATE, time intelligence, filter context, calculation groups, and performance optimisation with real code examples.
๐
Visuals, Copilot & AI
Choose the right charts, build navigation with bookmarks, use Copilot for reports, and discover patterns with AI visuals.
๐
Security & Governance
Row-level security, workspace roles, gateways, scheduled refresh, sensitivity labels, and content endorsement.
Full Curriculum
26 interactive modules across 4 exam domains
1 Prepare the Data
7 modules
Free
Prepare the Data
7 modules
Connect to data sources, choose storage modes, profile and clean data, master Power Query transforms, build star schemas from raw data, and configure efficient loading.
- 1Connecting to Data Sources
- 2Storage Modes: Import, DirectQuery & DirectLake
- 3Data Profiling & Quality
- 4Power Query Transforms
- 5Combining Data: Merge, Append & Queries
- 6Fact Tables, Dimension Tables & Keys
- 7Data Loading & Query Optimisation
2 Model the Data
7 modules
Premium
Model the Data
7 modules
Design star schemas with proper relationships, create date tables, master DAX measures with CALCULATE and time intelligence, build calculation groups, and optimise performance.
- 1Star Schema & Relationships
- 2Date Tables & Table Properties
- 3Columns vs Measures: When to Use Which
- 4DAX Fundamentals
- 5CALCULATE & Filter Context
- 6Time Intelligence & Calculation Groups
- 7Model Performance Optimisation
3 Visualize and Analyze the Data
7 modules
Premium
Visualize and Analyze the Data
7 modules
Choose the right visuals, configure slicers and interactions, build navigation with bookmarks and drillthrough, use Copilot for AI-powered reports, and discover patterns with AI visuals.
- 1Choosing & Formatting Visuals
- 2Slicers, Filters & Interactions
- 3Bookmarks, Tooltips & Navigation
- 4Copilot in Power BI Reports
- 5Report Pages & Paginated Reports
- 6Mobile, Accessibility & Personalisation
- 7AI Visuals & Pattern Discovery
4 Manage and Secure Power BI
5 modules
Premium
Manage and Secure Power BI
5 modules
Create workspaces and apps, set up dashboards with alerts, configure gateways and refresh, implement row-level security, and apply sensitivity labels for governance.
- 1Workspaces & Distribution
- 2Dashboards, Alerts & Subscriptions
- 3Gateways & Scheduled Refresh
- 4Row-Level Security & Access Control
- 5Sensitivity Labels & Governance
Practice Exam Lab
200 original questions โ two study modes
Study Mode
Learn as you go
- โ See explanation after each question
- โ "Why wrong" for every option
- โ Real-world context & exam tips
- โ Microsoft Learn links
Exam Mode
Simulate the real thing
- โ 120 minutes timed session
- โ Randomised question order
- โ Score breakdown by domain
- โ Pass/fail against 700 / 1000
1Prepare the Data
55 questions ยท Exam weight: 25-30%
8 Free
Prepare the Data
55 questions ยท Exam weight: 25-30%
16
Easy
25
Medium
14
Hard
Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.
Try Free Questions โ 2Model the Data
55 questions ยท Exam weight: 25-30%
4 Free
Model the Data
55 questions ยท Exam weight: 25-30%
15
Easy
26
Medium
14
Hard
Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.
Preview Questions 3Visualize and Analyze the Data
55 questions ยท Exam weight: 25-30%
2 Free
Visualize and Analyze the Data
55 questions ยท Exam weight: 25-30%
16
Easy
25
Medium
14
Hard
Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.
Preview Questions 4Manage and Secure Power BI
35 questions ยท Exam weight: 15-20%
2 Free
Manage and Secure Power BI
35 questions ยท Exam weight: 15-20%
10
Easy
16
Medium
9
Hard
Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.
Preview Questions๐ Free tier: 16 questions. No account needed.
Choose your path
Start free. Upgrade when you're ready.
Practice Exam
$14
one-time purchase
- โ 200 exam-style questions
- โ Study mode + Exam mode
- โ Detailed explanations
Study Guide
$19
one-time purchase
- โ 26 interactive modules
- โ Flashcards & ELI5
- โ Progress tracking
Complete Bundle
$29
save $4
- โ Everything in both
- โ Best value
๐ Free tier: Modules 1-4 (Data Prep Foundation) + DAX Fundamentals + 16 practice questions. No account needed. No account needed.
About the PL-300 Exam
- Exam code
- PL-300
- Duration
- 120 minutes
- Passing score
- 700 / 1000
- Question types
- MCQ, multi-select, case studies
- Cost
- $165 USD
Exam Domains & Weights
Frequently Asked Questions
What is PL-300?
Is PL-300 hard?
What's in the free tier?
Do I need Power BI experience?
Is this a one-time purchase?
Can I study on my phone?
Ready to start?
Try the free tier. Upgrade when you're ready to pass.