Developing SQL Data Models

Exam Ref 70-768

Design a multidimensional business intelligence (BI) semantic model (25–30%)

Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)

• Design, develop, and create multidimensional databases
• Select a storage model

Design and implement dimensions in a cube

• Select an appropriate dimension model, such as fact, parent-child, roleplaying, reference, data mining, many-to-many, and slowly changing dimension
• Implement a dimension type
• Define attribute relationships

Implement measures and measure groups in a cube

• Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions
• Define semi-additive behavior

Design a tablular BI semantic model (20-25%)

Design and publish a tabular model

• Design measures