Skills measured
- Deploy and maintain deliverables (10-15%)
- Model the data (25-30%)
- Visualize the data (20-25%)
- Prepare the data (20-25%)
- Analyze the data (10-15%)
Microsoft DA-100 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Analyzing Data with Microsoft Power BI (retired) |
| Exam Number: | DA-100 |
| Real Exam Qty: | 40-60 |
| Exam Format: | Multiple choice, Case studies, Drag and drop, Lab-based simulations |
| Exam Duration: | 180 minutes |
| Exam Price: | $165 USD (varies by region) |
| Related Certifications: | Microsoft Certified: Power BI Data Analyst Associate (PL-300) |
| Available Languages: | English, Japanese, Chinese (Simplified), Korean, French, German, Spanish (varies by region) |
| Passing Score: | 700 (out of 1000) |
| Certificate Validity Period: | Retired exam (previously 2 years certification validity; now replaced by PL-300 with renewable annual certification) |
| Recommended Training: | Microsoft Learn: Analyze Data with Power BI Microsoft Learn: Power BI Data Analyst (PL-300 learning path) |
| Exam Registration: | Microsoft Certification Dashboard Microsoft Learn Exam Page (DA-100 legacy) |
| Sample Questions: | Microsoft DA-100 Sample Questions |
| Exam Way: | Online proctored or onsite via Pearson VUE test centers |
| Pre Condition: | No formal prerequisites required; basic understanding of data analytics and Power BI recommended |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/da-100/ |
Exam Topics
Microsoft expects that the successful candidates get the passing score of 720 points on a scale of 100-1000. This mark is achievable if you put your mind to it. To succeed, you must understand the Microsoft DA-100 exam topics that are as follows:
1. Data Preparation (20-25%):
This part includes the following areas:
- Cleaning, loading, & transforming data: This subject area requires that the students understand how to combine queries, utilize user-friendly value substitutions, solve data import errors, transform and measure column data types, and configure the data loading. It also covers their skills in applying data shape transformations for table structures and user-friendly conventional naming for queries and columns. The individuals should also have the expertise in leveraging Advanced Editor or modifying Power Query M-code.
- Collecting data from various data sources: The candidates must be able to connect and identify data sources, alternate data source settings, and choose storage mode and shared datasets, or build local datasets. They also need the capacity to select the relevant query type, utilize parameters, Microsoft Dataverse, create or use PBIDS files, and data flow.
- Data profile: The test takers should have competence in interrogating data statistics and column properties as well as identifying data anomalies and evaluating data structures.
Difficulty in Attempting Exam DA-100: Analyzing Data with Microsoft Power BI
However, if you would like to use different source data/tables in the same project, link them together and perform transformations on the data in Power BI as well, then the level of difficulty increases. Learning this will take of course more time. What we believe will also help is to get a general understanding of how data cleansing works and data integration in general. We offer MICROSOFT DA-100 practice exams and MICROSOFT DA-100 practice test for this purpose.
Analyzing Data with Microsoft Power BI Certification helps candidates in developing their professionals and academic career and it is a very tough task to pass Microsoft DA-100 exam for those candidates who have not done hard work and get some relevant Microsoft DA-100 exam preparation material. There are many peoples have passed Microsoft DA-100 exam by following these three things such as look for the latest Microsoft DA-100 exam dumps, get relevant MICROSOFT DA-100 exam dumps and develop their knowledge about Microsoft DA-100 exam new questions. At the same time, it can also stress out some people as they found passing Microsoft DA-100 exam a tough task. It is just a wrong assumption as many of the peoples have passed Microsoft DA-100 exam questions. All you have to do is to work hard, get some relevant Microsoft DA-100 exam preparation material and go thoroughly from them.
Compared to other visualization tools we would recommend that Power BI is quite user friendly and is relatively easy to learn. What also contributes to this is that the Power BI desktop version is available for free, resulting in a pretty large user base on the internet, which is beneficial to your learning curve, as in our experience answers to particular questions can be found easily most of the times.
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/da-100
Microsoft DA-100 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Model the data | 25-30% | - Create calculated columns and measures
|
| Topic 2: Analyze the data | 10-15% | - Analyze data patterns
|
| Topic 3: Prepare the data | 20-25% | - Clean and transform data
|
| Topic 4: Deploy and maintain deliverables | 10-15% | - Manage workspaces and datasets
|
| Topic 5: Visualize the data | 25-30% | - Enhance reports
|


PDF Version Demo






We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
1041 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.