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