We're so confident of our products that we provide no hassle product exchange.
Passing Score, Duration & Questions For Microsoft PL-300 Exam
The passing score: 700
Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Chinese (Traditional), Italian
Time Duration: 180 minutes
Number of Questions: 40-60 questions
Skills measured
- Visualize and analyze the data (25-30%)
- Model the data (30-35%)
- Download the study guide in the preceding “Tip” box for more details about the skills measured on this exam.
- Prepare the data (15-20%)
- Deploy and maintain assets (20-25%)
Microsoft PL-300 Exam Syllabus Topics:
| Topic | Details |
|---|---|
Prepare the Data (15-20%) | |
| Get data from different data sources | - identify and connect to a data source - change data source settings - select a shared dataset or create a local dataset - select a storage mode - use Microsoft Dataverse - change the value in a parameter - connect to a data flow |
| Clean, transform, and load the data | - profile the data - resolve inconsistencies, unexpected or null values, and data quality issues - identify and create appropriate keys for joins - evaluate and transform column data types - shape and transform tables - combine queries - apply user-friendly naming conventions to columns and queries - configure data loading - resolve data import errors |
Model the Data (30-35%) | |
| Design a data model | - define the tables - configure table and column properties - design and implement role-playing dimensions - define a relationship's cardinality and cross-filter direction - design a data model that uses a star schema - create a common date table |
| Develop a data model | - create calculated tables - create hierarchies - create calculated columns - implement row-level security roles - use the Q&A feature |
| Create model calculations by using DAX | - create basic measures by using DAX - use CALCULATE to manipulate filters - implement Time Intelligence using DAX - replace implicit measures with explicit measures - use basic statistical functions - create semi-additive measures - use quick measures |
| Optimize model performance | - remove unnecessary rows and columns - identify poorly performing measures, relationships, and visuals - reduce cardinality levels to improve performance |
Visualize and Analyze the Data (25-30%) | |
| Create reports | - add visualization items to reports - choose an appropriate visualization type - 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 |
| Create dashboards | - manage tiles on a dashboard - configure mobile view - use the Q&A feature - add a Quick Insights result to a dashboard - apply a dashboard theme - pin a live report page to a dashboard |
| 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 - drilldown into data using interactive visuals - export report data - design reports for mobile devices |
| Identify patterns and trends | - use the Analyze feature in Power BI - identify outliers - choose between continuous and categorical axes - use groupings, binnings, and clustering - use AI visuals - use the Forecast feature - create reference lines by using the Analytics pane |
Deploy and Maintain Assets (20-25%) | |
| Manage files and datasets | - identify when a gateway is required - configure a dataset scheduled refresh - configure row-level security group membership - provide access to datasets - manage global options for files |
| Manage workspaces | - create and configure a workspace - assign workspace roles - configure and update a workspace app - publish, import, or update assets in a workspace - apply sensitivity labels to workspace content - configure subscriptions and data alerts - promote or certify Power BI content |
Microsoft PL-300 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Microsoft Power BI Data Analyst |
| Exam Number: | PL-300 |
| Real Exam Qty: | 40-60 |
| Certificate Validity Period: | 12 months |
| Related Certifications: | Microsoft Certified: Data Analyst Associate Microsoft Certified: Power Platform Associate |
| Exam Price: | USD 165 |
| Passing Score: | 700 (out of 1000) |
| Exam Duration: | 180 minutes |
| Available Languages: | English, Japanese, Chinese (Simplified), Chinese (Traditional), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Italian, Indonesian |
| Exam Format: | Multiple choice (single/multiple response), Drag and drop, Performance-based, Case studies, Simulation |
| Recommended Training: | Microsoft Official Course: PL-300T00 Microsoft Learn - PL-300 Learning Path |
| Exam Registration: | Microsoft Learn - Schedule Exam Pearson VUE Registration |
| Sample Questions: | Microsoft PL-300 Sample Questions |
| Exam Way: | Online proctored or onsite at Pearson VUE test centers |
| Pre Condition: | No mandatory prerequisites; recommended experience: proficiency in Power Query, DAX, data profiling, and understanding of data security concepts |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300 |
For more info visit:
Microsoft Power BI Data Analyst Certification Exam Reference
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/pl-300
By Quinn
