The PL-300 practice test trains you in Microsoft Power BI data analysis.
Why should I take the PL-300 exam?
The PL-300certification offers you the perfect opportunity to start a rewarding career in Microsoft Power BI as a Power BI data analyst,by allowing you to demonstrate your knowledge of Power Query and Data Analysis Expressions. On passingthe PL-300 exam, you earn the Microsoft Certified: Power BI Data Analyst Associate certification.
The PL-300 practice test includes two different modes: certification and practice mode. Certification mode allows you to assess your knowledge and discover your weak areas, with practice mode allowing you to focus on the areas that need development.
Questions: 175 Release Date: 04/2022 (Last Update: 11/2023) Job Role: Business User, Data Analyst 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.
Practice tests are informal exams that simulate the actual test and aim to prepare you better for what to expect on the real exam. MeasureUp practice testscontain around 150 questions covering the exam objective domains. In aMeasureUp practice test there are two specific test-taking modes to prepare students for their certification: Certification Mode and Practice Mode.
Practice Modeenables users to highly customize the testing environment. They are able to select how many questions they want to include in their assessment, the maximum time to finish the test, theoption to randomize the question order, and select how and which questions will be shown in the test.
Certification Modesimulates the actual testing environment that users will encounter when taking a certification exam. Therefore, they are timed and do not allow users to request the answers and explanations to questions until after the test.
How does it work?
Watch our video to see exactly how MeasureUp’s practice tests work.
Why should you trust MeasureUp over free Learning material?
MeasureUp
Free learning material
A greater number of questions, so more opportunities to learn.
A small proportion of questions to introduce the exam.
Detailed explanations with online references of correct and incorrect answers.
Brief or no explanations of both correct and incorrect answer options.
A total of fourteen different question types.
Limited types of questions out of all the ones you'll find on the exam.
Customize the test based on your needs. Certification & Practice Mode.
Just one type of assessment, without customization options and without a time countdown.
Will studying with a MeasureUp practice test improve my chances of passing at the first attempt?
Yes. MeasureUp's practice tests have been specifically designed to help you both save time and pass at the first attempt. The test is fully customizable, allowing you to discover and focus on your weak areas. This makes the learning process quicker and smoother. Also, as the style, objectives, question type, and difficulty are the same as those found on the official exam, you can be confident that when you pass the practice test three times in Certification Mode, you are exam-ready.
What can I expect to earn if I pass the PL-300 exam?
On passing the PL-300, and obtaining a job as mid-level business analyst, you can expect to earn a salary in the United States of approximately $100,000.
Source: Nigel Franks International.
Continue growing with MeasureUp’s learning material. Explore the Business applications learning path.
MeasureUp’s PL-300 practice test is the most realistic simulation of the certification exam on the market, giving you the perfect opportunity to pass the official exam on the first go. With our Test Pass Guarantee, you can be assured of success as we offer all of your money back if you do not pass. The PL-300 practice test has been created by leading experts in the field of Microsoft Power BI.
Why should you trust PL-300 Practice Test from MeasureUp over free learning material?
The MeasureUp PL-300 practice test has several benefits over free learning material, including:
A higher number of questions, so more opportunities to learn.
Detailed explanations with online references of correct and incorrect answers.
A total of fourteen different question types, replicating the style and feel of the real exam.
Customizable based on your needs. Certification & Practice Modes.
Test Pass Guarantee.
Written, reviewed, and edited by experts.
PL-300 CERTIFICATION
Will the questions be the same as the actual exam?
No. Although the questions will replicate those of the official exam in terms of style, content criteria, level of difficulty, for reasons of copyright they will not be exactly identical. This will allow you to fully understand the content you are studying so that, no matter what the specific focus of the questions is, you can be confident you are covering the same material and that you will have no problem in passing the exam.
How long does it take to prepare for PL-300?
The time required to pass the certification depends on your starting point in terms of your familiarity with Microsoft Power BI. However, in the case of the PL-300 certification exam, it takes on average 40-50 hours. The MeasureUp PL-300 practice test comes in several different access options: 30-day, 60-day, 1-year, and option to download the test.
PL-300 CERTIFICATION EXAM
Can I purchase a PL-300 exam voucher from MeasureUp?
No, MeasureUp does not provide exam vouchers for the certification exam.
How to pass the PL-300 exam?
Read through the PL-300 exam domains carefully.
Create a study plan for your preparation.
Enroll for the MeasureUp practice tests. Our practice tests reflect the actual exam in terms of style, format, skill sets, question structure, and level of difficulty, and can be taken in one of two different formats: practice mode and certification mode.
Practice, practice, practice! After looking at all the questions available in the test, checking which answers you got right, reviewing the explanations regarding all the different answer options, and consulting the carefully chosen references, it is now time to use the test’s Certification Mode. This is the closest experience you’ll get to the real exam. And when you pass the Certification Mode twice consecutively with a score of 90% or more, this means you are… Exam ready!
How many questions does PL-300 have?
The PL-300 exam contains between 50-60 questions.
Is PL-300 hard?
As with all exams, the difficulty depends fundamentally on your initial knowledge of the subject material and also the amount of time you dedicate to studying. However, as an associate-level exam, the PL-300 is neither the easiest nor the most difficult of Microsoft exams, and to pass you will need to know how to build and deploy real-world solutions.
Is the PL-300 certification worth it?
The PL-300 is worth passing if you are interested in developing your career as a Microsoft Power BI data analyst. It will allow you to demonstrate to employers your ability to provide meaningful business value with data visualizations, working in close collaboration with key stakeholders to identify business requirements. You will also be able to prove your ability to build and deploy real-world solution
https://www.measureup.com/microsoft-practice-test-pl-300-microsoft-power-bi-data-analyst.html8264Microsoft Practice Test PL-300: Microsoft Power BI Data Analyst<b>Questions:</b> 175 <br><b>Release Date:</b> 04/2022 (Last Update: 11/2023) <br><b>Job Role:</b> Business User, Data Analyst <br><b>Language:</b> English <br><br><p><span style="color: #000000;">The PL-300 practice test contains 175 questions and covers the following objectives: </span></p>
<h4 aria-level="2"><span style="color: #000000;"><strong>Prepare the data – 39 questions</strong> </span></h4>
<p aria-level="2"><strong><span style="color: #0780c2;">Get data from data sources </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Identify and connect to a data source </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Change data source settings, including credentials, privacy levels, and data source locations </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Select a shared dataset, or create a local dataset </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Choose between DirectQuery, Import, and Dual mode </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Change the value in a parameter </span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Transform and load the data </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Select appropriate column data types </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Create and transform columns </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Transform a query </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Design a star schema that contains facts and dimensions </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Identify when to use reference or duplicate queries and the resulting impact </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Merge and append queries </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Identify and create appropriate keys for relationships </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Configure data loading for queries </span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Clean the data </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Evaluate data, including data statistics and column properties </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Resolve inconsistencies, unexpected or null values, and data quality issues </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Resolve data import errors </span></li>
</ul>
<p aria-level="2"> </p>
<h4 aria-level="2"><span style="color: #000000;"><strong>Model the data – 50 questions</strong> </span></h4>
<p aria-level="2"><strong><span style="color: #0780c2;">Design and implement a data model </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Configure table and column properties </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Implement role-playing dimensions </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Define a relationship's cardinality and cross-filter direction </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Create a common date table </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span style="color: #000000;">Implement row-level security roles </span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Create model calculations by using DAX </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Create single aggregation measures </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Use CALCULATE to manipulate filters </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Implement time intelligence measures </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Identify implicit measures and replace with explicit measures </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Use basic statistical functions </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Create semi-additive measures </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Create a measure by using quick measures </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Create calculated tables </span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Optimize model performance </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Improve performance by identifying and removing unnecessary rows and columns </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Identify poorly performing measures, relationships, and visuals by using Performance Analyzer </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Improve performance by choosing optimal data types </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Improve performance by summarizing data </span></li>
</ul>
<p aria-level="2"> </p>
<h4 aria-level="2"><span style="color: #000000;"><strong>Visualize and analyze the data – 53 questions</strong> </span></h4>
<p aria-level="2"><strong><span style="color: #0780c2;">Create reports </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Identify and implement appropriate visualizations </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Format and configure visualizations </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Use a custom visual </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Apply and customize a theme </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure conditional formatting </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Apply slicing and filtering </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure the report page </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Use the Analyze in Excel feature </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Choose when to use a paginated report </span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Enhance reports for usability and storytelling </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Configure bookmarks </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Create custom tooltips </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Edit and configure interactions between visuals </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure navigation for a report </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Apply sorting </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure sync slicers </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Group and layer visuals by using the Selection pane </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Drill down into data using interactive visuals </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure export of report content, and perform an export </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Design reports for mobile devices</span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Identify patterns and trends </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Use the Analyze feature in Power BI </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Use grouping, binning, and clustering </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Use AI visuals </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Use reference lines, error bars, and forecasting </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Detect outliers and anomalies </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Create and share scorecards and metrics </span></li>
<li><span style="color: #000000;">Incorporate the Q&A feature in a report </span></li>
</ul>
<p aria-level="2"> </p>
<h4 aria-level="2"><span style="color: #000000;"><strong>Deploy and maintain assets – 33 questions</strong> </span></h4>
<p aria-level="2"><strong><span style="color: #0780c2;">Create and manage workspaces and assets </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span style="color: #000000;">Create and configure a workspace </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Assign workspace roles </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Configure and update a workspace app </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Publish, import, or update assets in a workspace </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Create dashboards </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Choose a distribution method </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Apply sensitivity labels to workspace content </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure subscriptions and data alerts </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Promote or certify Power BI content </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Manage global options for files </span></li>
</ul>
<p aria-level="2"> </p>
<p aria-level="2"><strong><span style="color: #0780c2;">Manage datasets </span></strong></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">Identify when a gateway is required </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;">Configure a dataset scheduled refresh </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Configure row-level security group membership </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="117" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span style="color: #000000;">Provide access to datasets </span></li>
</ul>
<p><span style="color: #000000;" data-ccp-props="{"201341983":0,"335551550":6,"335551620":6,"335559739":0,"335559740":276}"> </span></p>
<p><span style="color: #000000;"><strong>Notes:</strong> </span></p>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="99" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":360,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span style="color: #000000;">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. </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="99" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":360,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span style="color: #000000;" data-contrast="none">Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.</span></li>
</ul>
<p> </p>
<p> </p> <u><a target="_blank" href="https://docs.measureup.com/knowledgebase/system-requirements/">System Requirements</a></u>https://www.measureup.com/media/catalog/product/m/i/microsoft_pl-300_pt_1.png69.3instock9969.33029.7Microsoft34.66666666666673https://www.measureup.com/media/catalog/product/m/i/microsoft_pl-300_pt_1.png8263/measureup/measureup/Microsoft/measureup/Microsoft/Microsoft Technical/measureup/Microsoft/Microsoft Technical/Microsoft Practice Tests2022-04-19T07:06:03+0000