Microsoft Power BI Data Analyst
Prepare for the PL-300 exam and demonstrate your ability to prepare data, model data, visualize and analyze data, and deploy and maintain Power BI assets.
Spend your points to unlock real exam questions
The points you’re earning right now aren’t just for show — redeem them on Godlike Exams to unlock real exam-style questions for the certifications you study here. 20 questions are free per exam to try right away.
Browse practice examsCourse Content
4 modules · 81 lessons
Module 1: Prepare the Data
Learn to get, clean, transform, and load data from various sources into Power BI. (25-30% of exam)
Get or Connect to Data
Learn to identify and connect to various data sources in Power BI.
- Lesson Introduction to Power BI Data Sources 10 min
- Quiz Power BI Data Sources Quiz 5 questions
- Lesson Connecting to Shared Semantic Models 10 min
- Quiz Shared Semantic Models Quiz 5 questions
- Lesson Data Source Settings and Credentials 10 min
- Quiz Data Source Settings Quiz 5 questions
- Lesson Privacy Levels in Power BI 10 min
- Quiz Privacy Levels Quiz 5 questions
- Lesson DirectLake vs DirectQuery vs Import 15 min
- Quiz Storage Modes Quiz 5 questions
- Lesson Creating and Modifying Parameters 10 min
- Quiz Parameters Quiz 5 questions
Profile and Clean the Data
Learn to evaluate and clean data using Power Query.
- Lesson Evaluating Data Statistics and Properties 10 min
- Quiz Data Statistics Quiz 5 questions
- Lesson Column Quality and Distribution 10 min
- Quiz Column Quality Quiz 5 questions
- Lesson Handling Null Values and Inconsistencies 15 min
- Quiz Null Values Quiz 5 questions
- Lesson Resolving Data Quality Issues 10 min
- Quiz Data Quality Quiz 5 questions
- Lesson Resolving Data Import Errors 10 min
- Quiz Import Errors Quiz 5 questions
Transform and Load the Data
Learn to transform data using Power Query and configure loading.
- Lesson Selecting Appropriate Data Types 10 min
- Quiz Data Types Quiz 5 questions
- Lesson Creating and Transforming Columns 15 min
- Quiz Transform Columns Quiz 5 questions
- Lesson Grouping and Aggregating Rows 10 min
- Quiz Group Aggregate Quiz 5 questions
- Lesson Pivot Unpivot and Transpose 15 min
- Quiz Pivot Unpivot Quiz 5 questions
- Lesson Converting Semi-Structured Data 10 min
- Quiz Semi-Structured Data Quiz 5 questions
- Lesson Creating Fact and Dimension Tables 15 min
- Quiz Fact Dimension Tables Quiz 5 questions
- Lesson Reference vs Duplicate Queries 10 min
- Quiz Reference Duplicate Quiz 5 questions
- Lesson Merging and Appending Queries 15 min
- Quiz Merge Append Quiz 5 questions
- Lesson Creating Relationship Keys 10 min
- Quiz Relationship Keys Quiz 5 questions
- Lesson Configuring Data Loading 10 min
- Quiz Data Loading Quiz 5 questions
Module 2: Model the Data
Learn to design data models, create DAX calculations, and optimize performance. (25-30% of exam)
Design and Implement a Data Model
Learn to configure tables relationships and model properties.
- Lesson Configuring Table and Column Properties 10 min
- Quiz Table Column Properties Quiz 5 questions
- Lesson Implementing Role-Playing Dimensions 15 min
- Quiz Role-Playing Dimensions Quiz 5 questions
- Lesson Relationship Cardinality and Cross-Filter 15 min
- Quiz Cardinality Cross-Filter Quiz 5 questions
- Lesson Creating a Common Date Table 15 min
- Quiz Date Table Quiz 5 questions
- Lesson Calculated Columns vs Calculated Tables 10 min
- Quiz Calculated Columns Tables Quiz 5 questions
Create Model Calculations with DAX
Learn to create measures and calculations using DAX.
- Lesson Introduction to DAX 15 min
- Quiz DAX Introduction Quiz 5 questions
- Lesson Creating Aggregation Measures 10 min
- Quiz Aggregation Measures Quiz 5 questions
- Lesson The CALCULATE Function 20 min
- Quiz CALCULATE Function Quiz 5 questions
- Lesson Time Intelligence Measures 20 min
- Quiz Time Intelligence Quiz 5 questions
- Lesson Statistical Functions in DAX 10 min
- Quiz Statistical Functions Quiz 5 questions
- Lesson Semi-Additive Measures 15 min
- Quiz Semi-Additive Measures Quiz 5 questions
- Lesson Quick Measures in Power BI 10 min
- Quiz Quick Measures Quiz 5 questions
- Lesson Calculation Groups 15 min
- Quiz Calculation Groups Quiz 5 questions
Optimize Model Performance
Learn to identify and fix performance issues in data models.
Module 3: Visualize and Analyze the Data
Learn to create reports, enhance usability, and identify patterns and trends. (25-30% of exam)
Create Reports
Learn to create and configure visuals and reports in Power BI.
- Lesson Selecting Appropriate Visuals 10 min
- Quiz Appropriate Visuals Quiz 5 questions
- Lesson Formatting and Configuring Visuals 15 min
- Quiz Format Configure Visuals Quiz 5 questions
- Lesson Narrative Visuals with Copilot 10 min
- Quiz Narrative Visuals Quiz 5 questions
- Lesson Applying and Customizing Themes 10 min
- Quiz Themes Quiz 5 questions
- Lesson Conditional Formatting 15 min
- Quiz Conditional Formatting Quiz 5 questions
- Lesson Slicing and Filtering 10 min
- Quiz Slicing Filtering Quiz 5 questions
- Lesson Using Copilot for Report Pages 10 min
- Quiz Copilot Reports Quiz 5 questions
- Lesson Configuring Report Pages 10 min
- Quiz Report Pages Quiz 5 questions
- Lesson Paginated Reports Overview 10 min
- Quiz Paginated Reports Quiz 5 questions
- Lesson Visual Calculations with DAX 15 min
- Quiz Visual Calculations Quiz 5 questions
Enhance Reports for Usability
Learn to enhance reports with bookmarks tooltips and navigation.
- Lesson Configuring Bookmarks 10 min
- Quiz Bookmarks Quiz 5 questions
- Lesson Creating Custom Tooltips 10 min
- Quiz Custom Tooltips Quiz 5 questions
- Lesson Visual Interactions 10 min
- Quiz Visual Interactions Quiz 5 questions
- Lesson Report Navigation 10 min
- Quiz Report Navigation Quiz 5 questions
- Lesson Sorting and Sync Slicers 10 min
- Quiz Sorting Sync Slicers Quiz 5 questions
- Lesson Selection Pane and Layering 10 min
- Quiz Selection Pane Quiz 5 questions
- Lesson Drillthrough Navigation 15 min
- Quiz Drillthrough Quiz 5 questions
- Lesson Export Settings 10 min
- Quiz Export Settings Quiz 5 questions
- Lesson Mobile Report Design 10 min
- Quiz Mobile Design Quiz 5 questions
- Lesson Report Personalization 10 min
- Quiz Personalization Quiz 5 questions
- Lesson Accessibility in Power BI Reports 10 min
- Quiz Accessibility Quiz 5 questions
- Lesson Automatic Page Refresh 10 min
- Quiz Auto Refresh Quiz 5 questions
Identify Patterns and Trends
Learn to use analytics features to identify patterns and trends.
- Lesson The Analyze Feature 10 min
- Quiz Analyze Feature Quiz 5 questions
- Lesson Grouping Binning and Clustering 15 min
- Quiz Grouping Binning Quiz 5 questions
- Lesson AI Visuals in Power BI 10 min
- Quiz AI Visuals Quiz 5 questions
- Lesson Reference Lines and Error Bars 10 min
- Quiz Reference Lines Quiz 5 questions
- Lesson Forecasting in Power BI 10 min
- Quiz Forecasting Quiz 5 questions
- Lesson Detecting Outliers and Anomalies 15 min
- Quiz Outliers Anomalies Quiz 5 questions
- Lesson Copilot for Model Summarization 10 min
- Quiz Copilot Summarization Quiz 5 questions
Module 4: Manage and Secure Power BI
Learn to create workspaces, manage assets, and implement security. (15-20% of exam)
Create and Manage Workspaces
Learn to create workspaces and manage Power BI assets.
- Lesson Creating and Configuring Workspaces 10 min
- Quiz Workspaces Quiz 5 questions
- Lesson Configuring and Updating Apps 10 min
- Quiz Apps Quiz 5 questions
- Lesson Publishing and Importing Items 10 min
- Quiz Publishing Quiz 5 questions
- Lesson Creating Dashboards 10 min
- Quiz Dashboards Quiz 5 questions
- Lesson Distribution Methods 10 min
- Quiz Distribution Quiz 5 questions
- Lesson Subscriptions and Data Alerts 10 min
- Quiz Subscriptions Alerts Quiz 5 questions
- Lesson Promoting and Certifying Content 10 min
- Quiz Promote Certify Quiz 5 questions
- Lesson Power BI Gateway 15 min
- Quiz Gateway Quiz 5 questions
- Lesson Scheduled Refresh Configuration 10 min
- Quiz Scheduled Refresh Quiz 5 questions
Secure and Govern Power BI
Learn to implement security and governance in Power BI.
- Lesson Workspace Roles 10 min
- Quiz Workspace Roles Quiz 5 questions
- Lesson Item-Level Access 10 min
- Quiz Item Access Quiz 5 questions
- Lesson Semantic Model Access 10 min
- Quiz Semantic Model Access Quiz 5 questions
- Lesson Implementing Row-Level Security 20 min
- Quiz Row-Level Security Quiz 5 questions
- Lesson RLS Group Membership 10 min
- Quiz RLS Group Quiz 5 questions
- Lesson Sensitivity Labels 10 min
- Quiz Sensitivity Labels Quiz 5 questions
Your Progress
Spend your points to unlock real exam questions
Spend your points on real exam questions.
Browse practice examsEnjoying the courses?
Everything stays free. Pro shows fewer ads, doubles the points you earn on every lesson and quiz so you progress twice as fast, unlocks half of every practice exam — plus full case studies — with the Learn & Exam study modes, and lets you read each lesson on one page.
- ✓ Fewer advertisements
- ✓ 2× points per lesson & quiz
- ✓ 50% of every exam unlocked
- ✓ Learn & Exam modes
- ✓ Distraction-free lessons