Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
Lab : Course Overview
After completing this module, students will be able to:
- Successfully log into their virtual machine.
- Have a full understanding of what the course intends to cover.
Module 2: What is the Tabular Model
SQL Server Analysis Services (SSAS) provides two different approaches for data modeling: multidimensional and tabular. While there is substantial overlap between them, there are also significant differences. In this module, we discuss feature comparisons and explain each approach, then we’ll dive deeper into the tabular model as that is the focus for this course.
Lessons
- Analysis Services Installation and Architecture: One Product, Two Models
- Version Changes: SQL Server Analysis Services
- Important Terms
- SQL Server Data Tools for Tabular
Lab : What is the Tabular Model
- SQL Server Data Tools for Tabular
After completing this module, students will be able to:
- Understand Analysis Services Installation and Architecture: One Product, Two Models.
- Understand version changes: SQL Server Analysis Services.
- Understand important terms.
- Understand and utilize SQL Server Data Tools for Tabular.