Developing SQL Data Models

Descrizione del corso

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.

Programma

1. Introduction to Business Intelligence and Data Modeling
   • This module introduces key BI concepts and the Microsoft BI product suite.
2. Creating Multidimensional Databases
   • This module describes the steps required to create a multidimensional database with analysis services.
3. Working with Cubes and Dimensions
   • This module describes how to implement dimensions in a cube.
4. Working with Measures and Measure Groups
   • This module describes how to implement measures and measure groups in a cube.
5. Introduction to MDX
   • This module describes the MDX syntax and how to use MDX.
6. Customizing Cube Functionality
   • This module describes how to customize a cube.
7. Implementing a Tabular Data Model by Using Analysis Services
   • This module describes how to implement a tabular data model in PowerPivot.
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.
9. Performing Predictive Analysis with Data Mining
   • This module describes how to use data mining for predictive analysis.