How to Prepare for the DA-100 Exam?
Preparing for the DA-100 Analyzing Data with Microsoft Power BI Certificate exam? Don’t know where to start? This post is the DA-100 Certificate Study Guide (with links to each exam objective).
I have curated a list of articles from Microsoft documentation for each objective of the DA-100 exam. I hope this article will help you to achieve the Microsoft Certified Data Analyst Associate Certificate. Also, please share the post within your circles so it helps them to prepare for the exam.
Exam Voucher for DA-100 with 1 Retake
Get 40% OFF with the combo
DA-100 Analyzing Data with Microsoft Power BI
| Udemy | Analyzing Data with Microsoft Power BI |
| LinkedIn Learning (Free Trial) | Become a Data Analyst [Learning Path] |
| Pluralsight (Learning Path) | Microsoft Power BI for Analysts [Free Trial] |
Practice Tests for DA-100 Microsoft Power BI
| Whizlabs Exam Questions | Analyzing Data with Power BI Practice Test |
| Udemy Practice Test | Microsoft Power BI Practice Exam |
| Amazon e-book (PDF) | Analyzing Data with Power BI Exam |
Microsoft Power BI Projects
| Udacity (Nanodegree) | Data Analysis & Visualization with Power BI |
| Coursera Guided Project | Sales Analysis using Power BI |
| Datacamp (Interactive) | Introduction to Microsoft Power BI |
DA-100 Sample Practice Exam Questions
Looking for DA-100 Dumps? Read This!
Using DA-100 exam dumps can get you permanently banned from taking any future Microsoft certificate exam. Read the FAQ page for more information. However, I strongly suggest you validate your understanding with practice questions.
Check out all the other Power Platform certificate study guides
Full Disclosure: Some of the links in this post are affiliate links. I receive a commission when you purchase through them.
DA-100 Microsoft Power BI Exam Tips
- Lots of questions on use cases (15-16 questions out of 57)
- Exam very DAX intensive. Practice exercises a lot (around 17-19 questions)
- Lots of questions on power BI service, apps publishing & distribution
Other topics include:
-
- M query writing, data cleansing, and transformation
- Questions on concepts related to drilling through functionality, filtering, all kinds of joins, & cardinality.
Prepare the Data (20-25%)
Get Data from Different Data Sources
Identify and connect to a data source
Data sources in Power BI desktop
Connect to data in Power BI desktop
Change data source settings
Select a shared dataset or create a local dataset
Where your workbook file is saved makes a difference
Select a storage mode
Storing data in the Power BI file
Choose an appropriate query type
Query overview in Power BI Desktop
Identify query performance issues
Optimization guide for Power BI
Use Microsoft Dataverse
Use parameters
Specify parameters for the data source in Power BI
Use or create a PBIDS file
How to create a PBIDS connection file?
Use or create a data flow
Connect to a dataset using the XMLA endpoint
Dataset connectivity with the XMLA endpoint
Profile the Data
Identify data anomalies
Visualize anomalies using batch detection & Power BI
Examine data structures
Interrogate column properties
Column Profiling in Power BI Desktop
Interrogate data statistics
Worldwide demographics & statistics using Power Query & Power View
How to get descriptive statistics for multiple columns?
Clean, Transform, and Load the Data
Resolve inconsistencies, unexpected or null values, and data quality issues
Inconsistencies with date-type fields
Tips & tricks for creating relationships in Power BI Desktop
Relationships in Power BI Desktop when the data has null or blank values
How to Spot and Improve Data Quality in Power BI
Apply user-friendly value replacements
Replace Values and Column Data Types with Power BI
Identify and create appropriate keys for joins
Model relationships in Power BI Desktop
Evaluate and transform column data types
Evaluate & change column data types
Apply data shape transformations to table structures
Shape & combine data in Power BI Desktop
Combine queries
Apply user-friendly naming conventions to columns and queries
Data import best practices in Power BI
Leverage Advanced Editor to modify Power Query M code
Configure data loading
Resolve data import errors
Amazon link (affiliate)
Model the Data (25-30%)
Design a Data Model
Define the tables
Tables in Power BI reports and dashboards
Configure table and column properties
Adjust the column width of a table
Define quick measures
Use quick measures for common calculations
Flatten out a parent-child hierarchy
Video on flattening a parent-child hierarchy
Define role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Design the data model to meet performance requirements
Optimization guide for Power BI
Resolve many-to-many relationships
Many-to-many relationship guidance
Create a common date table
Common Date Filter for Multiple Tables
Define the appropriate level of data granularity
Develop a Data Model
Apply cross-filter direction and security filtering
Enable bidirectional cross-filtering in Power BI Desktop
Model relationships defined with a cross filter direction
Row-level security (RLS) with Power BI
Create calculated tables
Create calculated tables in Power BI Desktop
Create hierarchies
Create a hierarchy in Power BI
Create calculated columns
Create calculated columns in Power BI desktop
Implement row-level security roles
Restrict data access with RLS for Power BI Desktop
Implement object-level security
Object-Level Security (OLS) is now generally available
Set up the Q&A feature
Use Power BI Q&A to explore your data & create visuals
Q&A for Power BI business users
Create Measures by Using DAX
Use DAX to build complex measures
Create & use your own measures
DAX: Use variables to improve your formulas
Use CALCULATE to manipulate filters
DAX: Avoid using FILTER as a filter argument
Implement Time Intelligence using DAX
Time intelligence in Power BI desktop
Replace numeric columns with measures
Use basic statistical functions to enhance data
Create semi-additive measures
Semi additive measures in DAX for Power pivot
Optimize Model Performance
Remove unnecessary rows and columns
Delete records or rows if the blank field
Remove Columns from Tables in Power BI
Identify poorly performing measures, relationships, and visuals
Table relationship causes severe performance drop
Power BI Desktop Visuals slow load
Improve cardinality levels by changing data types
Optimize high cardinality columns in VertiPaq
Improve cardinality levels through summarization
Create and manage aggregations
Use Query Diagnostics
Visualize the Data (20-25%)
Create Reports
Add visualization items to reports
Add visuals to a Power BI report
Choose an appropriate visualization type
Visualization types in Power BI
Format and configure visualizations
Getting started with the formatting pane
Import a custom visual
Configure conditional formatting
Use conditional formatting in tables
Apply slicing and filtering
Add a filter to a report in Power BI
Add an R or Python visual
Create Power BI visuals by using Python
Create Power BI visuals using R
Configure the report page
Change the display of a report page
Design and configure for accessibility
Design Power BI reports for accessibility
Configure automatic page refresh
Automatic page refresh in Power BI
Create a paginated report
Create a paginated report for Power BI Report Server
Create a paginated report based on a Power BI shared dataset
Create Dashboards
Set mobile view
Optimize a dashboard for mobile phones – Power BI
Manage tiles on a dashboard
Edit or remove a dashboard tile
Configure data alerts
Set alerts on Power BI dashboards
Use the Q&A feature
Add a dashboard theme
Use dashboard themes in the Power BI service
Pin a live report page to a dashboard
Add a new dashboard tile is by pinning an entire report page
Enrich Reports for Usability
Configure bookmarks
Bookmarks in Power BI desktop to share insights & build stories
Create custom tooltips
Customize tooltips in Power BI desktop
Edit and configure interactions between visuals
Change how visuals interact in a Power BI report
Configure navigation for a report
Make navigation easier with Power BI buttons
Apply sorting
Sort by column in Power BI Desktop
Configure Sync Slicers
Sync & use slicers on other pages
Use the selection pane
Power BI: Explore the new selection pane feature
Use drill through and cross filter
Set up drill through in Power BI reports
Drilldown into data using interactive visuals
Drill mode in a visual in Power BI
Export report data
Export data from a visual in a report
Design reports for mobile devices
Optimize Power BI reports for the mobile app
Power BI Design for Mobile Device
Analyze the Data (10-15%)
Enhance Reports to Expose Insights
Apply conditional formatting
Use conditional formatting in tables
Apply slicers and filters
Perform top N analysis
When & How to Use TOPN in Power BI
Explore statistical summary
Use the Q&A visual
Add a Quick Insights result to a report
Create reference lines by using the Analytics pane
Use the Play Axis feature of a visualization
Personalize visuals
Let users personalize visuals in a report
Personalize visuals in a report
Perform Advanced Analysis
Identify outliers
Identify outliers with Power BI visuals
How to detect anomalies & outliers In your data
Conduct Time Series analysis
Use groupings and binnings
Use grouping and binning in Power BI desktop
Use the Key Influencers to explore dimensional variances
Find important factors with the Key influencers visual
Use the decomposition tree visual to break down a measure
Decomposition Tree visual to break down a measure
Apply AI Insights
Use AI insights in Power BI desktop
Deploy and Maintain Deliverables (10-15%)
Manage Datasets
Configure a dataset scheduled refresh
Configure row-level security group membership
Power BI Row-level Security Groups
Row-level security using AD groups
Providing access to datasets
Build permission for shared datasets
Configure incremental refresh settings
Incremental refresh in Power BI
Promote or certify Power BI datasets
Promote your dataset – Power BI
Identify downstream dataset dependencies
Configure large dataset format
Large datasets in Power BI Premium
Using Power BI with large datasets
Create and Manage Workspaces
Create and configure a workspace
Create the new workspaces in Power BI
Manage your workspace in Power BI & Microsoft 365
Recommend a development lifecycle strategy
Introducing Power BI deployment pipelines (Preview)
Video on the future of content lifecycle management in Power BI
Assign workspace roles
Configure and update a workspace app
Publish, import, or update assets in a workspace
Apply sensitivity labels to workspace content
How to apply sensitivity labels in Power BI?
Use deployment pipelines
Introduction to deployment pipelines
Get started with deployment pipelines
Configure subscriptions
Subscribe to a report or dashboard
Subscribe yourself to reports & dashboards
Promote or certify Power BI content
Promote your reports, dashboards, & apps
Endorsement – Promote & certify Power BI content
This brings us to the end of the DA-100 Analyzing Data with Microsoft Power BI Study Guide.
What do you think? Let me know in the comments section if I have missed out on anything. Also, I love to hear from you about how your preparation is going on!
In case you are preparing for other Power Platform certification exams, check out the Power Platform study guides for those exams.
Follow Me to Receive Updates on DA-100 Exam
Want to be notified as soon as I post? Subscribe to the RSS feed / leave your email address in the subscribe section. Share the article to your social networks with the below links so it can benefit others.
