data analyst certification Microsoft

Last Updated on July 28, 2023

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page. Any certifications you earn prior to their retirement dates will continue to appear on your transcript in the Certification Dashboard.

This certification validates that you have the skills needed to run a highly efficient and modern data center, identity management, systems management, virtualization, storage, and networking.

To earn the MCSE: Data Management & Analytics certification, complete the following requirements:

  • Earn one prerequisite certification:
    • Prerequisite Option 1: MCSA: SQL Server 2012/2014
    • Prerequisite Option 2: MCSA: SQL 2016 Database Development
    • Prerequisite Option 3: MCSA: SQL 2016 Database Administration
    • Prerequisite Option 4: MCSA: SQL 2016 BI Development
    • Prerequisite Option 5: MCSA: BI Reporting
  • And pass one of the elective exams:
    • 70-464: Developing Microsoft SQL Server Databases
    • 70-465: Designing Database Solutions for Microsoft SQL Server
    • 70-466: Implementing Data Models and Reports with Microsoft SQL Server
    • 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
    • 70-762: Developing SQL Databases
    • 70-767: Implementing a Data Warehouse using SQL
    • 70-768: Developing SQL Data Models
    • 70-777: Implementing Microsoft Azure Cosmos DB Solutions

Job role: Database Administrator

Prerequisites: 5 certifications

Required exams: 70-46470-46570-466

Important: See detailsGo to Certification Dashboard

Certification details

Complete one prerequisite

PREREQUISITE OPTION 1

MCSA: SQL Server 2012/2014OR

PREREQUISITE OPTION 2

MCSA: SQL 2016 Database DevelopmentOR

PREREQUISITE OPTION 3

MCSA: SQL 2016 Database AdministrationOR

PREREQUISITE OPTION 4

MCSA: SQL 2016 BI DevelopmentOR

PREREQUISITE OPTION 5

MCSA: BI Reporting

Take three exams

CERTIFICATION EXAM

Developing Microsoft SQL Server DatabasesAND

CERTIFICATION EXAM

Designing Database Solutions for Microsoft SQL ServerAND

CERTIFICATION EXAM

Implementing Data Models and Reports with Microsoft SQL Server

Earn the certification

ASSOCIATE CERTIFICATION

MCSE: Data Management and Analytics

Skills measured

  • none

Two ways to prepare

Online – FreeInstructor-led – Paid

Learning paths to gain the skills needed to become certified

Certification prerequisites

To become a MCSE: Data Management and Analytics, you must earn at least one of the following: MCSA: SQL Server 2012/2014, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 Database Administration, MCSA: SQL 2016 BI Development, MCSA: BI Reporting certification.

  • MCSA: SQL Server 2012/2014Option 1: Prerequisite certificationThis certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.
  • MCSA: SQL 2016 Database DevelopmentOption 2: Prerequisite certificationThis certification demonstrates your skills as a database professional, for both on-premises and cloud-based databases.
  • MCSA: SQL 2016 Database AdministrationOption 3: Prerequisite certificationThis certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.
  • MCSA: SQL 2016 BI DevelopmentOption 4: Prerequisite certificationThis certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes.
  • MCSA: BI ReportingOption 5: Prerequisite certificationThis certification demonstrates your expertise in analyzing data with both Power BI and Excel.

Certification exams

  • Exam 70-464: Developing Microsoft SQL Server DatabasesLanguages: EnglishChinese (Simplified)FrenchGermanJapanesePortuguese (Brazil)Retirement date: 01/31/2021**This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.Official practice test for Developing Microsoft SQL Server DatabasesAll objectives of the exam are covered in depth so you’ll be ready for any question on the exam.Save
  • Exam 70-465: Designing Database Solutions for Microsoft SQL ServerLanguages: EnglishChinese (Simplified)FrenchGermanJapanesePortuguese (Brazil)Retirement date: 01/31/2021**This exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs.Save
  • Exam 70-466: Implementing Data Models and Reports with Microsoft SQL ServerLanguages: EnglishChinese (Simplified)FrenchGermanJapanesePortuguese (Brazil)Retirement date: 01/31/2021**This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.Save

Certification resources

Training and certification guide

Explore all certifications in a concise training and certifications guide.

Certification poster

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

Exam Replay

See two great offers to help boost your odds of success.

Support for certifications

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

Certification dashboard

Review and manage your scheduled appointments, certificates, and transcripts.

Share your certification badges

Celebrate your accomplishment with your network. Claim your Microsoft Certification badge, and add it to LinkedIn, your résumé, and more.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.

About the author

Study on Scholarship Today -- Check your eligibility for up to 100% scholarship.

Leave a Comment