Exam PL-300 Microsoft Power BI Data Analyst, 3rd edition (Video), 3rd Edition

Description

• Copyright 2026
• Edition: 3rd

• Online Video
• ISBN-10: 0-13-549517-2
• ISBN-13: 978-0-13-549517-9

6+ Hours of Video Instruction

Fully Updated! Prepare for Microsoft Exam PL-300 and level up in your career as a Power BI data analyst.

Overview:

This Exam PL-300 Microsoft Power BI Data Analyst video is designed for data analysts responsible for designing scalable data models, cleaning and transforming data, and presenting analytic insights through data visualizations using Power BI. This video focuses on the skills measured by the exam objectives, as updated by Microsoft in April 2025:

• Prepare the data
• Model the data
• Visualize and analyze data
• Manage and secure Power BI

Using his years of experience teaching Power BI to a variety of learners, Microsoft Certified Trainer Chris Sorensen explains how to optimize Power BI features and functions and prepares you for what to expect on the PL-300 exam.  In his engaging style grounded in real-world scenarios, Chris gives you insights to navigate and build Power BI solutions, quickly and effectively. With Chris as your guide, you are well-equipped to advance in your career as a data analyst.

 

Skill Level:

• Intermediate

Who Should Take This Course:

• Certification candidates preparing for exam PL-300 Microsoft Power BI Data Analyst
• Data analysts who want to use Microsoft Power BI to maximize their data assets and deliver actionable insights
• Business intelligence professionals who want to advance their knowledge of data processing and analytics

 Course Requirements:

• Power BI Desktop installed on your machine
• Access to the Power BI service
• Familiarity with the end-to-end process of connecting to data sources, cleaning and transforming data, modeling data for self-service consumption, building reports and securely distributing reports and dashboards

About Pearson Video Training:
Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, Sams, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.



Sample Content

Table of Contents

Introduction 

Module 1: Prepare the Data

Lesson 1: Get or connect to data

1.1 Identify and connect to data sources or a shared semantic model

1.2 Change data source settings, including credentials and privacy levels

1.3 Choose between DirectQuery and Import

1.4 Create and modify parameters

Lesson 2: Profile and clean the data

2.1 Evaluate data, including data statistics and column properties

2.2 Resolve inconsistencies, unexpected or null values, and data quality issues

2.3 Resolve data import errors

Lesson 3: Transform and load the data

3.1 Select appropriate column data types

3.2 Create and transform columns

3.3 Group and aggregate rows

3.4 Pivot, unpivot, and transpose data

3.5 Convert semi-structured data to a table

3.6 Create fact tables and dimension tables

3.7 Identify when to use reference or duplicate queries and the resulting impact

3.8 Merge and append queries

3.9 Identify and create appropriate keys for relationships

3.10 Configure data loading for queries

Module 2: Model the Data

Lesson 4: Design and implement a data model

4.1 Configure table and column properties

4.2 Implement role-playing dimensions

4.3 Define a relationship's cardinality and cross-filter direction

4.4 Create a common date table 

4.5 Identify use cases for calculated columns and calculated tables

Lesson 5: Create model calculations by using DAX

5.1 Create single aggregation measures

5.2 Use the CALCULATE function

5.3 Implement time intelligence measures

5.4 Use basic statistical functions

5.5 Create semi-additive measures

5.6 Create a measure by using quick measures

5.7 Create calculated tables or columns

5.8 Create calculation groups

Lesson 6: Optimize model performance

6.1 Improve performance by identifying and removing unnecessary rows and columns 

6.2 Identify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query view

6.3 Improve performance by reducing granularity

Module 3: Visualize and Analyze the Data

Lesson 7: Create reports

7.1 Select an appropriate visual

7.2 Format and configure visuals

7.3 Apply and customize a theme

7.4 Apply conditional formatting 

7.5 Apply slicing and filtering

7.6 Configure the report page

7.7 Choose when to use a paginated report

7.8 Create visual calculations by using DAX

Lesson 8: Enhance reports for usability and storytelling

8.1 Configure bookmarks

8.2 Create custom tooltips

8.3 Edit and configure interactions between visuals

8.4 Configure navigation for a report

8.5 Apply sorting to visuals

8.6 Configure sync slicers

8.7 Group and layer visuals by using the Selection pane

8.8 Configure drill through navigation

8.9 Configure export settings

8.10 Design reports for mobile devices

8.11 Enable personalized visuals in a report

8.12 Design and configure Power BI reports for accessibility

8.13 Configure automatic page refresh

Lesson 9: Identify patterns and trends 

9.1 Use the Analyze feature in Power BI

9.2 Use grouping, binning, and clustering

9.3 Use AI visuals

9.4 Use reference lines, error bars, and forecasting

9.5 Detect outliers and anomalies

Module 4: Manage and Secure Power BI

Lesson 10: Create and manage workspaces and assets

10.1 Create and configure a workspace

10.2 Configure and update a workspace app

10.3 Publish, import, or update items in a workspace

10.4 Create dashboards 

10.5 Choose a distribution method

10.6 Configure subscriptions and data alerts

10.7 Promote or certify Power BI content

10.8 Identify when a gateway is required

10.9 Configure a semantic model scheduled refresh

Lesson 11: Secure and govern Power BI items

11.1 Assign workspace roles 

11.2 Configure item-level access

11.3 Configure access to semantic models

11.4 Implement row-level security roles

11.5 Configure row-level security group membership

11.6 Apply sensitivity labels

Summary



Updates

Submit Errata

