Exam DA-100: Analyzing Data with Microsoft Power BI

powerbiMicrosoft released the exam DA-100 (Analyzing Data with Microsoft Power BI) around early April 2020 which was in Beta until around the beginning of July. After the exam become out of Beta, I was wondering why do I want to take the exam DA-100? What is the benefit of passing this exam? And then some thoughts came to my mind 😊

  • I enjoy spending my time studying, but I felt that I need to commit so I can focus on studying. At this stage, I decided to schedule the exam, so I had to pick the date and time. I believe I would not dedicate to my studies if I didn’t have the exam booked.
  • I also enjoy teaching, and it is a good feeling when I am able to help someone. In simple words, taking the exam was my chance to learn, assure my skills, and my dedication to passing the exam would allow me to share my knowledge with others.
  • I’ve been working with Power BI since it was in Preview, but Power BI is a huge topic, so at some point, a question crossed my mind: How can I measure my skills? For sure, passing the exam would answer it.
  • Last but not least, if I am in an interview process with a candidate that has the same experience as myself and the only difference between us is, I have a Microsoft Certification, and the other candidate doesn’t, I think it could be a plus for me.

The exam contains 59 questions in total, and your score needs to be 700 or more.  The skills are measured as below:

  • Prepare the data (20-25%)
  • Model the data (25-30%)
  • Visualize the data (20-25%)
  • Analyze the data (10-15%)
  • Deploy and maintain deliverables (10-15%)

In my exam, I had 2 case studies (the first and the last set of questions, were case studies). In the case studies, they provide you with a real-life scenario, such as reports with performance issues, reports with a high volume of data, and they also provide the requirements and data sources information.

After reading all this information, I had to answer around four or five questions. I had to go back a few times to understand the requirements, and I am sure my work experience helped me to answer most of them.

The exam also had a lot of multiple-choice questions, where some of them I had to choose only one answer and some I had to choose two answers. There were also some drag and drop questions with DAX and to add in the correct order.

I will list below some topics that I saw on my exam:

  • Data Modelling/Relationship (one to many, many to many)
  • Data Profiling in Power BI
  • Column distribution, column quality
  • Forecast
  • RLS
  • Measure and calculated column
  • DAX (Related, Sum, SumX…)
  • Merge and Append
  • Security/Workspace roles: Admin, Member, Contributor, or Viewer. (They provide a scenario and ask what the correct role is).

For the exam skills outline go to: https://docs.microsoft.com/en-us/learn/certifications/exams/da-100

If you are looking to study for the exam, have a look at the Microsoft Learning Path:

Get started with Microsoft data analytics


Prepare data for analysis


Create and use analytics reports with Power BI


Model data in Power BI


Consume data with Power BI


Visualize data in Power BI


Data analysis in Power BI


Manage workspaces and datasets in Power BI


Use DAX in Power BI Desktop


Some additional links:








In summary, if you are looking to take this exam and you don’t have much experience with Power BI, I suggest you spend a considerable amount of time exploring Power BI. My work experience helped me a lot, and I had only to review a few concepts before the exam.

Hope it helps and good luck!


5 thoughts on “Exam DA-100: Analyzing Data with Microsoft Power BI

  1. CertsGoal providing exam questions for exams organized by Microsoft, Cisco, Amazon, CompTIA and Google .We provide 100% accurate and updated practice exam questions and answers (PDF) originated by our professionals .You can start your exam preparation by downloading the CertsGoal sample questions free demo right now.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s