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