Launch Deal · 50% off 1st month ·
← Study guides

PL-300Free

Microsoft Certified: Power BI Data Analyst Associate — PL-300

Complete Study Course

Exam: PL-300, Microsoft Power BI Data Analyst
Audience: Data analysts who turn business requirements into reports people can act on. You work with business stakeholders, analytics engineers and data engineers, and you should be comfortable with Power Query and DAX.


Domain Blueprint

Domain Weight Lessons Focus
1. Prepare the data 25–30% 8 Connecting, credentials and privacy, storage modes, parameters, profiling and cleaning, shaping, star schema, merge and append, load settings
2. Model the data 25–30% 8 Table and column properties, relationships, role-playing dimensions, date tables, CALCULATE, time intelligence, calculation groups, performance
3. Visualize and analyze the data 25–30% 8 Choosing and formatting visuals, filters, Copilot, paginated reports, visual calculations, bookmarks, drillthrough, mobile, accessibility, analytics features
4. Manage and secure Power BI 15–20% 6 Workspaces, apps, distribution, subscriptions and alerts, endorsement, gateways and refresh, permissions, row-level security, sensitivity labels

On Skillmarked: 30 free lessons (one per skill area) and timed mock exams.


Recommended Study Plan (30–40 hours with some Excel or SQL experience)

Week 1 – Get the data right (Domain 1)

  • Install Power BI Desktop and connect to an Excel workbook, a CSV folder and a sample SQL database
  • Turn on column quality, distribution and profile, and fix every error and null you find
  • Build a star schema from one flat table: reference a staging query, split it into a fact table and dimensions, and turn off load for the staging query

Week 2 – Model and calculate (Domain 2)

  • Create a date table, mark it as a date table and turn off Auto date/time
  • Write measures with CALCULATE, ALL, USERELATIONSHIP, TOTALYTD and SAMEPERIODLASTYEAR
  • Add a calculation group for time intelligence, then use Performance Analyzer to find the slowest visual

Week 3 – Build, share and secure (Domains 3 and 4)

  • Build a report with bookmarks, a drillthrough page, a tooltip page, sync slicers and a mobile layout
  • Publish to a workspace, add people with each role, create an app with two audiences and set up scheduled refresh
  • Define dynamic RLS with USERPRINCIPALNAME(), test it with View as, assign a security group in the service, then take timed mock exams

Critical Concepts (High-Yield)

Storage modes

  • Import: fastest queries, needs refresh. DirectQuery: always current, slower, limited Power Query. Direct Lake: Fabric only, reads Delta tables in OneLake without importing them
  • Dual mode for dimension tables in composite models

Shaping

  • Unpivot other columns keeps working when new month columns appear. Reference reuses a query's output; Duplicate copies its steps
  • Merge = join columns (like a lookup). Append = stack rows (like a union)

DAX

  • Measures are calculated at query time; calculated columns at refresh, row by row, and they're stored in the model
  • CALCULATE changes the filter context. USERELATIONSHIP activates an inactive relationship for one measure
  • Semi-additive balances use LASTDATE, LASTNONBLANK or CLOSINGBALANCEMONTH instead of SUM over time

Security

  • RLS applies only to users with the Viewer role (and to people who get access through an app or sharing). Admins, Members and Contributors see all the data
  • Build permission lets people create their own reports from a semantic model

The exam is open book: Microsoft Learn is available during role-based exams, but the clock keeps running. Use it to confirm a setting or function, not to learn a concept.


Official Resources

PL-300 exam at a glance

Questions
About 40–60
Time limit
100 minutes
Passing score
700 on a scale of 1–1,000
Exam fee
$165 USD (varies by country)
Certification valid for
12 months, renewable free online
Delivery
Pearson VUE, online proctored or at a test centre. Microsoft Learn is open during the exam
Retakes
After 24 hours the first time; longer waits for later retakes

Exam details as published when this guide was written. Microsoft can change them, so check the official exam page before you book.

New to this exam? Read how to prepare for PL-300, or see every PL-300 exam topic on one page.

Study the domains

Every lesson ends with a practice scenario on what you just read.

  1. Domain 1: Prepare the data

    8 practice scenarios · free

  2. Domain 2: Model the data

    8 practice scenarios · Pro

  3. Domain 3: Visualize and analyze the data

    8 practice scenarios · Pro

  4. Domain 4: Manage and secure Power BI

    6 practice scenarios · Pro