We're so confident of our products that we provide no hassle product exchange.
Microsoft DA-100 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Analyzing Data with Microsoft Power BI |
| Exam Number: | DA-100 |
| Real Exam Qty: | 40-60 |
| Exam Duration: | 120 minutes |
| Available Languages: | English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Chinese (Traditional), Italian |
| Passing Score: | 700 |
| Exam Format: | Multiple choice, Multiple response, Drag and drop, Case study, Build list |
| Certificate Validity Period: | Certification valid for one year, renewable |
| Exam Price: | USD 165 |
| Related Certifications: | Microsoft Certified: Data Analyst Associate |
| Sample Questions: | Microsoft DA-100 Sample Questions |
| Exam Way: | Online (proctored) or Onsite at a Pearson VUE testing center |
| Pre Condition: | Familiarity with data concepts and experience with data analysis |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/ |
Skills measured
- Analyze the data (10-15%)
- Deploy and maintain deliverables (10-15%)
- Visualize the data (20-25%)
- Prepare the data (20-25%)
- Model the data (25-30%)
2. Data Model (25-30%):
The main domains of this section are:
- Data model development: This objective requires one’s ability to create hierarchies, calculated tables, and calculated columns. It also covers your skills in establishing Q&A features, implementing row-level security functions, and applying security filtering and cross-filter direction.
- Data model design: The learners need to have competence in defining tables, role-playing dimensions, quick measures, and cross-filter direction & relationship cardinality. The topic also requires their skills in designing a data model to fulfill the performance prerequisites, creating common data tables, and solving many-to-many relationships.
- Model performance optimization: This module will measure your competence in enhancing cardinality levels through changing data types and summarization. It will also evaluate your skills in eliminating unnecessary columns and rows, creating and managing aggregations, and identifying poorly performing visuals, measures, and relationships.
- Creation of measures with DAX: The applicants should be able to utilize DAX in building multifaceted measures, use CALCULATE to maneuver filters, and utilize the fundamental statistical functions for enhancing data. This domain also requires their skills in creating semi-additive measures and implementing Time Intelligence with DAX.
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 | 30% | - Design a data model
|
| Topic 2: Deploy and maintain deliverables | 10% | - Manage datasets
|
| Topic 3: Prepare the data | 20% | - Transform and load the data
|
| Topic 4: Visualize the data | 25% | - Create reports
|
| Topic 5: Analyze the data | 15% | - Enhance reports for usability and storytelling
|
By Tracy
