Microsoft BI

MCSA: SQL 2016 BI Development

Microsoft Certified Solutions Associate

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.

MCSA SQL 2016 BI Development

Key technologies

  • SQL Server

What is involved

Earning an MCSA: SQL 2016 Business Intelligence Development certification qualifies you for a position as a BI developer.

STEP 1 - SKILLS

Possess foundational IT skills. If you feel that you do not possess these skills, consider pursuing one or more Microsoft Technology Associate (MTA) certifications.

STEP 2 - EXAMS

Pass 2 required exams. Be sure to explore the exam prep resources.

STEP 3 - CERTIFICATION

Earn your MCSA: SQL 2016 Business Intelligence Development certification.

STEP 4 - CONTINUING EDUCATION

Earn an MCSE by passing 1 related exam.

Certification Exams and prep resources

70-767

Exam 70-767/Course 20767

Implementing a SQL Data Warehouse

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.

View exam details

Optional training

70-768

Exam 70-768/Course 20768

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.

View exam details

Optional training

MCSA SQL 2016 BI DevelopmentMCSA: SQL 2016 Business Intelligence Development

The skills for your professional career

Completed this certification?

Visit Your dashboard

MCSE Data Management and AnalyticsMCSE: Data Management and Analytics
Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data – both on-premises and in cloud environments.

Explore this certification