The 3-days Microsoft 20768B Developing SQL Data Models Certification course is Part 2 of the series of two courses of MCSA 2016: SQL Business Intelligence Development, meant for database professionals who develop and implement multidimensional models and tabular models on Online Analytical Processing (OLAP) cubes by using SQL Server Analysis Services (SSAS).
The SSAS provides data mining functionality by letting you design, create and manage the multiple databases that are aggregated from other data resources, such as relational databases.
Module 1: Introduction to Business Intelligence and Data Modeling
This module describes key BI concepts and the Microsoft BI product suite.
Lessons
Module 2: Creating Multidimensional Databases
This module explains the steps required to create a multidimensional database with analysis services.
Lessons
Module 3: Working with Cubes and Dimensions
This module explains how to implement dimensions in a cube.
Lessons
Module 4: Working with Measures and Measure Groups
This module explains how to implement measures and measure groups in a cube.
Lessons
Module 5: Introduction to MDX
This module explains the MDX syntax and how to use MDX.
Lessons
Module 6: Customizing Cube Functionality
This module explains how to customize a cube.
Lessons
Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module explains how to implement a tabular data model in PowerPivot.
Lessons
Module 8: Introduction to Data Analysis Expressions (DAX)
This module describes how to use DAX to create measures and calculated columns in a tabular data model.
Lessons
Module 9: Performing Predictive Analysis with Data Mining
This module describes how to use data mining for predictive analysis.
Lessons
This Developing SQL Data Models SSAS training course is intended for database professionals who need to accomplish a Business Intelligence Developer role. They will be required to exhibit hands-on work creating BI solutions Primary responsibilities will include:
This course requires that you meet the following prerequisites:
Name | Code | Fee |
---|---|---|
Developing SQL Data Models Certification | 70-768 | USD 108 |
OR