The course introduces Learners to SQL BISM (Business Intelligence Semantic Model) Tabular model, DAX and data modelling.
Course Price : $1150 Per Participant
The course introduces Learners to SQL BISM (Business Intelligence Semantic Model) Tabular model, DAX and data modeling.
This training is designed based on the objectives of the course variant 55163A.
Microsoft Courses
Years of Experience
Global Learners
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab: 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: What is the Tabular Model?
After completing this module, students will be able to:
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.
Lab: Working in Tabular
After completing this module, students will be able to:
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: Understanding Loading Data From Different Sources
After completing this module, students will be able to:
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: Using DAX and MDX
After completing this module, students will be able to:
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.
Lab: Building Data Models
After completing this module, students will be able to:
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.
Lab: Excel PowerPivot and Tabular
After completing this module, students will be able to:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.