Microsoft PL-300 Exam Preparation and Practice

This course is part of Microsoft Power BI Data Analyst Professional Certificate

Instructor: Microsoft

Access provided by Abu Dhabi National Oil Company

61,332 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

652 reviews

Beginner level

Recommended experience

Flexible schedule

4 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

652 reviews

Beginner level

Recommended experience

Flexible schedule

4 weeks at 10 hours a week

Learn at your own pace

94%

Most learners liked this course

What you'll learn

Prepare the data with Power BI.
Model, visualize, and analyze the data in Power BI.
How to deploy and maintain Power BI assets.
NEW [optional] Generative AI for Power BI.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

15 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Analysis expertise

This course is part of the Microsoft Power BI Data Analyst Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

There are 5 modules in this course

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offer a good starting point for a career in data analysis using Microsoft Power BI.

This course will help you prepare for the Microsoft PL-300 exam. In this course, you’ll refresh your knowledge of all the key areas assessed in the Microsoft-certified Exam PL-300: Microsoft Power BI Data Analyst. In addition, you will prepare for the certification exam by taking a mock exam with a similar format and content as in the Microsoft PL-300 exam. You’ll also get tips and tricks, testing strategies, useful resources, and information on how to sign up for the Microsoft PL-300 proctored exam. This course is a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification. Earning a Microsoft Certification is globally recognized evidence of real-world skills. After completing this course, you'll be able to: ● Prepare the data ● Model the data ● Visualize and analyze the data ● Deploy and maintain assets

In this module, you will revise key concepts related to preparing and loading data in Power BI to prepare for the PL-300 exam.

What's included

13 videos30 readings3 assignments2 discussion prompts

13 videos Total 58 minutes

Course introduction 5 minutes
Introduction to preparing for the exam 4 minutes
Identify and connect to a data source 4 minutes
DirectQuery, Import, and Dual mode 4 minutes
Parameter values 4 minutes
Connecting to a dataflow 4 minutes
Evaluating data, data statistics, and column properties 6 minutes
Resolve inconsistencies and data quality issues 4 minutes
Create and transform columns 5 minutes
Identify when to use reference queries 4 minutes
Merge and append queries 6 minutes
Table relationships 4 minutes
Module summary: Preparing data 4 minutes

30 readings Total 435 minutes

Course syllabus 10 minutes
How to be successful in this course 10 minutes
How to open an image in a new tab 10 minutes
Setting up your Power BI environment 10 minutes
New name for Power BI datasets 10 minutes
Additional resources: Microsoft PL-300 Exam resources 5 minutes
How to prepare for the proctored examination 10 minutes
How the exam is administered 10 minutes
Topics covered in the Exam PL-300: Microsoft Power BI Data Analyst 10 minutes
Testing strategy 10 minutes
Additional resources: Microsoft certification 5 minutes
Connectors in Power BI 10 minutes
Shared dataset or local dataset 10 minutes
Activity: Set up a data source 30 minutes
Managing data sources 10 minutes
Microsoft Dataverse 10 minutes
In-depth: Get data from data sources 10 minutes
Additional resources: Get data from data sources 5 minutes
Activity: Analyze a dataset 30 minutes
Activity: Resolve data import errors 30 minutes
In-depth: Profiling and cleaning data 10 minutes
Additional resources: Profiling and cleaning data 5 minutes
Activity: Shape and transform tables 30 minutes
Activity: Table Transformations in Power Query 30 minutes
Splitting column data 10 minutes
Activity: Sorting columns 30 minutes
Activity: Configure data loading for queries 30 minutes
Activity: Find top performing products 30 minutes
In-depth: Transform and load data 10 minutes
Additional resources: Transform and load data 5 minutes

3 assignments Total 45 minutes

Self-review: What did you learn? 15 minutes
Self-review: What did you learn? 15 minutes
Self-review: What did you learn? 15 minutes

2 discussion prompts Total 20 minutes

How do you prepare for the PL-300 Exam? 10 minutes
Have you found any good exam prep materials? 10 minutes

In this module, you will revise key concepts related to modeling data in Power BI to prepare for the PL-300 exam.

What's included

13 videos20 readings4 assignments

13 videos Total 66 minutes

Designing a schema 4 minutes
Implementing role-playing dimensions 5 minutes
Using CALCULATE to manipulate filters 4 minutes
Cardinality and cross-filter direction 6 minutes
Calculated Columns 4 minutes
Single aggregation measures 5 minutes
Implement time intelligence measures 7 minutes
Additive, semi-additive and non-additive measures 4 minutes
Calculated tables 6 minutes
Data hierachies 6 minutes
Using the Performance Analyzer 5 minutes
Improve performancing via cardinality and summarization 6 minutes
Module summary: Modeling data 5 minutes

20 readings Total 360 minutes

Activity: Configure table and column properties 30 minutes
Activity: Common date tables 30 minutes
In-depth: Design a data model 10 minutes
Additional resources: Design a data model 5 minutes
Activity: Add a SUM aggregation measure 30 minutes
Activity: Replacing implicit measures 30 minutes
Statistical functions cheatsheet 10 minutes
Activity: Create a semi-additive measure 30 minutes
Path DAX functions 10 minutes
In-depth: Create model calculations using DAX 10 minutes
Additional Resources: Create model calculations using DAX 5 minutes
Activity: Adding a calculated table 30 minutes
Activity: Creating a report hierarchy 30 minutes
Activity: Add an Index Column 30 minutes
In-depth: Implement a data model 10 minutes
Additional Resources: Implement a data model 5 minutes
Activity: Optimal data types and reducing data 30 minutes
Best practices for SQL data sources 10 minutes
In-depth: Optimize model performance 10 minutes
Additional resources: Optimize model performance 5 minutes

4 assignments Total 61 minutes

Self-review: What did you learn? 18 minutes
Self-review: What did you learn? 15 minutes
Self-Review: What did you learn? 18 minutes
Self-review: What did you learn? 10 minutes

In this module, you will revise key concepts related to visualizing and analzying data in Power BI to prepare for the PL-300 exam.

What's included

14 videos24 readings3 assignments

14 videos Total 71 minutes

Using appropriate visualizations 5 minutes
Configuring and formatting visualizations 4 minutes
Slicing and filtering 3 minutes
Report navigation and sorting 6 minutes
Interactions between visuals 6 minutes
Sync slicers 4 minutes
Group and layer visuals by using the Selection pane 4 minutes
Design reports for mobile devices 5 minutes
Detect outliers and anomalies 5 minutes
Grouping and binning data 5 minutes
AI visuals 6 minutes
Reference lines and error bars 6 minutes
Scorecards and metrics 5 minutes
Module Summary: Visualize and Analyze data 6 minutes

24 readings Total 525 minutes

Activity: Format and configure visualizations 30 minutes
Activity: Conditional formatting 30 minutes
Activity: Configure the report page 30 minutes
Activity: Use a custom visual 30 minutes
Activity: Using the Play Axis visualization 30 minutes
Export and printing reports 10 minutes
Activity: Exporting and Importing Themes 30 minutes
In-depth: Creating reports 10 minutes
Additional Resources: Creating reports 5 minutes
Activity: Configure a bookmark 30 minutes
Activity: Create custom tooltips 30 minutes
Conditional formatting for buttons 10 minutes
Activity: Apply sorting 30 minutes
What is published with a report? 10 minutes
Activity: Using the Q&A feature for reports 30 minutes
Activity: Add the Q&A feature to a dashboard 30 minutes
In-depth: Enhance Reports for usability and storytelling 10 minutes
Additional resources: Enhance reports for usability and storytelling 5 minutes
Activity: Anomaly detection 30 minutes
Activity: Grouping data 30 minutes
Activity: Binning data 30 minutes
Activity: Using the Analyze feature 30 minutes
In-depth: Identify patterns and trends 10 minutes
Additional Resources: Identify patterns and trends 5 minutes

3 assignments Total 60 minutes

Self-Review: What did you learn? 24 minutes
Self-review: What did you learn? 21 minutes
Self-Review: What did you learn? 15 minutes

In this module, you will revise key concepts related to deploying and maintaining assets in Power BI to prepare for the PL-300 exam.

What's included

8 videos10 readings2 assignments

8 videos Total 45 minutes

Workspaces and workspace roles 5 minutes
Workspace apps 5 minutes
Subscriptions and data alerts 4 minutes
Promote or certify Power BI content 5 minutes
Data gateways 7 minutes
Row-level security 8 minutes
Providing access to datasets 6 minutes
Module Summary: Deploy and maintain assets 5 minutes

10 readings Total 170 minutes

Activity: Create a workspace 30 minutes
Publish, import, or update assets in a workspace 10 minutes
Activity: Create dashboards 30 minutes
Activity: Apply sensitivity labels 30 minutes
Global options for files 10 minutes
In-depth: Create and manage workspaces and assets 10 minutes
Additional Resources: Deploy and maintain assets 5 minutes
Activity: Configure a dataset scheduled refresh 30 minutes
In-depth: Manage datasets 10 minutes
Additional Resources: Manage datasets 5 minutes

2 assignments Total 30 minutes

Self-Review: What did you learn? 15 minutes
Self-Review: What did you learn? 15 minutes

In this module, you’ll also have access to resources that will help you to prepare for the Microsoft Exam PL-300: Microsoft Power BI Data Analyst.

What's included

7 videos8 readings3 assignments1 peer review3 discussion prompts

7 videos Total 36 minutes

Introduction to the PL-300 Exam 5 minutes
Understanding Microsoft Copilot 6 minutes
Understanding Copilot for Power BI Specialists 5 minutes
Enhancing Report Design with AI-assisted Tasks 4 minutes
Mastering DAX Formulas with Copilot 6 minutes
Congratulations 5 minutes
Day in the life 4 minutes

8 readings Total 80 minutes

Preparing for the exam 10 minutes
Microsoft PL-300 Practice Assessment 10 minutes
Sign-up for the proctored exam 10 minutes
Navigating the risks and challenges when using Generative AI tools 10 minutes
Enhancing Power BI Reports with Copilot 10 minutes
Congratulations and looking forward 10 minutes
Career opportunities through learning 10 minutes
Next steps 10 minutes

3 assignments Total 190 minutes

Troubleshooting DAX Formulas with Bing Copilot 10 minutes
Lesson Quiz: Microsoft Generative AI for Power BI 30 minutes
PL-300 Mock Exam 150 minutes

1 peer review Total 10 minutes

Peer Review 10 minutes

3 discussion prompts Total 30 minutes

Which study techniques and strategies were the most helpful? 10 minutes
Exam reflections 10 minutes
Reflect on learning 10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(173 ratings)

Microsoft

287 Courses 2,373,262 learners

Offered by

Microsoft

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
76.79%
4 stars
15.87%
3 stars
3.81%
2 stars
1.22%
1 star
2.29%

Showing 3 of 652

Reviewed on Aug 25, 2024

course was well structured i still didnot recieve pl 300 voucher for exam

Reviewed on Jan 10, 2025

Very good learning course for me. I more clear understanding for Power BI after this course.

Reviewed on Dec 18, 2024

In-depth content on using Power BI and helps provide you with the hands on learning needed to become proficient.

View more reviews

Explore more from Data Science

Packt
PL-300 Microsoft Power BI Analyst Certification Guide
Course
Whizlabs
Exam Prep PL-300: Microsoft Power BI Data Analyst Associate
Specialization
SkillUp
Power BI Data Analyst Associate Prep
Course
Microsoft
Deploy and Maintain Power BI Assets and Capstone project
Course

Microsoft PL-300 Exam Preparation and Practice

Microsoft PL-300 Exam Preparation and Practice

What you'll learn

Skills you'll gain

Tools you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

Build your Data Analysis expertise

There are 5 modules in this course

Preparing Data

What's included

Modeling Data

What's included

Visualize and analyze data

What's included

Deploy and maintain assets

What's included

Practice Exam

What's included

Earn a career certificate

Instructor

Offered by

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Learner reviews

Explore more from Data Science

PL-300 Microsoft Power BI Analyst Certification Guide

Exam Prep PL-300: Microsoft Power BI Data Analyst Associate

Power BI Data Analyst Associate Prep

Deploy and Maintain Power BI Assets and Capstone project