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.
DA-100 Analyzing Data with Microsoft Power BI
Udemy DA-100: 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]
DA-100 Microsoft Power BI Practice Test
Udemy Practice Test DA-100 Microsoft Power BI Practice Exam Amazon e-book (PDF) DA-100: Data Analyst 25 Prep Questions
Microsoft Power BI Projects
Datacamp (Interactive) Introduction to Microsoft Power BI Coursera Guided Project Getting Started with Power BI Desktop
To view other Power Platform Certificate Study Guides, click here
Full Disclosure: Some of the links in this post are affiliate links. I receive a commission when you purchase through them.
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.
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 the Common Data Service (CDS)
Use parameters
Watch video on Specifying Parameters for Data Source in Power BI
Profile the Data
Identify data anomalies
Visualize anomalies using batch detection & Power BI
Examine data structures
Interrogate column properties
Watch video on Column Profiling in Power BI Desktop
Interrogate data statistics
Worldwide demographics & statistics using Power Query & Power View
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
Watch video on How to Spot and Improve Data Quality in Power BI
Apply user-friendly value replacements
Watch video on 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
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
Set up the Q&A feature
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
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
Watch video on Slow Power BI report
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
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
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 Power BI service
Pin a live report page to a dashboard
Add a new dashboard tile is by pinning an entire report page
Configure data classification
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
Watch video on 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
Analyze the Data (10-15%)
Enhance Reports to Expose Insights
Apply conditional formatting
Use conditional formatting in tables
Apply slicers and filters
Watch video on Power BI Slicers vs Filters
Perform top N analysis
Watch video on 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
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
Deploy and Maintain Deliverables (10-15%)
Manage Datasets
Configure a dataset scheduled refresh
Configure row-level security group membership
Watch video on 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 a dataset
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
This brings us to the end of the DA-100 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 looking for other Power Platform certificate exams check out this page
Follow/Like ravikirans.com to Receive Updates
Sign up for Newsletter
Want to be notified as soon as I post? Subscribe to 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.
