Microsoft Power BI Data Analyst PL-300 | PL300 MeasureUP Proefexamen

MeasureUp Microsoft Power BI Data Analyst PL-300 Proefexamen

De PL-300 oefentest traint je in Microsoft Power BI data-analyse.

Waarom zou ik het PL-300 examen doen?

De PL-300 certificering biedt u de perfecte gelegenheid om een lonende carrière in Microsoft Power BI te starten als Power BI data analist, doordat u uw kennis van Power Query en Data Analysis Expressions kunt aantonen. Als je slaagt voor het PL-300 examen, verdien je de Microsoft Certified: Power BI Data Analyst Associate certificering.

De PL-300 oefentest bevat twee verschillende modi: certificering en oefenmodus. In de certificeringsmodus kunt u uw kennis beoordelen en uw zwakke punten ontdekken, terwijl u zich in de oefenmodus kunt concentreren op de gebieden die ontwikkeling behoeven.

Language: English

The PL-300 practice test contains 175 questions and covers the following objectives: 

Prepare the data – 39 questions 

Get data from data sources 

• Identify and connect to a data source 
• Change data source settings, including credentials, privacy levels, and data source locations 
• Select a shared dataset, or create a local dataset 
• Choose between DirectQuery, Import, and Dual mode 
• Change the value in a parameter 

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 

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 

Model the data – 50 questions 

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 
• Implement row-level security roles 

Create model calculations by using DAX 

• Create single aggregation measures 
• Use CALCULATE to manipulate filters 
• Implement time intelligence measures 
• Identify implicit measures and replace with explicit measures 
• Use basic statistical functions 
• Create semi-additive measures 
• Create a measure by using quick measures 
• Create calculated tables 

Optimize model performance 

• Improve performance by identifying and removing unnecessary rows and columns 
• Identify poorly performing measures, relationships, and visuals by using Performance Analyzer 
• Improve performance by choosing optimal data types 
• Improve performance by summarizing data 

Visualize and analyze the data – 53 questions 

Create reports 

• Identify and implement appropriate visualizations 
• 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 

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

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 
• Create and share scorecards and metrics 
• Incorporate the Q&A feature in a report 

Deploy and maintain assets – 33 questions 

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 

• Identify when a gateway is required 
• Configure a dataset scheduled refresh 
• Configure row-level security group membership 
• Provide access to datasets 

 Notes: 

• The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam. 
• Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.