MCSA: SQL 2016 Business Intelligence Development

Challenge set!

In May, I set a target of obtaining accreditation as a Microsoft Certified Solution Expert in Data Management and Analytics by the end of June. I really wanted to pick up this accreditation because whilst Microsoft will put an end to these exams in 2021, they remain valid for 3 years and there’s a fair amount of value (in my opinion) in capping off my 15 years experience with this cert to compliment some of the newer role-based certifications designed around the Azure platform.

Exam 70-767: Implementing a Data Warehouse using SQL

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.

badge for exam 70-767

Exam 70-768: Developing SQL Data Models

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.

badge for exam 70-768

Microsoft Certified Solutions Associate SQL 2016 Business Intelligence Development

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.

badge for MCSA

Next up MCSE!

With two exams done, the final objective is to cap off the MCSA with a third exam in order to obtain Microsoft Certified Solutions Expert certification.


  • You can view my certificate here.


If you made it all the way down here, thanks for reading my post and enjoy your day. If you have any comments or suggestions, please leave them below...

the jedi order logo