Microsoft PL-300 Exam Preparation and Practice

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

Instructor: Microsoft

68,832 already enrolled

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

16 assignments¹

AI Graded see disclaimer

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 review how preparing data is covered on the PL-300 exam. You will focus on the core concepts involved in connecting to data sources, addressing data quality issues, and shaping and loading data in Power BI.

What's included

13 videos26 readings3 assignments1 discussion prompt

13 videosTotal 58 minutes

Course introduction5 minutes
Introduction to preparing for the exam4 minutes
Identify and connect to a data source4 minutes
DirectQuery, Import, and Dual mode4 minutes
Parameter values4 minutes
Connecting to a dataflow4 minutes
Evaluating data, data statistics, and column properties6 minutes
Resolve inconsistencies and data quality issues4 minutes
Create and transform columns5 minutes
Identify when to use reference queries4 minutes
Merge and append queries6 minutes
Table relationships4 minutes
Module summary: Preparing data4 minutes

26 readingsTotal 395 minutes

Course syllabus10 minutes
Additional resources: Microsoft PL-300 Exam resources5 minutes
How to prepare for the proctored examination10 minutes
How the exam is administered10 minutes
Topics covered in the Exam PL-300: Microsoft Power BI Data Analyst10 minutes
Testing strategy10 minutes
Additional resources: Microsoft certification5 minutes
Connectors in Power BI10 minutes
Shared dataset or local dataset10 minutes
Activity: Set up a data source30 minutes
Managing data sources10 minutes
Microsoft Dataverse10 minutes
In-depth: Get data from data sources10 minutes
Additional resources: Get data from data sources5 minutes
Activity: Analyze a dataset30 minutes
Activity: Resolve data import errors30 minutes
In-depth: Profiling and cleaning data10 minutes
Additional resources: Profiling and cleaning data5 minutes
Activity: Shape and transform tables30 minutes
Activity: Table Transformations in Power Query30 minutes
Splitting column data10 minutes
Activity: Sorting columns30 minutes
Activity: Configure data loading for queries30 minutes
Activity: Find top performing products30 minutes
In-depth: Transform and load data10 minutes
Additional resources: Transform and load data5 minutes

3 assignmentsTotal 45 minutes

Power BI Data Storage, Access, and Shared Dataset Fundamentals15 minutes
Power Query Data Profiling and Error Handling Check15 minutes
Power BI Fundamentals: Data Transformation and Modeling15 minutes

1 discussion promptTotal 10 minutes

How do you prepare for the PL-300 Exam?10 minutes

In this module, you will review key concepts related to modeling data in Power BI for the PL-300 exam, including data model design, DAX calculations, model implementation, and performance optimization.

What's included

13 videos20 readings4 assignments

13 videosTotal 66 minutes

Designing a schema4 minutes
Implementing role-playing dimensions5 minutes
Using CALCULATE to manipulate filters4 minutes
Cardinality and cross-filter direction6 minutes
Calculated Columns4 minutes
Single aggregation measures5 minutes
Implement time intelligence measures7 minutes
Additive, semi-additive and non-additive measures4 minutes
Calculated tables6 minutes
Data hierachies6 minutes
Using the Performance Analyzer5 minutes
Improve performancing via cardinality and summarization6 minutes
Module summary: Modeling data5 minutes

20 readingsTotal 360 minutes

Activity: Configure table and column properties30 minutes
Activity: Common date tables30 minutes
In-depth: Design a data model10 minutes
Additional resources: Design a data model5 minutes
Activity: Add a SUM aggregation measure30 minutes
Activity: Replacing implicit measures30 minutes
Statistical functions cheatsheet10 minutes
Activity: Create a semi-additive measure30 minutes
Path DAX functions10 minutes
In-depth: Create model calculations using DAX10 minutes
Additional Resources: Create model calculations using DAX5 minutes
Activity: Adding a calculated table30 minutes
Activity: Creating a report hierarchy30 minutes
Activity: Add an Index Column30 minutes
In-depth: Implement a data model10 minutes
Additional Resources: Implement a data model5 minutes
Activity: Optimal data types and reducing data30 minutes
Best practices for SQL data sources10 minutes
In-depth: Optimize model performance10 minutes
Additional resources: Optimize model performance5 minutes

4 assignmentsTotal 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 review how to visualize and analyze data in Power BI for the PL-300 exam. You will work with core concepts for creating reports, improving report usability and storytelling, and identifying patterns and trends by using features such as filtering, navigation, interactions, AI visuals, anomaly detection, grouping, binning, metrics, and reference lines.

What's included

14 videos24 readings3 assignments

14 videosTotal 71 minutes

Using appropriate visualizations5 minutes
Configuring and formatting visualizations4 minutes
Slicing and filtering3 minutes
Report navigation and sorting6 minutes
Interactions between visuals6 minutes
Sync slicers4 minutes
Group and layer visuals by using the Selection pane4 minutes
Design reports for mobile devices5 minutes
Detect outliers and anomalies5 minutes
Grouping and binning data5 minutes
AI visuals6 minutes
Reference lines and error bars6 minutes
Scorecards and metrics5 minutes
Module Summary: Visualize and Analyze data6 minutes

24 readingsTotal 525 minutes

Activity: Format and configure visualizations30 minutes
Activity: Conditional formatting30 minutes
Activity: Configure the report page30 minutes
Activity: Use a custom visual30 minutes
Activity: Using the Play Axis visualization30 minutes
Export and printing reports10 minutes
Activity: Exporting and Importing Themes30 minutes
In-depth: Creating reports10 minutes
Additional Resources: Creating reports5 minutes
Activity: Configure a bookmark30 minutes
Activity: Create custom tooltips30 minutes
Conditional formatting for buttons10 minutes
Activity: Apply sorting30 minutes
What is published with a report?10 minutes
Activity: Using the Q&A feature for reports30 minutes
Activity: Add the Q&A feature to a dashboard30 minutes
In-depth: Enhance Reports for usability and storytelling10 minutes
Additional resources: Enhance reports for usability and storytelling5 minutes
Activity: Anomaly detection30 minutes
Activity: Grouping data30 minutes
Activity: Binning data30 minutes
Activity: Using the Analyze feature30 minutes
In-depth: Identify patterns and trends10 minutes
Additional Resources: Identify patterns and trends5 minutes

3 assignmentsTotal 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 review the core concepts used to deploy and maintain Power BI assets for the PL-300 exam. You will focus on workspaces, workspace roles, apps, dashboards, sensitivity labels, subscriptions, alerts, and content endorsement, along with dataset management concepts such as gateways, scheduled refresh, row-level security, and dataset access.

What's included

8 videos10 readings2 assignments

8 videosTotal 45 minutes

Workspaces and workspace roles5 minutes
Workspace apps5 minutes
Subscriptions and data alerts4 minutes
Promote or certify Power BI content5 minutes
Data gateways7 minutes
Row-level security8 minutes
Providing access to datasets6 minutes
Module Summary: Deploy and maintain assets5 minutes

10 readingsTotal 170 minutes

Activity: Create a workspace30 minutes
Publish, import, or update assets in a workspace10 minutes
Activity: Create dashboards30 minutes
Activity: Apply sensitivity labels30 minutes
Global options for files10 minutes
In-depth: Create and manage workspaces and assets10 minutes
Additional Resources: Deploy and maintain assets5 minutes
Activity: Configure a dataset scheduled refresh30 minutes
In-depth: Manage datasets10 minutes
Additional Resources: Manage datasets5 minutes

2 assignmentsTotal 30 minutes

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

In this module, you will bring together what you’ve learned across the course as you prepare for the PL-300 practice exam. You will review how core Power BI skills connect across the data analyst workflow, examine how Microsoft Copilot supports business and reporting tasks, and consider how AI can assist with report design and DAX troubleshooting. You will also reflect on your learning and identify next steps in your Power BI journey.