Certification

Microsoft Certified: Azure Enterprise Data Analyst Associate

Demonstrate methods and practices for performing advanced analytics at scale with Microsoft Purview, Microsoft Azure Synapse Analytics, and Microsoft Power BI.

At a glance

Jump to

Overview

Warning

This certification retired on April 30, 2024. You can renew it for six months after the retirement date by completing the free online assessment available on the certification renewal page. Learn more.

As a candidate for this certification, you should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.

Your responsibilities for this role include performing 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.
  • Applying development lifecycle practices.

As a professional in this role, you:

  • Help collect enterprise-level requirements for data analytics solutions that include Azure and Power BI.
  • Advise on data governance and configuration settings for Power BI administration.
  • Monitor data usage.
  • Optimize performance of the data analytics solutions.

As an Azure enterprise data analyst, you collaborate with other roles, such as:

  • Solution architects
  • Data engineers
  • Data scientists
  • AI engineers
  • Database administrators
  • Power BI data analysts

As a candidate for this certification, you 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). You 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.

Important

On January 11, 2024, a new version of this certification, Microsoft Certified: Fabric Analytics Engineer Associate, became available. Read the blog post.

Skills measured

  • Implement and manage a data analytics environment
  • Query and transform data
  • Implement and manage data models
  • Explore and visualize data

Prepare for the exam

No training available for this exam.

Take the exam

You will have 100 minutes to complete this assessment.

Exam policy

This exam will be proctored, and is not open book. You may have interactive components to complete as part of this exam. To learn more about exam duration and experience, visit: Exam duration and exam experience.

If you fail a certification exam, don’t worry. You can retake it 24 hours after the first attempt. For subsequent retakes, the amount of time varies. For full details, visit: Exam retake policy.

Need accommodations?

We offer a variety of accommodations to support you.

Learn More

This exam is offered in the following languages:

English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian

Renew your certification

Do you know that Microsoft role-based and specialty certifications expire unless they are renewed? Learn the latest updates to the technology for your job role and renew your certification at no cost by passing an online assessment on Microsoft Learn.

Learn more about renewing

Certification resources

Certification poster

Check out an overview of fundamentals, role-based, and specialty certifications.

Exam Replay

Boost your odds of success with this great offer.

Support for credentials

Get help through Microsoft Credentials support forums. A forum moderator will respond in one business day, Monday–Friday.

Choose your Microsoft Credential

Microsoft Applied Skills or Microsoft Certifications? Choose the path that fits your career goals, desired skillset, and schedule.