Microsoft SQL Server 2014: Design and Implement Dimensions

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
SQL Server Analysis Services or SSAS multidimensional models contain objects called Dimensions, which is a collection of related objects used to provide the fact data to one or more cubes. The data provided to the cube is used by users to analyze the fact data. Dimensions are required in a multidimensional model to provide the basic information, attributes, and hierarchies. This course will demonstrate how to create dimensions, including how to configure relationships, hierarchies, and attributes. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience
Business intelligence developers who create reporting and analysis solutions, and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
2.1

Lesson Objectives

Microsoft SQL Server 2014: Design and Implement Dimensions

start the course

create a dimension using the Dimension Wizard

configure a dimension structure using the Dimension Designer

configure dimension attribute relationships using the Dimension Designer

develop a custom attribute on a dimension

create user-defined hierarchies in a dimension

define a translation for dimension metadata

create a time dimension using the Dimension Wizard

modify a time dimension using the Dimension Designer

manage parent-child dimensions

create linked dimensions

create a basic measure

create a measure group

design granularity

create linked measure groups

use aggregation functions to create an additive measure

use aggregation functions to create a nonadditive measure

explain how to define a semiadditive measure

use aggregation functions to create a semiadditive measure

configure measure properties

configure measure group properties

design and create dimensions and measures given different scenarios

Course Number:
md_idmr_a04_it_enus

Expertise Level
Intermediate