Power BI PL-300 Certification: Exam Topics, Study Plan and Portfolio | Free Power BI Course: From Beginner to Advanced

What you'll learn

What Microsoft's official PL-300 certification measures, how you pass and how you renew it.
How each exam area maps to the lessons in this course, and what you still need to review.
A six-week study plan and strategies for exam day.
How to build a portfolio and prepare for a data analyst interview.
How to get this course's free certificate.

You can now clean data, model it, write DAX, design reports, publish them securely and run advanced analysis. In this final lesson you'll turn those skills into credentials and opportunities: Microsoft's official certification, a portfolio that proves what you can do and a well-prepared interview.

700out of 1,000 points to pass the PL-300 exam

4skill areas, per the official study guide (skills measured as of April 20, 2026)

Once a yearyou renew the certification, free, with an online assessment

The PL-300 certification

Passing Exam PL-300: Microsoft Power BI Data Analyst earns you the Microsoft Certified: Power BI Data Analyst Associate certification. It's the Power BI credential employers recognize most, and it appears often in U.S. postings for data analyst and business intelligence roles.

Format: multiple-choice questions, ordering steps, completing DAX or M code, and case studies. You can take it at a test center or online from home with a proctor.
Passing score: 700 or higher on a scale of 1,000.
Renewal: associate certifications expire every year and are renewed for free by passing an online assessment on Microsoft Learn.
Cost: the fee depends on your country, so check the exam page for the current U.S. price. Microsoft sometimes offers student discounts and free vouchers at training events.

Always check the official study guide

Microsoft updates the skills outline several times a year. Before you study, open the official PL-300 study guide on Microsoft Learn, which lists the exact skills and the date of the last update.

What it measures and where this course covered it

Exam area	Weight	Course lessons
Prepare the data: get data from different sources, profile, clean, transform and load it	25–30%	2, 5 and 14
Model the data: design the model, relationships, DAX, date tables, performance	25–30%	5, 6, 7, 8, 11 and 15
Visualize and analyze the data: build reports, interactivity, accessibility, analysis	25–30%	3, 4, 9, 12, 13 and 15
Manage and secure Power BI: workspaces, apps, refresh, row-level security, permissions	15–20%	10 and 14

(Weights from the official study guide, skills measured as of April 20, 2026.)

Prepare the data 25–30%Lessons 2, 5 and 14.
Model the data 25–30%Lessons 5 to 8, 11 and 15.
Visualize and analyze 25–30%Lessons 3, 4, 9, 12, 13 and 15.
Manage and secure 15–20%Lessons 10 and 14.

The light part of each bar is the minimum weight; the dark part runs up to the maximum. Three areas weigh almost the same: there are no shortcuts, you need all of them.

1. Which exam area carries the least weight?

Prepare the data.
Manage and secure Power BI (15–20%).
Model the data.

The other three areas weigh 25–30% each. Don't skip it, though: many people coming from Excel have never managed a workspace.

Topics self-taught learners often miss

This course covers most of the outline, but the exam asks about details worth reviewing in the official documentation and the free Microsoft Learn modules:

Data profiling in Power Query: column quality, distribution and profile.
Relationship types: many-to-many cardinality, both-direction cross-filtering and inactive relationships with USERELATIONSHIP.
Calculation groups and field parameters.
Less common time intelligence functions and CALCULATE with several filters.
Accessibility: alt text, tab order, contrast.
Workspace roles (Admin, Member, Contributor, Viewer), apps, sensitivity labels and subscriptions.

A six-week study plan

Week 1 · DiagnosisFind out where you standRead the official guide and mark each skill: I've got it / I know it / I don't know it. Take Microsoft Learn's free practice assessment.
Week 2 · Prepare the dataPower Query in depthReview Lessons 2 and 14; practice profiling, append and merge, and parameters.
Weeks 3 and 4 · ModelModel and DAXReview Lessons 5 to 8 and 11; practice special relationships and DAX until you can write CALCULATE without looking anything up.
Week 5 · Visualize and manageReports and the serviceLessons 9, 10 and 13; create a workspace, an app and a row-level security role from scratch.
Week 6 · Mock examsPractice under time pressureTwo full timed practice assessments; review every mistake in the documentation.

Exam day

I read the whole question before looking at the options: many have a key detail at the end ("with the least administrative effort", "without changing the model").
I eliminate the clearly wrong answers first.
I mark doubtful questions for review and keep going; I come back at the end if there's time.
In case studies, I read the questions first and then look in the case only for the information I need.
If I'm testing online, I checked my computer and connection in advance and set up a clear workspace, as the proctoring rules require.

2. A question asks for the solution "that requires the least maintenance effort". Two options would work. Which do you choose?

The most technically complete one.
The one that uses the most DAX functions.
The one that solves the problem with the fewest manual steps or repeated configurations.

On Microsoft exams those qualifiers decide the answer. Several options may work; only one meets the stated condition.

Your portfolio

The certification proves you know the tool; the portfolio proves you can use it for a business. With what you built in this course you already have material:

Summit Supply sales dashboard

Lesson 12, plus the ABC and RFM analysis from Lesson 15.

Finding to share: sales grew 8.3% but missed the target, and the top seller is the furthest from her own target.

Income statement

Lesson 13: a layout table, SWITCH and break-even.

Finding to share: with a 30% gross margin, a month with 11% lower sales tips into a loss.

A project of your own

U.S. public data: data.gov, the Census Bureau, the Bureau of Labor Statistics or your city's open data portal.

Why: it shows initiative and gives you something to talk about in the interview.

For each project, prepare a page (on LinkedIn, a personal site or GitHub) with: the business question, the data sources, the model (a Model view screenshot), two or three key DAX measures, report screenshots and three findings with the decision each one suggests. If you publish the report on the web, always use public or made-up data: never your employer's data. For résumé and job-search tactics, see How to get your first data analyst job.

The data analyst interview

It usually mixes technical questions, a hands-on case and behavioral questions. Prepare answers for these:

Common question	What they want to hear
What's the difference between a measure and a calculated column?	When each is calculated, memory use and an example of when to use each (Lesson 6)
Explain filter context and context transition	A concrete example with CALCULATE (Lesson 7)
Why a star schema?	Performance, simpler DAX and predictable filters (Lesson 5)
A report takes forever to load. What do you do?	Performance analyzer, fewer columns, a star schema, measures with variables (Lesson 11)
How do you make sure the numbers are right?	Tie out to the source or the books, check orphan data (the P99 case), validate with users
Tell me about an analysis that led to a decision	A STAR story: situation, task, action and result (for example, the at-risk customers from Lesson 15)

The take-home case

Many companies hand you an Excel file and give you an hour or two to build a report. Use the final-project method: understand the question, clean, model as a star, create a few well-named measures and one clear page, and above all finish with written conclusions. A simple report with three clear findings beats one packed with charts and no message.

3. Besides report screenshots, what should every portfolio project include?

The business question, the sources, the model, the key measures and the findings with their decisions.
The .pbix file with your current employer's data.
A list of every visual you used.

Companies hire people who answer business questions. And never publish your employer's data: it's a serious breach of confidentiality.

4. You passed the PL-300 almost a year ago. What do you need to do to keep the certification?

Pay again and retake the full exam.
Pass the free online renewal assessment on Microsoft Learn before it expires.
Nothing: associate certifications don't expire.

Associate certifications expire every year and are renewed with a free online assessment, which opens in the months before the expiration date.

Common mistakes when preparing for the exam and the job search

Studying only with memorized practice questions.

Practice every skill in the guide in Power BI Desktop; questions change, concepts don't.

Skipping "manage and secure" because it "doesn't weigh much".

It's 15–20% of the exam: create a workspace, an app and security roles at least once.

A portfolio of screenshots with no context.

Business question, model, key measures and three findings with their decisions.

Explaining DAX in the interview with memorized definitions.

A concrete example: "on the Oil row, CALCULATE replaced the product filter…".

Showing reports built on your employer's data.

Fictional or public data, always.

Practice exercise: your certification and job plan

Download the official PL-300 study guide and sort every skill into "I've got it / I know it / I don't know it".
Build your six-week calendar with real dates and book the exam for the end.
Pick a U.S. public data source and write the business question and three possible findings for your own project.
Write your answer to "Tell me about an analysis that led to a decision" in STAR format.

See solution

Here's a sample interview answer in STAR format:

"In a project with a food distributor's sales data (situation), I was asked to find where the sales team should focus (task). I segmented the 40 customers with an RFM model in Power BI, using calculated columns for recency, frequency and monetary value (action). I found that the previous year's largest customer hadn't ordered in 41 days, when the norm was about two weeks, and that together with two other at-risk accounts they represented almost $35,000 in lifetime purchases. I built an alerts page that shows those customers in red, so every rep gets a weekly call list, and the team moved from watching total sales to acting on specific accounts (result)."

If it's a practice project, say so naturally: what interviewers evaluate is how you think.

Summary

The PL-300 certifies four areas (prepare, model, visualize and analyze, and manage and secure); you pass with 700 and renew free every year.
Study with the official guide and Microsoft Learn's practice assessments, and review the topics this course covers less.
A six-week plan: diagnosis, one week per area and mock exams.
A portfolio with business questions, models, measures and findings, always with public or fictional data.
In interviews, explain concepts with examples and tell STAR stories about analyses that led to decisions.

Course recap

Level 1, Beginner: what Power BI is, Power Query, visuals and report design.
Level 2, Intermediate: the star schema, DAX, CALCULATE and time intelligence.
Level 3, Advanced: interactivity, publishing and security, advanced DAX and the final project.
Level 4, Expert: the income statement, database connections and refresh, ABC and RFM analysis, and PL-300 prep.

Your course certificate

Congratulations, you've finished the Free Power BI Course! You went from your first report to a complete sales dashboard, an income statement and ABC and RFM analysis. To get your free certificate:

Create your free account at cursosrentables.com (or log in if you already have one).
Mark all 16 lessons as completed: at the end of each one, click "Mark lesson as completed".
Download your certificate: when your progress reaches 100%, the "Download my certificate" button appears at the end of this lesson. Add it to the Licenses & Certifications section of your LinkedIn profile or to your résumé.

This course certificate doesn't replace the official PL-300 certification; the two complement each other. To strengthen the business side of your analysis, continue with our free bookkeeping and accounting course, or automate data prep with Python for data analysis. And whenever you want to learn something new, every free course is in the course catalog.