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
- Study guide and skills measured: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
- Certification page: https://learn.microsoft.com/en-us/credentials/certifications/power-bi-data-analyst-associate/