How to use this
Microsoft's study guide is the authority on what the exam measures; this page is the navigator from each objective to practice. For each objective: learn it in the linked lessons, drill it with the assignments and flashcards, then use it in a scenario. Your measured confidence per area is on the certification map.
Note: Certification and job skill overlap but aren't the same. Exams test breadth of features; jobs test judgement under messy conditions. Do both: the exam opens doors, the scenarios get you through them.
PL-300: Power BI Data Analyst
Outline: As of 20 April 2026. Check the official study guide before you book.
Prepare the data (25–30%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Get or connect to data | Getting data and cleaning it in Power Query Advanced Power Query and M Composite models, DirectQuery and hybrid tables Direct Lake in depth | 16 assignments 20 interview questions Power Query & data prep cards | BI-1042, BI-1057, INC-2031 |
| Profile and clean the data | Getting data and cleaning it in Power Query Data quality tests | 7 assignments 9 interview questions Power Query & data prep cards | BI-1042, BI-1057, INC-2031 |
| Transform and load the data | Getting data and cleaning it in Power Query Advanced Power Query and M Data modeling | 13 assignments 16 interview questions Power Query & data prep cards | BI-1042, BI-1057, INC-2031 |
Model the data (25–30%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Design and implement a data model | Data modeling Modeling | 8 assignments 10 interview questions Data modeling cards | BI-1042, BI-1057, INC-2031 |
| Create model calculations by using DAX | DAX fundamentals DAX Advanced DAX | 14 assignments 17 interview questions Data modeling cards | BI-1042, BI-1057, INC-2031 |
| Optimize model performance | Performance Build it, break it | 8 assignments 10 interview questions Data modeling cards | BI-1042, BI-1057, INC-2031 |
Visualize and analyze the data (25–30%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Create reports | Visualisation and report design Interactive reports Advanced DAX Visual calculations Copilot-assisted workflows and their limits Paginated reports, mobile layouts, accessibility and personalization | 23 assignments 28 interview questions Visuals & report design cards | BI-1042, BI-1057, INC-2031 |
| Enhance reports for usability and storytelling | Visualisation and report design Interactive reports Paginated reports, mobile layouts, accessibility and personalization Analytics features | 15 assignments 18 interview questions Visuals & report design cards | BI-1042, BI-1057, INC-2031 |
| Identify patterns and trends | Interactive reports Analytics features Copilot-assisted workflows and their limits | 11 assignments 13 interview questions Visuals & report design cards | BI-1042, BI-1057, INC-2031 |
Manage and secure Power BI (15–20%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Create and manage workspaces and assets | Power BI Service basics Service Governance, enterprise architecture and the "senior" conversations Workspaces, domains, ownership and endorsement | 15 assignments 20 interview questions Service, sharing & refresh cards | BI-1042, BI-1057, INC-2031 |
| Secure and govern Power BI items | Row-level security Service Governance, enterprise architecture and the "senior" conversations Sensitivity labels, OLS, export controls and tenant settings Security tests | 18 assignments 24 interview questions Service, sharing & refresh cards | BI-1042, BI-1057, INC-2031 |
Your confidence per area is on the certification map, measured from your assignments, quiz answers and flashcards.
DP-600: Fabric Analytics Engineer
The DP-600 outline changes on 19 October 2026; the table shows the new outline. See the change radar for what changed.
Outline: As of 19 October 2026. Check the official study guide before you book.
Maintain a data analytics solution (25–30%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Implement security and governance | Row-level security Governance, enterprise architecture and the "senior" conversations Sensitivity labels, OLS, export controls and tenant settings Workspaces, domains, ownership and endorsement Security tests | 17 assignments 23 interview questions Security & governance cards | BI-1042, BI-1057, INC-2031 |
| Maintain the analytics development lifecycle | Deployment Governance, enterprise architecture and the "senior" conversations XMLA, TOM, TMSL and Tabular Editor scripting Monitoring, lineage, usage and retirement | 14 assignments 19 interview questions Security & governance cards | BI-1042, BI-1057, INC-2031 |
Prepare data (45–50%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Get data | Dataflows, Fabric Lakehouse and Direct Lake OneLake, Lakehouse, Warehouse and the SQL analytics endpoint Dataflow Gen2, pipelines, mirroring and medallion design | 10 assignments 13 interview questions Power Query & data prep cards | BI-1042, BI-1057, INC-2031 |
| Transform data | Advanced Power Query and M Modeling Dataflows, Fabric Lakehouse and Direct Lake Views, incremental extraction and idempotent loads Keys and slowly changing dimensions Dimension patterns Dataflow Gen2, pipelines, mirroring and medallion design Data quality tests | 28 assignments 36 interview questions Power Query & data prep cards | BI-1042, BI-1057, INC-2031 |
| Query and analyze data | Dataflows, Fabric Lakehouse and Direct Lake DAX Querying for BI CTEs, window functions and deduplication | 15 assignments 19 interview questions Power Query & data prep cards | BI-1042, BI-1057, INC-2031 |
Implement and manage semantic models (25–30%)
| Microsoft objective | Learn it | Drill it | Use it at work |
|---|---|---|---|
| Design and build semantic models | Composite models, DirectQuery and hybrid tables Modeling DAX Advanced DAX Fact table types Calendars, time zones and currencies | 24 assignments 30 interview questions DAX concepts cards | BI-1042, BI-1057, INC-2031 |
| Optimize enterprise-scale semantic models | Performance Dataflows, Fabric Lakehouse and Direct Lake Direct Lake in depth Making slow source queries fast | 15 assignments 19 interview questions DAX concepts cards | BI-1042, BI-1057, INC-2031 |
Your confidence per area is on the certification map, measured from your assignments, quiz answers and flashcards.
Study plan
- Read the official study guide and mark each objective: confident, unsure, never seen.
- For "never seen", do the linked lessons and their assignments first.
- Daily flashcards (10–15 minutes) on the exam's categories; let spaced repetition pick the order.
- One scenario a week that uses the exam's skills, so the knowledge sticks.
- Take Microsoft's free practice assessment a week before the exam; revisit the weakest areas.