Course Details

Previous Page


Microsoft SQL Server: Implement and Configure Cubes


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

Microsoft SQL Server: Implement and Configure 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
  • 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
  • implement many-to-many relationships in a cube
  • implement fact relationships in a cube
  • implement role-playing relationships in a cube
  • create and modify cubes in Cube Designers
  • Course Number:
    md_idmr_a03_it_enus