Overview

Introduction

The Implement 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 tasks:

  • Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube

Exercise 1 - Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube

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

  • Use SQL Server Data Tools - Business Intelligence (SSDT-BI) to build the cube; use SSDT-BI to do non-additive or semi-additive measures in a cube
  • Define measures
  • Specify perspectives
  • Define translations
  • Define dimension usage
  • Define cube-specific dimension properties
  • Define measure groups
  • Implement reference dimensions
  • Implement many-to-many relationships
  • Implement fact relationships
  • Implement role-playing relationships
  • Create and manage linked measure groups and linked dimensions
  • Create actions

Comprehensive Learning

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