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

Prepare for the PL-300 exam with this course covering data preparation, modeling, visualization, and deployment. Learn how to extract insights through effective data management and analysis.

Introduction

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

Module 1: Prepare the Data

• Module introduction

Lesson 1: Get Data from Data Sources

• Learning objectives
• Identify and connect to a data source
• Change data source settings, including credentials, privacy levels, and data source locations
• Select a shared semantic model, or create a local semantic model
• Choose between DirectQuery, Import, and Dual mode
• Change the value in a parameter

Lesson 2: Clean the Data

• Learning objectives
• Evaluate data, including data statistics and column properties
• Resolve inconsistencies, unexpected or null values, and data quality issues
• Resolve data import errors

Lesson 3: Transform and Load the Data

• Learning objectives
• Select appropriate column data types
• Create and transform columns
• Transform a query
• Design a star schema that contains facts and dimensions
• Identify when to use reference or duplicate queries and the resulting impact
• Merge and append queries
• Identify and create appropriate keys for relationships
• Configure data loading for queries

Module 2: Model the Data

• Module introduction

Lesson 4: Design and Implement a Data Model

• Learning objectives
• Configure table and column properties
• Implement role-playing dimensions
• Define a relationship's cardinality and cross-filter direction
• Create a common date table
• Implement row-level security roles

Lesson 5: Create Model Calculations by Using DAX

• Learning objectives
• Create single aggregation measures
• Use CALCULATE to manipulate filters
• Implement time intelligence measures
• Identify implicit measures and replace with explicit measures
• Use basic statistical functions
• Create semi-additive measures
• Create a measure by using quick measures
• Create calculated tables

Lesson 6: Optimize Model Performance

• Learning objectives
• Improve performance by identifying and removing unnecessary rows and columns
• Identify poorly performing measures, relationships, and visuals by using Performance Analyzer
• Improve performance by choosing optimal data types
• Improve performance by summarizing data

Module 3: Visualize and Analyze the Data

• Module introduction

Lesson 7: Create Reports

• Learning objectives
• Identify and implement appropriate visualizations
• Format and configure visualizations
• Use a custom visual
• Apply and customize a theme
• Configure conditional formatting
• Apply slicing and filtering
• Configure the report page
• Use the Analyze in Excel feature
• Choose when to use a paginated report

Lesson 8: Enhance Reports for Usability and Storytelling

• Learning objectives
• Configure bookmarks
• Create custom tooltips
• Edit and configure interactions between visuals
• Configure navigation for a report
• Apply sorting
• Configure sync slicers
• Group and layer visuals by using the Selection pane
• Drill down into data using interactive visuals
• Configure export of report content and perform an export
• Design reports for mobile devices
• Enable personalized visuals in a report
• Design and configure Power BI reports for accessibility

Lesson 9: Identify Patterns and Trends

• Learning objectives
• Use the Analyze feature in Power BI
• Use grouping, binning, and clustering
• Incorporate the Q&A feature in a report
• Use AI visuals
• Use reference lines, error bars, and forecasting
• Detect outliers and anomalies
• Create and share scorecards and metrics

Module 4: Deploy and Maintain Assets

• Module introduction

Lesson 10: Create and Manage Workspaces and Items

• Learning objectives
• Create and configure a workspace
• Assign workspace roles
• Configure and update a workspace app
• Publish, import, or update items in a workspace
• Create dashboards
• Choose a distribution method
• Apply sensitivity labels to workspace content
• Configure subscriptions and data alerts
• Promote or certify Power BI content
• Manage global options for files

Lesson 11: Manage Semantic Models

• Learning objectives
• Identify when a gateway is required
• Configure a semantic model scheduled refresh
• Configure row-level security group membership
• Provide access to semantic models

Summary

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