Providing Technology Training and Mentoring For Modern Technology Adoption
This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.
The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.
A working knowledge of SQL Server
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab 1: Course Overview
After completing this module, students will be able to:
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.
Lab 1: What is the Tabular Model?
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.
Lab 1: Working in Tabular
In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.
Lab 1: Understanding Loading Data From Different Sources
In this module, we will discuss two different languages; DAX and MDX. We will briefly explore MDX and its use with a tabular model, then we’ll cover DAX and walk-through how to use this powerful language.
Lab 1: Using DAX and MDX
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.
Lab 1: Building Data Models
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.
Lab 1: Excel PowerPivot and Tabular