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.
What is good
- Validates ETL and data warehouse skills
- Covers multidimensional and tabular data models
- Includes OLAP cubes and BI implementation
What to know first
- Certification has been retired
- Lists two required exams
Verdict
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.
