Microsoft SQL Server 2014: Design and Implement Dimensions

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

Prerequisite
None

Expected Duration
128 minutes

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.

Objective

Creating 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
  • Measure Groups

  • 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
  • Practice: Create Dimensions and Measures

  • design and create dimensions and measures given different scenarios
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.