Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Sign inStart free
MICROSOFT

Microsoft Certified:Power BI Data Analyst Associate

PL-300Power BI Data Analyst Associate

The Microsoft Certified: Power BI Data Analyst Associate certification validates your ability to model, visualize, and analyze data with Power BI. It is designed for data analysts who work closely with business stakeholders to deliver actionable insights. Earning this certification demonstrates proficiency in using Power BI to enable self-service analytics and provide meaningful business value.

Practice Free Questions

408 practice questions · Updated 2026-04-20

4Domains
11Objectives
104Concepts
408Questions

PL-300 Curriculum

Every domain, objective, and concept the PL-300 exam measures.

Get or connect to data

8 concepts · 31 questions
  1. DataSourceIdentification
  2. DataSourceConnection
  3. DataSourceSettingsModification
  4. DirectLakeUsage
  5. DirectQueryUsage
  6. ImportModeUsage
  7. ParameterCreation
  8. ParameterModification

Profile and clean the data

7 concepts · 35 questions
  1. Data Statistics Evaluation
  2. Column Properties Assessment
  3. Identify Data Inconsistencies
  4. Handle Unexpected Values
  5. Manage Null Values
  6. Data Quality Issue Resolution
  7. Data Import Error Resolution

Transform and load the data

16 concepts · 51 questions
  1. Select Column Data Types
  2. Create Columns
  3. Transform Columns
  4. Group Rows
  5. Aggregate Rows
  6. Pivot Data
  7. Unpivot Data
  8. Transpose Data
  9. Convert Semi-Structured Data
  10. Create Fact Tables
  11. Create Dimension Tables
  12. Reference vs Duplicate Queries
  13. Merge Queries
  14. Append Queries
  15. Create Keys for Relationships
  16. Configure Data Loading

Design and implement a data model

8 concepts · 31 questions
  1. Table Properties Configuration
  2. Column Properties Configuration
  3. Role-Playing Dimensions Implementation
  4. Relationship Cardinality Definition
  5. Cross-Filter Direction Definition
  6. Common Date Table Creation
  7. Calculated Columns Use Cases
  8. Calculated Tables Use Cases

Create model calculations by using DAX

8 concepts · 25 questions
  1. Single Aggregation Measures
  2. CALCULATE Function
  3. Time Intelligence Measures
  4. Basic Statistical Functions
  5. Semi-Additive Measures
  6. Quick Measures
  7. Calculated Tables and Columns
  8. Calculation Groups

Optimize model performance

5 concepts · 35 questions
  1. Identify Unnecessary Rows
  2. Identify Unnecessary Columns
  3. Use Performance Analyzer
  4. Analyze DAX Query Performance
  5. Reduce Data Granularity

Create reports

11 concepts · 47 questions
  1. Visual Selection
  2. Visual Formatting
  3. Narrative Visual Creation
  4. Theme Application
  5. Conditional Formatting
  6. Slicing and Filtering
  7. Copilot Report Page Creation
  8. Copilot Content Suggestion
  9. Report Page Configuration
  10. Paginated Report Usage
  11. Visual Calculations with DAX

Enhance reports for usability and storytelling

13 concepts · 42 questions
  1. Bookmark Configuration
  2. Custom Tooltip Creation
  3. Visual Interaction Editing
  4. Report Navigation Configuration
  5. Visual Sorting Application
  6. Sync Slicer Configuration
  7. Visual Grouping and Layering
  8. Drillthrough Navigation Setup
  9. Export Settings Configuration
  10. Mobile Report Design
  11. Report Personalization Enablement
  12. Accessibility Design and Configuration
  13. Automatic Page Refresh Configuration

Create and manage workspaces and assets

11 concepts · 38 questions
  1. WorkspaceCreation
  2. WorkspaceConfiguration
  3. AppConfiguration
  4. ItemPublishing
  5. DashboardCreation
  6. DistributionMethodSelection
  7. SubscriptionConfiguration
  8. DataAlertConfiguration
  9. ContentPromotion
  10. GatewayIdentification
  11. ScheduledRefreshConfiguration

Secure and govern Power BI items

6 concepts · 24 questions
  1. Workspace Role Assignment
  2. Item-Level Access Configuration
  3. Semantic Model Access Configuration
  4. Row-Level Security Implementation
  5. Row-Level Security Group Membership
  6. Sensitivity Label Application
Ready to practice?Test your knowledge with exam-style questions or take an intelligent quiz tailored to your level.
Practice Free Questions

Percentages reflect share of the current practice bank, not official exam weightings — no structured per-skill weight is published for PL-300, so none is invented.