Candidates for this exam should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.
Passing score: 700. Learn more about exam scores.
Part of the requirements for: Microsoft Certified: Azure Enterprise Data Analyst Associate
Related exams: none
Important: See detailsGo to Certification Dashboard
- Download the study guide in the preceding “Tip” box for more details about the skills measured on this exam.
- Implement and manage a data analytics environment (25–30%)
- Query and transform data (20–25%)
- Implement and manage data models (25–30%)
- Explore and visualize data (20–25%)
Two ways to prepare
Azure enterprise data analysts perform advanced data analytics at scale, such as cleaning and transforming data, designing and building enterprise data models, incorporating advanced analytics capabilities, integrating with IT infrastructure, and applying development lifecycle practices.
Explore all certifications in a concise training and certifications guide.
Check out an overview of fundamentals, role-based and specialty certifications.
See two great offers to help boost your odds of success.
Get help through Microsoft Certification support forums. A forum moderator will respond in one business day, Monday-Friday.
Review and manage your scheduled appointments, certificates, and transcripts.
Learn more about requesting an accommodation for your exam.
Review the exam policies and frequently asked questions.