The Data Management and Analytics competency recognizes those who demonstrate expertise in specific aspects of Microsoft Business Intelligence (BI) solutions to deliver, deploy, and support BI projects. Select a certification level:

MTA

MCSA

MCSE

1. MTA (Microsoft Technology Associate)

MTA certifications are a great place to start if you would like to get into the technology field. MTA certifications address a wide spectrum of fundamental technical concepts, assess and validate core technical knowledge, and enhance technical credibility. Note: MTA exams do not qualify for MCP certification, nor are they a prerequisite for MCSA or MCSD certification. Certification exams and prep resources:

STEP1: SKILLS
No prerequisite.

 

STEP2: EXAMS
Pass one of the following exams

EXAM 98-349(Windows Operating System Fundamentals)

EXAM 98-361(Software Development Fundamentals)

EXAM 98-364(Database Fundamental)

EXAM 98-365(Windows Server Administration Fundamentals)

EXAM 98-366(Networking Fundamental)

EXAM 98-367(Security Fundamentals)

EXAM 98-368(Mobility and Devices Fundamentals)

EXAM 98-369(Cloud Fundamentals)

EXAM 98-375(HTML5 Application Development Fundamentals)

EXAM 98-380(Introduction to Programming using Block-Based Languages)

EXAM 98-381(Introduction to Programming using Python)

EXAM 98-382(Introduction to Programming using JavaScript)

EXAM 98-383 (Introduction to Programming using HTML and CSS)

STEP3: COMPLETION
Completed one MTA for every exam you pass in step 2.

 

STEP4: CONTINUINING EDUCATION
Earn an MCSA or MCSD certification to broaden your expertise.

 

2. MCSA (Microsoft Certified Solutions Associate)

This 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. Certification exams and prep resources:

STEP1: SKILLS
Possess foundational IT skills.

 

STEP2: EXAMS
Pass one of the following exams

EXAM 70-767(Implementing a SQL Data Warehouse)

EXAM 70-768(Developing SQL Data Models)

 

STEP3: COMPLETION
Completed an MCSA: SQL Business Intelligence Development Certification by passing the required exams in step2

 

STEP4: CONTINUINING EDUCATION
Earn an MCSE certification to broaden your expertise.

 

3. MCSE (Microsoft Certified Solutions Expert)

Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data – both on-premises and in cloud environments. Certification exams and prep resources:

STEP1: SKILLS
Earn your MCSA certification.

 

STEP2: EXAMS
Pass one of the following exams

EXAM 70-473(Design and Implement Cloud Data Platform Solutions)

EXAM 70-475(Design and Implement Big Data Analytics Solutions)

EXAM 70-464(Developing Microsoft SQL Server 2012 Databases)

EXAM 70-465(Designing Database solutions for SQL server 2012)

EXAM 70-466(Implementing Data Model and Reports with Microsoft SQL server)

EXAM 70-467(Designing Business Intelligence Solution with Microsoft SQL server)

EXAM 70-762(Administering Microsoft SQL Server 2012/2014 Databases)

EXAM 70-767(Implementing a Data warehouse using SQL)

EXAM 70-768(Developing SQL Data Model)

EXAM 70-773(Analyzing Big Data with Microsoft R)

EXAM 70-774(Perform Cloud Data Science with Azure Machine Learning)

EXAM 70-775(Perform Data Engineering on Microsoft Azure HDInsight)

 

STEP3: COMPLETION
Complete an MCSE in data management and analytics by passing the required exams in step2.

 

STEP4: CONTINUINING EDUCATION
Explore other certification to broaden your expertise.