Practice Exams | Microsoft PL-300: Power BI Data Analyst

Be prepared for the Microsoft PL-300: Power BI Data Analyst certification

In order to set realistic expectations, please note: These questions are NOT official questions that you will find on the official exam. These questions DO cover all the material outlined in the knowledge sections below. Many of the questions are based on fictitious scenarios which have questions posed within them.

The official knowledge requirements for the exam are reviewed routinely to ensure that the content has the latest requirements incorporated in the practice questions. Updates to content are often made without prior notification and are subject to change at any time.

Each question has a detailed explanation and links to reference materials to support the answers which ensures accuracy of the problem solutions.

The questions will be shuffled each time you repeat the tests so you will need to know why an answer is correct, not just that the correct answer was item "B"  last time you went through the test.

NOTE: This course should not be your only study material to prepare for the official exam. These practice tests are meant to supplement topic study material.

Should you encounter content which needs attention, please send a message with a screenshot of the content that needs attention and I will be reviewed promptly. Providing the test and question number do not identify questions as the questions rotate each time they are run. The question numbers are different for everyone.

As a candidate for this exam, you should deliver actionable insights by working with available data and applying domain expertise. You should:

• Provide meaningful business value through easy-to-comprehend data visualizations.

• Enable others to perform self-service analytics.

As a Power BI data analyst, you work closely with business stakeholders to identify business requirements. You collaborate with analytics engineers and data engineers to identify and acquire data. You use Power BI to:

• Prepare the data

• Model the data

• Visualize and analyze data

• Manage and secure Power BI

You should be proficient at using Power Query and Data Analysis Expressions (DAX).

Skills at a glance

• Prepare the data (25–30%)

• Model the data (25–30%)

• Visualize and analyze the data (25–30%)

• Manage and secure Power BI (15–20%)

Prepare the data (25–30%)

Get or connect to data

• Identify and connect to data sources or a shared semantic model

• Change data source settings, including credentials and privacy levels

• Choose between DirectQuery and Import

• Create and modify parameters

Profile and clean the data

• Evaluate data, including data statistics and column properties

• Resolve inconsistencies, unexpected or null values, and data quality issues

• Resolve data import errors

Transform and load the data

• Select appropriate column data types

• Create and transform columns

• Group and aggregate rows

• Pivot, unpivot, and transpose data

• Convert semi-structured data to a table

• Create fact tables and dimension tables

• 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

Model the data (25–30%)

Design and implement a data model

• Configure table and column properties

• Implement role-playing dimensions

• Define a relationship's cardinality and cross-filter direction

• Create a common date table

• Identify use cases for calculated columns and calculated tables

Create model calculations by using DAX

• Create single aggregation measures

• Use the CALCULATE function

• Implement time intelligence measures

• Use basic statistical functions

• Create semi-additive measures

• Create a measure by using quick measures

• Create calculated tables or columns

• Create calculation groups

Optimize model performance

• Improve performance by identifying and removing unnecessary rows and columns

• Identify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query view

• Improve performance by reducing granularity

Visualize and analyze the data (25–30%)

Create reports

• Select an appropriate visual

• Format and configure visuals

• Apply and customize a theme

• Apply conditional formatting

• Apply slicing and filtering

• Configure the report page

• Choose when to use a paginated report

• Create visual calculations by using DAX

Enhance reports for usability and storytelling

• Configure bookmarks

• Create custom tooltips

• Edit and configure interactions between visuals

• Configure navigation for a report

• Apply sorting to visuals

• Configure sync slicers

• Group and layer visuals by using the Selection pane

• Configure drill through navigation

• Configure export settings

• Design reports for mobile devices

• Enable personalized visuals in a report

• Design and configure Power BI reports for accessibility

• Configure automatic page refresh

Identify patterns and trends

• Use the Analyze feature in Power BI

• Use grouping, binning, and clustering

• Use AI visuals

• Use reference lines, error bars, and forecasting

• Detect outliers and anomalies

Manage and secure Power BI (15–20%)

Create and manage workspaces and assets

• Create and configure a workspace

• Configure and update a workspace app

• Publish, import, or update items in a workspace

• Create dashboards

• Choose a distribution method

• Configure subscriptions and data alerts

• Promote or certify Power BI content

• Identify when a gateway is required

• Configure a semantic model scheduled refresh

Secure and govern Power BI items

• Assign workspace roles

• Configure item-level access

• Configure access to semantic models

• Implement row-level security roles

• Configure row-level security group membership

• Apply sensitivity labels