Study material for exam DA-100 Analyzing Data with Microsoft Power BI

By:   |   Updated: 2021-03-25   |   Comments (4)   |   Related: More > Professional Development Certifications

   Free MSSQLTips webinar - "Efficient Monitoring and Management of SQL Server" (click to register)


Microsoft has a new exam DA-100 Analyzing Data with Microsoft Power BI and the content of this exam will be updated on March 23, 2021. What are some of the best materials I can use to study for this exam?


In this tip, we will provide you with the basic information on this exam and the appropriate study materials including web links, books, online courses, practice test and tips you can use to prepare for and pass the exam.

What is the Audience of DA-100 Exam?

This exam DA-100 Analyzing Data with Microsoft Power BI is aimed at Data Analysts who want to validate their skills. Candidates should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.

What is the Format, Duration, Number of Questions of the exam?

  • The exam DA-100 duration is 180 Minutes.
  • The exam DA-100 format includes multiple choice and multi-response questions.
  • The exam DA-100 has 40-60 questions.

What is the score to pass?

  • 700/1000

Which books would you recommend for this exam?

  • Exam Ref DA-100 Analyzing Data with Microsoft Power BI 1st Edition by Daniil Maslyuk. This Exam Ref is the official study guide for the new Microsoft DA-100 Analyzing Data with Microsoft Power BI certification exam. This title has not yet been released as of this writing, but you can preorder the book at
  • The Definitive Guide to DAX Second Edition by Alberto Ferrari Marco Russo. As DAX are intensive topics in the exam, this comprehensive and authoritative guide to the DAX language will be very useful to prepare for and pass the exam.
  • Microsoft Power BI Quick Start Guide 2nd Edition by Devin Knight etc. The book provides an accessible fast paced introduction to all aspects of Power BI for new or aspiring BI professionals who want to get up and running with Microsoft Power BI.

Do you recommend a practice test for this exam? provides the Microsoft Official Practice Test powered by MeasureUp. This test contains 146 questions and all objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Are there some courses for this exam?

Microsoft Learning paths provides some free online courses to gain the skills needed to become certified. The Learning paths videos covering the following topics:

  • Get started with Microsoft data analytics
  • Prepare data for analysis
  • Model data in Power B
  • Visualize data in Power BI
  • Data analysis in Power BI

Udemy has a course covers the content required for the DA-100 certification exams, current as per the DA-100 exam update of 27 January 2021.

Can you provide some links to study for the exam?

Here are the best links that we recommend (Red links are the changes that will be implemented on March 23, 2021):

Prepare the Data

Model the Data

Visualize the Data

Analyze the Data

Deploy and Maintain Deliverables

Next Steps

For more information and exam prepare tips, refer to the links below:

Get Started Now - Click here to get your free 14 day trial of SolarWinds Database Insights

get scripts

next tip button

About the author
MSSQLTips author Sean Lee Sean Lee has been a SQL Server Database Administrator for over 20 years. He obtained his MCSE Data Management and Analytics in 2016. He is also the founder of

View all my tips

Article Last Updated: 2021-03-25

Comments For This Article

Monday, November 1, 2021 - 8:49:29 PM - Sean Lee Back To Top (89393)
Hi Phillip, thank you for providing our readers with the discount price link:

Also thank Nidhi for the new duration info.

I will update this tip soon and do so periodically.

Monday, November 1, 2021 - 1:08:35 PM - Nidhi Patel Back To Top (89391)
I recently wrote and the exam has changed to 100 minutes to answer the questions and a leading 20 minutes for instructions.

Friday, October 29, 2021 - 4:19:33 PM - Harneet Kaur Back To Top (89388)
Hello, Is there any update in duration of exam ?

Tuesday, June 8, 2021 - 4:29:42 AM - Phillip Burton Back To Top (88816)
Thank you very much, Sean, for recommending my Udemy course in your article.
It is up to date for the latest exam requirements, and I will be keeping it up to date.
I've noticed a lot of your readers using the link in your article (137 in the last 30 days).
If they would like it for a cheaper price than in that link, then this link will allow them to get it for a cheaper price:
If this is not useful, then please delete this comment.
Once again, thank you for recommending my course.


get free sql tips
agree to terms