Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources

Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources

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

Overview/Description
SQL Server Analysis Services (SSAS) multidimensional models contain objects called cubes, dimensions, and measures, which determine the data and how it is aggregated for the users to analyze. A good understanding of the multidimensional model architecture is required in order to design and implement these objects properly. Data sources are required by the models to connect to and gain access to the data required for the model. This course will discuss the logical and cube architecture and how to create data sources. It will also discuss how to design the multimensional objects. This course is one in a series of Skillsoft courses to help leaners 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 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources

start the course

describe the logical architecture

describe the architecture of the cube, including what it contains

identify the different types of schemas that are used for a cube

describe the different types of data sources

create a data source

create a data source view

create a new project in SQL Server Data Tools, or SSDT, using a template

create a new project in SQL Server Data Tools, or SSDT, using an existing database

identify the folders, file types, and templates used in a project

describe a dimension and how it is used in a multidimensional model

describe what measures and measure groups are in a multidimensional model

describe measures and aggregation behavior

describe many-to-many relationships in Analysis Services

describe fact relationships in Analysis Services

describe referenced relationships in Analysis Services

design patterns for representing business facts and dimensions

design dimensions to support multiple related measure groups

identify the attributes for dimensions

describe what user-defined hierarchies are

define granularity of dimension relationships

describe and design multidimensional models, including dimensions, cubes, and measures

Course Number:
md_idmr_a02_it_enus

Expertise Level
Intermediate