Learning objectives - Power BI Tutorial

Contents

• Introduction Introduction

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

    4m 14s
• 1. Get or Connect to Data 1. Get or Connect to Data

  • (Locked)
    Module introduction: Prepare the data

    1m 10s
  • (Locked)
    Learning objectives

    28s
  • Identify and connect to data sources or a shared semantic model

    9m 47s
  • (Locked)
    Change data source settings, including credentials and privacy levels

    3m 58s
  • (Locked)
    Choose between DirectQuery and import

    6m 9s
  • (Locked)
    Create and modify parameters

    6m 9s
• 2. Profile and Clean the Data 2. Profile and Clean the Data

  • (Locked)
    Learning objectives

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

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

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

    6m 6s
• 3. Transform and Load the Data 3. Transform and Load the Data

  • (Locked)
    Learning objectives

    47s
  • (Locked)
    Select appropriate column data types

    6m 53s
  • (Locked)
    Create and transform columns

    9m 21s
  • (Locked)
    Group and aggregate rows

    2m 55s
  • (Locked)
    Pivot, unpivot, and transpose data

    5m 23s
  • (Locked)
    Convert semi-structured data to a table

    4m 44s
  • (Locked)
    Create fact tables and dimension tables

    4m 2s
  • (Locked)
    When to use reference or duplicate queries and their impact

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

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

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

    2m 32s
• 4. Design and Implement a Data Model 4. Design and Implement a Data Model

  • (Locked)
    Module introduction: Model the data

    29s
  • (Locked)
    Learning objectives

    30s
  • Configure table and column properties

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

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

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

    9m 56s
  • (Locked)
    Use cases for calculated columns and calculated tables

    2m 58s
• 5. Create Model Calculations Using DAX 5. Create Model Calculations Using DAX

  • (Locked)
    Learning objectives

    34s
  • (Locked)
    Create single aggregation measures

    12m 43s
  • (Locked)
    Use the CALCULATE function

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

    2m 57s
  • (Locked)
    Use basic statistical functions

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

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

    5m 10s
  • (Locked)
    Create calculated tables or columns

    5m 57s
  • (Locked)
    Create calculation groups

    9m 38s
• 6. Optimize Model Performance 6. Optimize Model Performance

  • (Locked)
    Learning objectives

    31s
  • (Locked)
    Find and remove extra rows and columns to improve performance

    3m 42s
  • (Locked)
    Identify poorly performing measures, relationships, and visuals

    9m 1s
  • Improve performance by reducing granularity

    6m 5s
• 7. Create Reports 7. Create Reports

  • (Locked)
    Module introduction: Visualize and analyze the data

    31s
  • (Locked)
    Learning objectives

    35s
  • (Locked)
    Select an appropriate visual

    7m 54s
  • (Locked)
    Format and configure visuals

    3m 13s
  • (Locked)
    Apply and customize a theme

    2m 22s
  • (Locked)
    Apply conditional formatting

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

    4m 52s
  • Configure the report page

    2m 50s
  • (Locked)
    Choose when to use a paginated report

    1m 49s
  • (Locked)
    Create visual calculations by using DAX

    8m 25s
• 8. Enhance Reports for Usability and Storytelling 8. Enhance Reports for Usability and Storytelling

  • (Locked)
    Learning objectives

    54s
  • (Locked)
    Configure bookmarks

    6m 15s
  • (Locked)
    Create custom tooltips

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

    4m 23s
  • (Locked)
    Configure navigation for a report

    5m 12s
  • (Locked)
    Apply sorting to visuals

    2m 20s
  • (Locked)
    Configure sync slicers

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

    4m 18s
  • (Locked)
    Configure drill through navigation

    3m 16s
  • (Locked)
    Configure export settings

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

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

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

    5m 59s
  • (Locked)
    Configure automatic page refresh

    2m 27s
• 9. Identify Patterns and Trends 9. Identify Patterns and Trends

  • (Locked)
    Learning objectives

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

    1m 47s
  • Use grouping, binning, and clustering

    6m 52s
  • (Locked)
    Use AI visuals

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

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

    2m 28s
• 10. Create and Manage Workspaces and Assets 10. Create and Manage Workspaces and Assets

  • (Locked)
    Module introduction: Manage and secure Power BI

    46s
  • (Locked)
    Learning objectives

    41s
  • (Locked)
    Create and configure a workspace

    3m 41s
  • (Locked)
    Configure and update a workspace app

    5m 20s
  • (Locked)
    Publish, import, or update items in a workspace

    5m 35s
  • (Locked)
    Create dashboards

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

    1m 53s
  • (Locked)
    Configure subscriptions and data alerts

    7m 48s
  • (Locked)
    Promote or certify Power BI content

    2m 43s
  • (Locked)
    Identify when a gateway is required

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

    2m 59s
• 11. Secure and Govern Power BI Items 11. Secure and Govern Power BI Items

  • (Locked)
    Learning objectives

    31s
  • (Locked)
    Assign workspace roles

    2m 30s
  • (Locked)
    Configure item-level access

    1m 26s
  • (Locked)
    Configure access to semantic models

    2m 39s
  • (Locked)
    Implement row-level security roles

    6m 58s
  • (Locked)
    Configure row-level security group membership

    2m 56s
  • (Locked)
    Apply sensitivity labels

    1m 57s
• Conclusion Conclusion

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

    2m 12s