MCSA: Data Science

job

• 70-778 (planned)
• 70-768: Developing SQL Data Models

From https://buildazure.com/2017/04/13/new-mcsa-bi-reporting-certification-from-microsoft/

Certification Target Audience
The focus on the Developing SQL Data Models (70-768) certification exam is centered around SQL Server and Azure SQL Database topics like SSAS, BI, MDX and DAX. The exam is designed to target candidates who are Business Intelligence (BI) developers who are focused on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.
Skills Measured
Here is a high level list of the skills and objectives measured on the Provisioning SQL Databases (70-765) exam. The percentages next to each of the objectives represent the percentage of the exam questions that will be focus on that specific objective.
• Design a multidimensional business intelligence (BI) semantic model (25-30%)
○ Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
○ Design and implement dimensions in a cube
○ Implement measures and measure groups in a cube
• Design a tabular BI semantic model (20-25%)
○ Design and publish a tabular data model
○ Configure, manage, and secure a tabular model
○ Develop a tabular model to access data in near real time
• Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
○ Create basic MDX queries
○ Implement custom MDX solutions
○ Create formulas by using the DAX language
• Configure and maintain SQL Server Analysis Services (SSAS) (30-35%)
○ Plan and deploy SSAS
○ Monitor and optimize performance
○ Configure and manage processing
○ Create Key Performance Indicators (KPIs) and translations
When studying for this exam, you’ll certainly want to look at the official exam page from Microsoft for the full list of exam objectives covered. You’ll need to study each and every one of the objectives measured on the exam before attempting to take it.