Course details

Microsoft SQL Server: Implement and Configure Cubes

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

---

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

Expertise Level
Intermediate