Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources

This course is included in our On-demand training solution.


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



Expected Duration

120 min.

Course Objectives

Course Introduction

Understanding the Logical Architecture

  • describe the logical architecture
  • Understanding the Cube Architecture

  • describe the architecture of the cube, including what it contains
  • Designing a Schema for a Cube Architecture

  • identify the different types of schemas that are used for a cube
  • Understanding the Different Data Sources

  • describe the different types of data sources
  • Creating a Data Source

  • create a data source
  • Creating a Data Source View

  • create a data source view
  • Creating a New Project Using a Template in SSDT

  • create a new project in SQL Server Data Tools, or SSDT, using a template
  • Using an Existing Database to Create a New Project

  • create a new project in SQL Server Data Tools, or SSDT, using an existing database
  • Exploring Project Folders, File Types, and Templates

  • identify the folders, file types, and templates used in a project
  • Understanding Dimensions in a Multidimensional Model

  • describe a dimension and how it is used in a multidimensional model
  • Understanding Measures in a Multidimensional Model

  • describe what measures and measure groups are in a multidimensional model
  • Identifying Measures and Aggregation Behavior

  • describe measures and aggregation behavior
  • Understanding Many-to-Many Relationships

  • describe many-to-many relationships in Analysis Services
  • Understanding Fact Relationships

  • describe fact relationships in Analysis Services
  • Understanding Referenced Relationships

  • describe referenced relationships in Analysis Services
  • Designing Patterns for Business Facts and Dimensions

  • design patterns for representing business facts and dimensions
  • Designing Dimensions to Support Related Measure Groups

  • design dimensions to support multiple related measure groups
  • Identifying Attributes for Dimensions

  • identify the attributes for dimensions
  • Building Hierarchies

  • describe what user-defined hierarchies are
  • Defining Granularity of Dimension Relationships

  • define granularity of dimension relationships
  • Exercise: Designing Multidimensional Objects