Microsoft SQL Server: Implement and Configure Cubes

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
107 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.