A study guide for the PL-300: Microsoft Power BI Data Analyst Certification Exam
The below is a study guide for the PL-300: Microsoft Power BI Data Analyst certification exam, the exam to certify the recipient as a Microsoft Certified: Power BI Data Analyst Associate.
The study guide and outline are current as of February 2022.
This document provides a checklist recreation of the Microsoft's current Skills Measured outline found here. It is structured as follows:
- Sub-section
Headers and sub-headers always link to the official Microsoft Learn path documentation (where it exists), while sub-sections link mostly to other Microsoft Documentation. In instances where MS Documentation is lacking, outside resources are used or the MS Learn page specific to the topic is linked. Additional resources are then added at the bottom of each section linking out to MS Learn labs and third-party resources.
The document also contains references to further reading and resources, including tutorial videos, paid training (not ours), and the Dashboard in a Day project offered by Microsoft (free).
Lastly, the repo contains additional pages with more granular information on specific topics. These largely represent gaps the creator found in his own knowledge following one go-through of the MS Learn material. Use these as supplement, but do not treat them as comprehensive for their specific topic.
Clone the repo. Then, begin with the Microsoft Learn track found here. It is the go-to source for all material covered by the exam. Use the outline's checkboxes to track progress and the links to return to sections in the future.
To check off the sub-sections and headers, add an x between the brackets like so [x]. Example:
- Incomplete
- Complete
We then recommend working with the supplemental material to solidify content.
NOTICE: Following the Microsoft Learn path is not enough. There is too much material to memorize in one go and content will not sink in without further practice and review. You will have to practice, and you will be revisiting content.
Unfortunately, Microsoft's Learn path and its outline are not a 1:1. This can manifest in several ways.
First, a sub-section in the outline may not have its own explicit page in the MS Learn path and may exist across several pages of content. E.g. identify and connect to a data source does not exist as a specific page in the MS Learn section for Prepare the Data, but rather as several pages tied to various data sources.
Second, content for certain sub-sections in the outline may not be found within the indicated MS Learn section. We have tried to note this where possible.
Lastly, a section titled Develop a data model exists in the Outline, but has no corollary in the MS Learn track. In this case, informative content has been provided to the best of our ability. Several gaps surely remain, however, so please feel free to contribute.
See this folder for additional documentation. Contained are further details about the exam, a thorough list of DAX functions with descriptions, and a list of M functions with descriptions and examples.
- Duration: 180 Minutes.
- Question Types: Multiple choice and multi-response questions.
- Number of Questions: 45-50 multiple choice questions in section 1; ~4-5 questions each in 2-3 case studies.
- Score to Pass: 700/1000.
- identify and connect to a data source
- change data source settings
- select a shared dataset or create a local dataset (See first bullet. Documentation contains various sections on connecting to different sets of data.)
- select a storage mode
- use Microsoft Dataverse
- change the value in a parameter
- connect to a data flow
- Lab: Prepare data in Power BI Desktop
- MS Documentation: Data sources in Power BI
- How To Change Data Source Of Existing Report In Power BI
- profile the data
- resolve inconsistencies, unexpected or null values, and data quality issues (errors, duplicates)
- identify and create appropriate keys for joins
- evaluate and transform column data types, also
- shape and transform tables (link provides first document in a series)
- combine queries: append, merge (series)
- apply user-friendly naming conventions to columns and queries (see bottom of article)
- configure data loading (Recommend reading entire track starting here)
- resolve data import errors
- 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
Unfortunately this section does not appear in the MS Learn track, though its items are addressed elsewhere. Links have nevertheless been provided below to cover the topics.
- create calculated tables
- create hierarchies
- create calculated columns
- implement row-level security roles
- use the Q&A feature
- create basic measures by using DAX
- use CALCULATE to manipulate filters
- implement Time Intelligence using DAX: List of functions, Helpful Guide
- replace implicit measures with explicit measures
- use basic statistical functions
- create semi-additive measures
- use quick measures
- remove unnecessary rows and columns
- identify poorly performing measures, relationships, and visuals
- reduce cardinality levels to improve performance
- 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
- 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
- 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
- use the Analyze feature in Power BI
- identify outliers
- choose between continuous and categorical axes
- use groupings, binnings, and clustering
- use AI visuals (this is its own section in the MS Learn track)
- use the Forecast feature
- create reference lines by using the Analytics pane
- 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
- 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
- Udemy Course
- Price: ~$20 (price may vary over time)
- Offering: A complete course of all PBI content.
- Official Practice Test (Current test exam is for the DA-100)
- Price: $99-109 (for 30 & 60 day availability, respectively)
- Offering: Practice test meant to mimic the exam format.
- Learn Data Insights
- Price: Free
- Offering: Questions w/ explanations & links to resources when answers are incorrect.
- Microsoft's Dashboard in a Day Project
- Price: Free
- Offering: Materials for constructing dashboards like a professional, including tutorials and sample data
- Guy In a Cube (YouTube)
- Curbal (YouTube)
- Magna Data Solutions
- Price: Free
- Offering: Exam tips video & questions
- Sky Point CSG
- Price: Free
- Offering: Video walkthrough of Microsoft's Dashboard in a Day project
- BI Elite Training DA-100 Exam Prep – Power BI Certification
- Price: $29USD
- Offering: Live Azure database, 30+ DA-100 Practice Exam Questions, Many hours of premium video tutorials from a Microsoft MVP – Free Trial? Yes. 7 day.