DA-100 Exam Study Guide (Analyzing Data with Microsoft Power BI)


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

DA-100 Microsoft Power BI Practice Test

Microsoft Power BI Projects

Datacamp (Interactive)Introduction to Microsoft Power BI
Coursera Guided ProjectSales Analysis using Power BI

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.

DA-100 Sample Practice Exam Questions

DA-100 certification sample practice EXAM questions (ANALYZING DATA WITH MICROSOFT POWER BI)

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.

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.

Prepare the Data (20-25%)

Get Data from Different Data Sources

Profile the Data

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

Replacing the values

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

Merging 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

The Advanced Editor

Configure data loading

New updates in Power Query

Resolve data import errors

Resolve data import errors

DA-100 Introducing Microsoft Power BI

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

Format the table

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

Role-playing dimensions

Define a relationship’s cardinality and cross-filter direction

The Cardinality option

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

Hierarchies in data models

Develop a Data Model

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

Convert column to measure

Use basic statistical functions to enhance data

DAX Statistical Functions

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

Slow Measures

Dealing with slow measures

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

Summarizing data

Create and manage aggregations

Create & manage aggregations

Visualize the Data (20-25%)

Create Reports

Create Dashboards

Enrich Reports for Usability

Analyze the Data (10-15%)

Enhance Reports to Expose Insights

Apply conditional formatting

Use conditional formatting in tables

Apply slicers and filters

Power BI Slicers vs Filters

Perform top N analysis

When & How to Use TOPN in Power BI

Explore statistical summary

Explore statistical summary

Use the Q&A visual

The Q&A feature in Power BI

Add a Quick Insights result to a report

Review Quick insights

Create reference lines by using the Analytics pane

Use the Analytics pane

Use the Play Axis feature of a visualization

Play Axis (Dynamic Slicer)

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

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 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

Certify datasets – Power BI

Identify downstream dataset dependencies

Dataset impact analysis

Configure large dataset format

Large datasets in Power BI Premium

Using Power BI with large datasets

Create and Manage Workspaces

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 looking for other Power Platform certificate exams check out this page

Follow/Like ravikirans.com to Receive Updates

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.

Share the Article in Your Social Media Networks


You may also like


  1. Hi Brother,
    Thanks for your article, I have a few doubts before starting to prepare for the examinations. Your linked-in profile shows a server error. How could I reach you? Feel free, I never interrupt you prior to your permissions. Please reply to me

Leave a Reply

Your email address will not be published. Required fields are marked *