MCSA: SQL 2016 BI Development

In response to the coronavirus (COVID-19) situation, Microsoft is implementing several temporary changes to our training and certification program. Learn more.

This certification retires on January 31, 2021. You will no longer be able to earn this certification after this date. Any certifications you earn prior to their retirement dates will continue to appear on your transcript in the Certification Dashboard. You can also browse all retired certifications.

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.

Job role: Data Analyst

Required exams: 70-767 70-768

Important: See details

Go to Certification Dashboard

Certification details

Take two exams

AND

CERTIFICATION EXAM

Developing SQL Data Models

Earn the certification

ASSOCIATE CERTIFICATION

MCSA: SQL 2016 BI Development

Skills measured

  • none

Two ways to prepare

Learning paths to gain the skills needed to become certified

    Learning paths are not yet available for this certification

Certification exams

  • 70-767: Implementing a Data Warehouse using SQL

    Languages: en

    Retirement date:

    This exam is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

    Price based on the country in which the exam is proctored.

    for Implementing a Data Warehouse using SQL

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

  • 70-768: Developing SQL Data Models

    Languages: en

    Retirement date:

    This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

    Price based on the country in which the exam is proctored.

    for Developing SQL Data Models

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

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.

* 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.