Exam PL-300:
Candidates for this exam deliver actionable insights by working with available data and applying domain expertise. They provide meaningful business value through easy-to-comprehend data visualizations, enable others to perform self-service analytics and deploy and configure solutions for consumption.
Skills measured as of January 31, 2023
- Prepare the data (25–30%)
- Model the data (25–30%)
- Visualize and analyze the data (25–30%)
- Deploy and maintain assets (15–20%)
Pre-requisite
Microsoft has not formally stated any prerequisites, but the following knowledge would help you pass the exam: Using Power Query and writing expressions by using DAX. Understanding of topics in data analysis and visualization, also know content Excel Expert
-
Get data from data sources
-
Clean the data
-
Transform and load the data
- 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
-
Design and implement a data model
-
Create model calculations by using DAX
-
Optimize model performance
-
Create reports
-
Enhance reports for usability and storytelling
- 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
- Incorporate the Q&A feature in a report
-
Identify patterns and trends
-
Create and manage workspaces and assets
- Create and configure a workspace
- Assign workspace roles
- Configure and update a workspace app
- Publish, import, or update assets 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
-
Manage datasets
