Overview

Introduction

The Design Dimensions and Measures of a Cube module provides you with the instruction and Server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  • Create an Analysis service project
  • Add data source to the project
  • Add data source view to the project
  • Add dimensions to the project
  • Define cube and measures
  • Add attributes to dimensions
  • Build Hierarchies
  • Define attribute relationships
  • Implement hierarchies
  • Dimension type
  • Develop new custom attributes

Exercise 1 - Design Dimensions and Measures

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Identify the dimension/measure group relationship that should be selected
  • Design patterns for representing business facts and dimensions (many-to-many relationships)
  • Design dimensions to support multiple related measure groups (many related fact tables)
  • Identify the measures
  • Manage dimensions in a cube
  • Identify the attributes of dimensions
  • Build hierarchies

Exercise 2 - Implement and Configure Dimensions in a Cube

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Translations
  • Define attribute relationships
  • Implement hierarchies
  • Implement SQL Server Analysis Services (SSAS) dimensions and cube
  • Create the Attribute Relationships that should be made for a given set of attributes in a dimension
  • Develop new custom attributes on dimensions
  • Detect possible design flaws in attribute relationships
  • Implement time dimensions in cubes
  • Manage SSAS parent-child dimensions
  • Dimension type

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.