Exam PL-300 Microsoft Power BI Data Analyst (Video)

Exam PL-300 Microsoft Power BI Data Analyst (Video)

by Chris Sorensen
Released September 2022
Publisher(s): Microsoft Press
ISBN: 9780137916115

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

6+ Hours of Video Instruction

Prepare for Microsoft Exam PL-300 and demonstrate your mastery of Power BI data analysis.

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 on February 28, 2022:

  • Prepare the data
  • Model the data
  • Visualize and analyze the data
  • Deploy and maintain assets

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 that is grounded in real-world scenarios, Chris gives you insights to navigate and build effective 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
  • 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.

Table of contents

  1. Introduction
    1. Exam PL-300 Microsoft Power BI Data Analyst: Introduction
  2. Module 1: Prepare the Data
    1. Module Introduction
  3. Lesson 1: Get Data from Different Data Sources
    1. Learning objectives
    2. 1.1 Identify and connect to a data source
    3. 1.2 Change data source settings
    4. 1.3 Select a shared dataset or create a local dataset
    5. 1.4 Select a storage mode
    6. 1.5 Use Microsoft Dataverse
    7. 1.6 Change the value in a parameter
    8. 1.7 Connect to a data flow
  4. Lesson 2: Clean, Transform, and Load the Data
    1. Learning objectives
    2. 2.1 Profile the data
    3. 2.2 Resolve inconsistencies, unexpected or null values, and data quality issues
    4. 2.3 Identify and create appropriate keys for joins
    5. 2.4 Evaluate and transform column data types
    6. 2.5 Shape and transform tables
    7. 2.6 Combine queries
    8. 2.7 Apply user-friendly naming conventions to columns and queries
    9. 2.8 Configure data loading
    10. 2.9 Resolve data import errors
  5. Module 2: Model the Data
    1. Module Introduction
  6. Lesson 3: Design a Data Model
    1. Learning objectives
    2. 3.1 Define the tables and design a data model that uses a star schema
    3. 3.2 Configure table and column properties
    4. 3.3 Design and implement role-playing dimensions
    5. 3.4 Define a relationship's cardinality and cross-filter direction
    6. 3.5 Create a common date table
  7. Lesson 4: Develop a Data Model
    1. Learning objectives
    2. 4.1 Create calculated tables
    3. 4.2 Create hierarchies
    4. 4.3 Create calculated columns
    5. 4.4 Implement row-level security roles
    6. 4.5 Use the Q feature
  8. Lesson 5: Create Model Calculations by Using DAX
    1. Learning objectives
    2. 5.1 Create basic measures by using DAX
    3. 5.2 Use CALCULATE to manipulate filters
    4. 5.3 Implement Time Intelligence using DAX
    5. 5.4 Replace implicit measures with explicit measures
    6. 5.5 Use basic statistical functions
    7. 5.6 Create semi-additive measures
    8. 5.7 Use quick measures
  9. Lesson 6: Optimize Model Performance
    1. Learning objectives
    2. 6.1 Remove unnecessary rows and columns
    3. 6.2 Identify poorly performing measures, relationships, and visuals
    4. 6.3 Reduce cardinality levels to improve performance
  10. Module 3: Visualize and Analyze the Data
    1. Module Introduction
  11. Lesson 7: Create Reports
    1. Learning objectives
    2. 7.1 Add visualization items to reports
    3. 7.2 Choose an appropriate visualization type
    4. 7.3 Format and configure visualizations
    5. 7.4 Use a custom visual
    6. 7.5 Apply and customize a theme
    7. 7.6 Configure conditional formatting
    8. 7.7 Apply slicing and filtering
    9. 7.8 Configure the report page
    10. 7.9 Use the Analyze in Excel feature
    11. 7.10 Choose when to use a paginated report
  12. Lesson 8: Create Dashboards
    1. Learning objectives
    2. 8.1 Manage tiles on a dashboard
    3. 8.2 Configure mobile view
    4. 8.3 Use the Q feature
    5. 8.4 Add a Quick Insights result to a dashboard
    6. 8.5 Apply a dashboard theme
    7. 8.6 Pin a live report page to a dashboard
  13. Lesson 9: Enhance Reports for Usability and Storytelling
    1. Learning objectives
    2. 9.1 Configure bookmarks
    3. 9.2 Create custom tooltips
    4. 9.3 Edit and configure interactions between visuals
    5. 9.4 Configure navigation for a report
    6. 9.5 Apply sorting
    7. 9.6 Configure Sync Slicers
    8. 9.7 Group and layer visuals by using the selection pane
    9. 9.8 Drilldown into data using interactive visuals
    10. 9.9 Export report data
    11. 9.10 Design reports for mobile devices
  14. Lesson 10: Identify Patterns and Trends
    1. Learning objectives
    2. 10.1 Use the Analyze feature in Power BI
    3. 10.2 Identify outliers
    4. 10.3 Choose between continuous and categorical axes
    5. 10.4 Use groupings, binnings, and clustering
    6. 10.5 Use AI visuals
    7. 10.6 Use the Forecast feature
    8. 10.7 Create reference lines by using the Analytics pane
  15. Module 4: Deploy and Maintain Assets
    1. Module Introduction
  16. Lesson 11: Manage Files and Datasets
    1. Learning objectives
    2. 11.1 Identify when a gateway is required
    3. 11.2 Configure a dataset scheduled refresh
    4. 11.3 Configure row-level security group membership
    5. 11.4 Provide access to datasets
    6. 11.5 Manage global options for files
  17. Lesson 12: Manage Workspaces
    1. Learning objectives
    2. 12.1 Create and configure a workspace
    3. 12.2 Assign workspace roles
    4. 12.3 Configure and update a workspace app
    5. 12.4 Publish, import, or update assets in a workspace
    6. 12.5 Apply sensitivity labels to workspace content
    7. 12.6 Configure subscriptions and data alerts
    8. 12.7 Promote or certify Power BI content
  18. Summary
    1. Exam PL-300 Microsoft Power BI Data Analyst: Summary

Product information

  • Title: Exam PL-300 Microsoft Power BI Data Analyst (Video)
  • Author(s): Chris Sorensen
  • Release date: September 2022
  • Publisher(s): Microsoft Press
  • ISBN: 9780137916115