Download PDF
of this course

MS55163 - Data Modeling with SQL BISM Tabular Mode (MS55163)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 2 Days

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

Who Should Attend

  • The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.

Course Certifications

This course is part of the following Certifications:

Prerequisites

  • A working knowledge of SQL Server

Course Objectives

After completing this course, 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.

  • Understand and utilize projects.

  • Understand and utilize importing.

  • Understand and utilize loading data.

  • Understand and utilize examining views.

  • Understand and utilize deployment.

  • Understand and utilize data sources.

  • Understand and utilize data credentials.

  • Understand and utilize SQL as a source.

  • Understand and utilize Excel as a source.

  • Understand and utilize Flat Files as a source.

  • Understand and utilize Azure as a source.

  • Understand and utilize SharePoint as a source.

  • Understand and utilize sorting during load.

  • Understand querying with MDX.

  • Understand and utilize DAX syntax.

  • Understand and utilize DAX data types and operator overloading.

  • Understand and utilize DAX operators.

  • Understand and utilize DAX values.

  • Understand and utilize measures.

  • Understand and utilize calculated columns.

  • Understand evaluation contexts.

  • Understand and utilize date calculations.

  • Understand and utilize importing related tables.

  • Understand and utilize creating relationships.

  • Understand and utilize hierarchies.

  • Understand Direct Query.

  • Understand and utilize KPIs.

  • Understand drillthrough.

  • Understand perspectives.

  • Understand and utilize PowerPivot.

  • Understand and utilize Pivot Tables.

  • Understand and utilize Power View.

Course Content

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 will be discussing

Lab : Overview

  • None

After completing this module , students will be able to :

  • Successfull log into their virtual machine
  • Have a full understanding of what the course intends to cover

 

Module 2 : What it 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 als significant differences.In this module , we discuss feature comparisons and explain each approach , then we will 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 utilizie SQL Server Data Tools for Tabular 

Course ID: MS55163


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register