Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Contents

• Introduction Introduction

  • Exam PL-300 Microsoft Power BI Data Analyst: Introduction

    4m 10s
• Module 1: Prepare the Data Module 1: Prepare the Data

  • Module introduction

    1m 9s
• Lesson 1: Get Data from Data Sources Lesson 1: Get Data from Data Sources

  • Learning objectives

    35s
  • Identify and connect to a data source

    4m
  • Change data source settings, including credentials, privacy levels, and data source locations

    3m 58s
  • Select a shared semantic model, or create a local semantic model

    7m 2s
  • Choose between DirectQuery, Import, and Dual mode

    7m 7s
  • Change the value in a parameter

    5m 27s
• Lesson 2: Clean the Data Lesson 2: Clean the Data

  • Learning objectives

    29s
  • (Locked)
    Evaluate data, including data statistics and column properties

    5m 33s
  • (Locked)
    Resolve inconsistencies, unexpected or null values, and data quality issues

    5m 5s
  • (Locked)
    Resolve data import errors

    6m 9s
• Lesson 3: Transform and Load the Data Lesson 3: Transform and Load the Data

  • (Locked)
    Learning objectives

    43s
  • (Locked)
    Select appropriate column data types

    5m 36s
  • (Locked)
    Create and transform columns

    5m 46s
  • (Locked)
    Transform a query

    4m 51s
  • (Locked)
    Design a star schema that contains facts and dimensions

    3m 55s
  • (Locked)
    Identify when to use reference or duplicate queries and the resulting impact

    4m 1s
  • (Locked)
    Merge and append queries

    8m 45s
  • (Locked)
    Identify and create appropriate keys for relationships

    2m 8s
  • (Locked)
    Configure data loading for queries

    2m 32s
• Module 2: Model the Data Module 2: Model the Data

  • (Locked)
    Module introduction

    30s
• Lesson 4: Design and Implement a Data Model Lesson 4: Design and Implement a Data Model

  • (Locked)
    Learning objectives

    29s
  • (Locked)
    Configure table and column properties

    3m 52s
  • (Locked)
    Implement role-playing dimensions

    2m 23s
  • (Locked)
    Define a relationship's cardinality and cross-filter direction

    4m 39s
  • (Locked)
    Create a common date table

    9m 13s
  • (Locked)
    Implement row-level security roles

    6m 7s
• Lesson 5: Create Model Calculations by Using DAX Lesson 5: Create Model Calculations by Using DAX

  • (Locked)
    Learning objectives

    37s
  • (Locked)
    Create single aggregation measures

    9m 27s
  • (Locked)
    Use CALCULATE to manipulate filters

    3m 40s
  • (Locked)
    Implement time intelligence measures

    2m 54s
  • (Locked)
    Identify implicit measures and replace with explicit measures

    3m 47s
  • (Locked)
    Use basic statistical functions

    4m 33s
  • (Locked)
    Create semi-additive measures

    4m 44s
  • (Locked)
    Create a measure by using quick measures

    3m 54s
  • (Locked)
    Create calculated tables

    2m 30s
• Lesson 6: Optimize Model Performance Lesson 6: Optimize Model Performance

  • (Locked)
    Learning objectives

    32s
  • (Locked)
    Improve performance by identifying and removing unnecessary rows and columns

    3m 46s
  • (Locked)
    Identify poorly performing measures, relationships, and visuals by using Performance Analyzer

    3m 57s
  • (Locked)
    Improve performance by choosing optimal data types

    1m 26s
  • (Locked)
    Improve performance by summarizing data

    6m 11s
• Module 3: Visualize and Analyze the Data Module 3: Visualize and Analyze the Data

  • (Locked)
    Module introduction

    32s
• Lesson 7: Create Reports Lesson 7: Create Reports

  • (Locked)
    Learning objectives

    40s
  • (Locked)
    Identify and implement appropriate visualizations

    7m 59s
  • (Locked)
    Format and configure visualizations

    3m 15s
  • (Locked)
    Use a custom visual

    4m 20s
  • (Locked)
    Apply and customize a theme

    2m 22s
  • (Locked)
    Configure conditional formatting

    3m 33s
  • (Locked)
    Apply slicing and filtering

    4m 54s
  • (Locked)
    Configure the report page

    2m 52s
  • (Locked)
    Use the Analyze in Excel feature

    3m 59s
  • (Locked)
    Choose when to use a paginated report

    1m 48s
• Lesson 8: Enhance Reports for Usability and Storytelling Lesson 8: Enhance Reports for Usability and Storytelling

  • (Locked)
    Learning objectives

    46s
  • (Locked)
    Configure bookmarks

    6m 11s
  • (Locked)
    Create custom tooltips

    3m 17s
  • (Locked)
    Edit and configure interactions between visuals

    3m 58s
  • (Locked)
    Configure navigation for a report

    2m 51s
  • (Locked)
    Apply sorting

    2m 16s
  • (Locked)
    Configure sync slicers

    3m 16s
  • (Locked)
    Group and layer visuals by using the Selection pane

    4m
  • (Locked)
    Drill down into data using interactive visuals

    2m 39s
  • (Locked)
    Configure export of report content and perform an export

    5m 11s
  • (Locked)
    Design reports for mobile devices

    3m 6s
  • (Locked)
    Enable personalized visuals in a report

    4m 55s
  • (Locked)
    Design and configure Power BI reports for accessibility

    5m 53s
• Lesson 9: Identify Patterns and Trends Lesson 9: Identify Patterns and Trends

  • (Locked)
    Learning objectives

    33s
  • (Locked)
    Use the Analyze feature in Power BI

    1m 47s
  • (Locked)
    Use grouping, binning, and clustering

    6m 52s
  • (Locked)
    Incorporate the Q&A feature in a report

    4m 40s
  • (Locked)
    Use AI visuals

    8m 45s
  • (Locked)
    Use reference lines, error bars, and forecasting

    5m 21s
  • (Locked)
    Detect outliers and anomalies

    2m 28s
  • (Locked)
    Create and share scorecards and metrics

    4m 22s
• Module 4: Deploy and Maintain Assets Module 4: Deploy and Maintain Assets

  • (Locked)
    Module introduction

    46s
• Lesson 10: Create and Manage Workspaces and Items Lesson 10: Create and Manage Workspaces and Items

  • (Locked)
    Learning objectives

    44s
  • (Locked)
    Create and configure a workspace

    3m
  • (Locked)
    Assign workspace roles

    2m 25s
  • (Locked)
    Configure and update a workspace app

    6m 17s
  • (Locked)
    Publish, import, or update items in a workspace

    4m 3s
  • (Locked)
    Create dashboards

    4m 43s
  • (Locked)
    Choose a distribution method

    1m 36s
  • (Locked)
    Apply sensitivity labels to workspace content

    2m 23s
  • (Locked)
    Configure subscriptions and data alerts

    5m 14s
  • (Locked)
    Promote or certify Power BI content

    2m 43s
  • (Locked)
    Manage global options for files

    2m 45s
• Lesson 11: Manage Semantic Models Lesson 11: Manage Semantic Models

  • (Locked)
    Learning objectives

    28s
  • (Locked)
    Identify when a gateway is required

    1m 52s
  • (Locked)
    Configure a semantic model scheduled refresh

    2m 28s
  • (Locked)
    Configure row-level security group membership

    3m 2s
  • (Locked)
    Provide access to semantic models

    2m 59s
• Summary Summary

  • (Locked)
    Exam PL-300 Microsoft Power BI Data Analyst: Summary

    1m 44s