PL-300 Microsoft Power BI Analyst Certification Guide

PL-300 Microsoft Power BI Analyst Certification Guide

Instructor: Packt - Course Instructors

Included with Coursera Plus

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

12 hours to complete

3 weeks at 4 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

12 hours to complete

3 weeks at 4 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Connect Power BI to various data sources and configure settings for efficient data management.
Model data using DAX functions, relationships, and time intelligence for dynamic insights.
Create visually compelling reports using Power BI’s wide array of charts, slicers, and conditional formatting.
Manage and secure Power BI workspaces, dashboards, and reports for organizational use.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

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

There are 6 modules in this course

This course features Coursera Coach!

A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Prepare for the PL-300 Microsoft Power BI Analyst Certification with this comprehensive guide. You’ll start by learning how to install Power BI, connect to data sources, and ensure data quality. The course covers essential data preparation techniques, such as creating custom columns, pivoting data, and resolving inconsistencies, ensuring you have a solid foundation for analyzing and transforming data. Next, dive into data modeling with DAX functions and relationships, enhancing your data models and ensuring accurate insights. Learn to create dynamic visuals like pie charts, bar charts, and KPIs, and leverage AI-driven features such as Q&A and forecasting. Throughout, you'll explore how to optimize performance and manage Power BI reports and dashboards effectively. Designed for those aiming for the PL-300 certification, this course offers a blend of theory, practical exercises, and exam readiness tips, making it perfect for anyone looking to master Power BI for data analysis and reporting.

In this module, we will introduce you to the course's layout and objectives, provide an overview of the skills assessed in the certification exam, and explain the essential aspects of Power BI. Additionally, we will guide you through the installation of Power BI Desktop to begin your data analysis journey.

What's included

4 videos1 reading

In this module, we will focus on the critical skills needed to connect and configure data sources in Power BI. You will also explore data profiling, cleaning techniques, and learn how to build a strong data model using facts and dimension tables to optimize your analysis.

What's included

19 videos1 assignment1 plugin

19 videosTotal 112 minutes

Connect to Data Sources4 minutesPreview module
Configure Data Source Settings4 minutes
Storage Mode6 minutes
Create and Modify Parameters3 minutes
Understand Project Dataset and Import the Data4 minutes
Data Profiling4 minutes
Resolve Inconsistencies and Data Quality Issues12 minutes
Custom Column2 minutes
Index Column3 minutes
Conditional Column5 minutes
Column from Examples4 minutes
Group and Aggregation5 minutes
Pivot, Unpivot, and Transpose10 minutes
Merge Queries8 minutes
Append Queries4 minutes
Configure Data Loading2 minutes
Facts and Dimension Tables5 minutes
Duplicate and Reference11 minutes
M Code6 minutes

1 assignmentTotal 15 minutes

Prepare the Data - Assessment15 minutes

1 pluginTotal 15 minutes

Preparing Data for Analysis with Power BI15 minutes

In this module, we will dive into the fundamentals of data modeling and the DAX functions required to enhance your analysis. We will also cover techniques to optimize your Power BI models for performance and show how to organize measures effectively.

What's included

23 videos1 assignment1 plugin

23 videosTotal 132 minutes

Data Modelling Introduction and Common Schemas8 minutesPreview module
Define the Relationship9 minutes
Cross Filter3 minutes
Table and Column Properties5 minutes
DAX Introduction3 minutes
DAX Functions – Information5 minutes
DAX Functions – Text8 minutes
DAX – Date and Time Functions4 minutes
DAX – Related4 minutes
DAX – Logical Functions9 minutes
Measures7 minutes
Basic Statistics Measures2 minutes
Iterators6 minutes
Calculate6 minutes
Date Table8 minutes
Active Vs. Inactive Relationship5 minutes
Role Playing Dimension3 minutes
Time Intelligence Functions7 minutes
Semi-Additive Measures5 minutes
Quick Measures2 minutes
DAX Vs M Code4 minutes
Measure Table and Improve Model Performance4 minutes
Identify Poorly Performing Measures, Relationships, and Visuals2 minutes

1 assignmentTotal 15 minutes

Model the Data - Assessment15 minutes

1 pluginTotal 15 minutes

Data Modeling in Power BI15 minutes

In this module, we will teach you how to choose the right visuals and formats for your data, ensuring clear and effective communication of your findings. You will also learn how to implement interactive features that enhance user engagement and gain insights through AI tools and forecasting.

What's included

34 videos1 assignment1 plugin

34 videosTotal 160 minutes

Select an Appropriate Visual2 minutesPreview module
Clustered Column and Bar Chart5 minutes
Format a Visual9 minutes
Stacked Charts3 minutes
Pie, Donut, TreeMap4 minutes
Line, Area Charts6 minutes
Combo Charts2 minutes
Ribbon Chart2 minutes
Waterfall Chart4 minutes
Hierarchies and Drill Down8 minutes
Funnel Chart2 minutes
Scatter Chart5 minutes
Custom Tooltip3 minutes
Card Visuals4 minutes
KPI, Gauge Chart5 minutes
Conditional Formatting7 minutes
Apply Sorting3 minutes
Apply Themes2 minutes
Filters7 minutes
Slicers7 minutes
Add Logo and Report Formatting5 minutes
Bookmark and Selection11 minutes
Drillthrough Navigation4 minutes
Sync Slicers2 minutes
Edit Interactions3 minutes
Work with Geographic Data4 minutes
AI Visual – Q&A3 minutes
AI Visual – Decomposition Tree2 minutes
Analyze Feature3 minutes
Group and Bins7 minutes
Reference Lines2 minutes
Forecasting3 minutes
Configure Page Navigation2 minutes
Design Reports for Mobile Device4 minutes

1 assignmentTotal 15 minutes

Visualize and Analyse the Data - Assessment15 minutes

1 pluginTotal 15 minutes

Creating Effective Data Visualizations15 minutes

In this module, we will cover the administrative aspects of Power BI, including managing workspaces, publishing reports, and ensuring security. You will also learn how to configure automated updates, alerts, and implement security measures like RLS to protect sensitive information.

What's included

16 videos1 assignment1 plugin

16 videosTotal 58 minutes

Subscription Model3 minutesPreview module
Sign Up to Power BI Service1 minute
Workspace Creation3 minutes
Publish the Report1 minute
Assign Workspace Roles4 minutes
Create and Update Workspace App5 minutes
Publish, Import, or Update Items in a Workspace2 minutes
Create Dashboards6 minutes
Configure Subscription and Alerts5 minutes
Promoted and Certified3 minutes
Identify When a Gateway is Required5 minutes
Schedule Refresh2 minutes
Configure Item-Level Access1 minute
RLS5 minutes
Dynamic RLS4 minutes
Export Settings3 minutes

1 assignmentTotal 15 minutes

Manage and Secure Power BI - Assessment15 minutes

1 pluginTotal 15 minutes

Managing Power BI Reports and Publishing15 minutes

In this module, we will help you assess your readiness for the PL-300 exam through practice questions and problem-solving techniques. Additionally, we will guide you through the process of scheduling and preparing for the certification exam to ensure your success.

What's included

3 videos3 assignments

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

Packt - Course Instructors

Packt

756 Courses157,214 learners

Offered by

Packt

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."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.