MOC 20768 Developing SQL Data Models

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Obsah školení

Describe the components, architecture, and nature of a BI solution

Create a multidimensional database with analysis services

Implement dimensions in a cube

Implement measures and measure groups in a cube

Use MDX syntax

Customize a cube

Implement a tabular database

Use DAX to query a tabular model

Use data mining for predictive analysis