Certifications

MCSA: SQL 2016 BI Development

Certification details

Warning

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page.

 

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.

Skills measured

  • Design, implement, and maintain a data warehouse
  • Extract, transform, and load data
  • Build data quality solutions
  • Design a multidimensional business intelligence (BI) semantic model
  • Design a tabular BI semantic model
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
  • Configure and maintain SQL Server Analysis Services (SSAS)

Download certification skills outline

Job role: Data Analyst

Required exams: 70-767 70-768

Go to Learn Profile

Two ways to prepare

Items in this collection

  • Learning paths or modules 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 or region in which the exam is proctored.

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    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 or region in which the exam is proctored.

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    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

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.

Certification poster

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

Exam Replay

Boost your odds of success with this great offer.

Your certifications

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