Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo
Certification · Microsoft

MCSA: SQL 2016 BI Development

What it is

MCSA: SQL 2016 BI Development is an intermediate Microsoft certification associated with data analyst roles. It validates extract, transform, and load (ETL) and data warehouse skills, together with skills for implementing business intelligence solutions. The described BI work uses multidimensional and tabular data models and online analytical processing (OLAP) cubes. The certification lists exams 70-767 and 70-768 and is associated with the MCSA family. The certification has been retired, so it is not a current credential option. The listed guidance points readers seeking available options to Microsoft’s certification and exam listings. Its subject matter is specific to SQL 2016 business intelligence development, with a focus on data preparation, warehouse work, and BI implementation rather than general analytics.

Who it is for

It was intended for data analysts seeking validation of ETL, data warehouse, and BI implementation skills involving multidimensional or tabular models and OLAP cubes.

Good to know

  • Validates ETL and data warehouse skills
  • Covers multidimensional and tabular data models
  • Includes OLAP cubes and BI implementation
  • Certification has been retired
  • Lists two required exams

The facts

Type
Certification (mcsa)
Level
intermediate
For
Data analyst
Products
mcsa
Provider
Microsoft
Catalogue updated
5 Feb 2025

learn.microsoft.com

The exams behind it

In short

This credential focused on SQL 2016 BI development and its related data skills. Because it is retired, readers should look to currently available certification options instead.