Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources

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

Prerequisite
None

Expected Duration
123 minutes

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.

Objective

Multidimensional Models

  • 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

Creating Projects

  • 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

Designing Dimensions, Cubes, and Measures

  • 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

Practice: Design Multidimensional Models

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.