Course code: GOC633« Back

Microsoft SQL Server 2012 Analysis Services Tabular BI Semantic Model

In this course students will learn how to work with new features of SQL server 2012 in the field of Analysis services – tabular BI Semantic model. They will learn how to design, process and use the simplified version of OLAP data cubes. Tabular BI Semantic model is ideal for everyone who does not have their own solution of OLAP data cubes and who wants to deploy pilot project into the company which will check whether the multidimensional solution is the best for company users.

GOPAS Official Curriculum
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department ( or business department (

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 9 000 CZK included in course price 20
Brno2 9 000 CZK included in course price 20
Bratislava2 350,00 EUR included in course price 20

User intensity level

Who is the course for

  • The course aims at everyone who wants to bring a new perspective on company data and who does not have much experience with UDM model of OLAP data cubes. It is also aimed at participants of MOC 6234 course who already have OLAP solution for Analysis Services 2008 and who want to broaden their knowledge about Analysis services on MSSQL 2012.

After completing this course, students will be able :

  • To create PowerPivot structure which is essential for Tabular BISM
  • To work with hierarchies and key performance indicators (KPI)
  • To use Data Analysis Expression (DAX) language
  • To Deploy project to Sharepoint or Analysis services service
  • To customize the solution to the needs of users and managers
  • To decide what is more suitable for their solution – Tabular or Multidimensional BI Semantic model

Required skills

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of MS SQL Server 2005/2008
  • Basic knowledge of MS Excel

Teaching methods

Expert instruction with practical examples, computer practice


Printed presentation

Course Outline

Introduction to BI semantic model
  • BISM basics
  • Tabular vs. Multidimensional BISM
  • Changes against 2008 / 2008R2
  • Installation and configuration Tabular BISM
BI Semantic model solution
  • PowerPivot II for Excel
  • Data sources possibilities
  • Basic Tabular BI semantic mode
PowerPivot advanced topics
  • DAX terms – calculations YTD, QTD
  • Key Performance Indicators (KPI)
  • Hierarchy
  • Conversion of PowerPivot to Tabular BISM
  • Deployment to Analysis services service
  • Deployment to Sharepoint 2010

        Previous courses

        no preceding courses

        Next courses

        no following course
        Tištěné nebo elektronické studijní materiály GOPAS

        included in course price
        The prices are without VAT.