MSBI CERTIFICTION

The below information copied from the following Microsoft web site.

https://www.microsoft.com/en-us/learning/mcsa-sql2016-business-intelligence-certification.aspx

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.

 

Exams:

 

Exam 70-767/Course 20767A

 

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.
 

 

Topics:

 

a) Design anf implement a data warehouse (30-35%)
b) Extract, Trasform, and load data (35-40%)
c) Integrate solutios with cloud data and big data (15-20%)
d) Build data quality solutions (15-20%)

 

Exam 70-768/Course 20768A

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.
 

 

Topics:

 

a) Design a multidimensional business intelligence (BI) semantic model (25-30%)
b) Design a tabular BI semantic model (20-25%)
c) Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
d) Configure and maintain Sql Server Analysis Services (SSAS) (30-35%)