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