Course Details

Previous Page


Microsoft SQL Server 2014: Design and Implement Dimensions


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



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