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.
No PL-300 practice exam yet
Your points already work on 21 Amazon and Microsoft exams.
See the 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
No PL-300 practice exam yet
Your points already work on 21 Amazon and Microsoft exams.
See the exams