This exam focuses on those working as a Power BI data analyst with business stakeholders for identifying business requirements. They collaborate with enterprise data analysts and data engineers to identify and acquire data. Individuals for this exam must know how to use Power BI for:
Candidates for this exam should be proficient at using Power Query and writing expressions by using Data Analysis Expressions (DAX). They should know how to assess data quality. Plus, you understand data security, including row-level security and data sensitivity.
Exam Details of Microsoft PL-300
- Exam Code: PL-300
- Exam Name: Microsoft Power BI Data Analyst
- Exam Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Chinese (Traditional), Italian, Indonesian (Indonesia)
- Exam Questions: 40-60 Questions
- Passing Score: 700 or greater (On a scale 1 - 1000)
Microsoft PL-300 Exam Topics
PL-300 exam covers the following topics:
Domain 1: Preparing the data (25–30%)
Getting data from data sources
- Identifying and connecting to a data source
- Changing data source settings, including credentials, privacy levels, and data source locations
- Selecting a shared semantic model, or creating a local data model
- Choosing between DirectQuery, Import, and Dual mode
- Changing the value in a parameter
Cleaning the data
- Evaluating data, including data statistics and column properties
- Resolving inconsistencies, unexpected or null values, and data quality issues
- Resolving data import errors
Transforming and loading the data
- Selecting appropriate column data types
- Creating and transforming columns
- Transforming a query
- Designing a star schema that contains facts and dimensions
- Identifying when to use reference or duplicate queries and the resulting impact
- Merging and appending queries
- Identifying and creating appropriate keys for relationships
- Configuring data loading for queries
Domain 2: Understand how Model the data (25–30%)
Designing and implementing a data model
- Configuring table and column properties
- Implementing role-playing dimensions
- Defining a relationship's cardinality and cross-filter direction
- Creating a common date table
- Implementing row-level security roles
Creating model calculations by using DAX
- Creating single aggregation measures
- Using CALCULATE to manipulate filters
- Implementing time intelligence measures
- Identifying implicit measures and replace with explicit measures
- Using basic statistical functions
- Creating semi-additive measures
- Creating a measure by using quick measures
- Creating calculated tables
Optimizing model performance
- Improving performance by identifying and removing unnecessary rows and columns
- Identifying poorly performing measures, relationships, and visuals by using Performance Analyzer
- Improving performance by choosing optimal data types
- Improving performance by summarizing data
Domain 3: Understand how to Visualize and analyze the data (25–30%)
Creating reports
- Identifying and implementing appropriate visualizations
- Format and configure visualizations
- Using a custom visual
- Applying and customizing a theme
- Configure conditional formatting
- Apply slicing and filtering
- Configuring the report page
- Using the Analyze in Excel feature
- Choosing when to use a paginated report
Enhancing reports for usability and storytelling
- Configure bookmarks
- Creating custom tooltips
- Edit and configure interactions between visuals
- Configure navigation for a report
- Apply sorting
- Configuring 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
- Designing reports for mobile devices
Identifying patterns and trends
- Use the Analyze feature in Power BI
- Using grouping, binning, and clustering
- Incorporate the Q&A feature in a report
- Use AI visuals
- Using reference lines, error bars, and forecasting
- Detect outliers and anomalies
- Creating and sharing scorecards and metrics
Domain 4: Deploying and maintaining items (15–20%)
Creating and managing workspaces and items
- Creating and configuring a workspace
- Assign workspace roles
- Configure and update a workspace app
- Publish, import, or update items in a workspace
- Creating dashboards
- Choose a distribution method
- Applying sensitivity labels to workspace content
- Configure subscriptions and data alerts
- Promote or certify Power BI content
- Managing global options for files
Managing semantic models
- Identifying when a gateway is required
- Configure a semantic model scheduled refresh
- Configure row-level security group membership
- Providing access to semantic models
