MS 20768B – Developing SQL Data Models

The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite.

Module 2: Creating Multidimensional Databases
This module describes how to create multidimensional databases using SQL Server Analysis Services.

Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions in a cube.

Module 4: Working with Measures and Measure Groups
This module describes how to implement measures and measure groups in a cube.

Module 5: Introduction to MDX
This module describes the MDX syntax and how to use MDX.

Module 6: Customizing Cube Functionality
This module describes how to customize a cube.

Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in Power Pivot.

Module 8: Introduction to Data Analysis Expression (DAX)
This module describes how to use DAX to create measures and calculated columns in a tabular data model.

Module 9: Performing Predictive Analysis with Data Mining
This module describes how to use data mining for predictive analysis.