Microsoft SQL Server: Implement and Configure Cubes

Course Overview

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

Learning Objectives

• 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