• Online, Self-Paced
Course Description

A cube in a SQL Server Analysis Services or SSAS multidimensional model contains the information required to perform the analysis on the data. Cubes consist of dimensions which provide the data and measures which provide aggregated numerical values. This course demonstrates how to create cubes, measures, and measure groups along with other elements including perspectives, hierarchies, and relationships. 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.

Learning Objectives

Creating Cubes

  • start the course
  • create a new cube using the Cube Wizard
  • create an empty cube
  • create a cube using a template
  • view and navigate the cube schema
  • browse cube data and metadata to examine the structure of the cube
  • check data, calculations, formatting, and security of the database objects
  • create an action on a selected cube

Modifying Cubes

  • view and change cube dimension properties
  • view and change cube hierarchy properties
  • view and change cube attribute properties
  • add dimensions to cubes through Cube Designer
  • add measures to cubes through Cube Designer
  • add measure groups through Cube Designer
  • define translations in a cube
  • create perspectives for a cube

Defining Relationships in Cubes

  • implement many-to-many relationships in a cube
  • implement fact relationships in a cube
  • implement role-playing relationships in a cube

Practice: Creating Cubes

  • create and modify cubes in Cube Designers

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.