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 multidimensional objects. 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.
Learning Objectives
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