New BI Features of SQL Server 2012


There have been a lot of changes in SQL Server 2012 in terms of Business Intelligence , including new licensing model and a new Business Intelligence edition. More options,  however, mean a more complex solution choice, as the analysis server itself can work in three different modes. The goal of the training is to familiarize BI developers with the new BI semantic model (BISM), assist them with the right choice of appropriate analysis solutions, and with efficient use of changes and novelties in the older components of BI solutions. Upon the completion of the course, an experienced developer should, as a result, be able to use the new capabilities of SQL Server 2012 in the scope of BI.


  • Course level: 400
  • Start date: as required
  • Duration time: 2 days

Price: 2800 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer


The course has been designed for BI developers, as well as analysts who want to become familiar with the new BI components of SQL Server 2012.


The basic training is comprised of 10 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants.  We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered during the course.
Our trainings are unique also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.


Duration: Level:
Module 1

Changes in SQL 2012 Licensing and Editions
  • New Licensing Model for SQL Server
  • SQL Server 2012 Editions
  • Which Edition Do I Choose for our BI Solution - Business Intelligence or Enterprise?

30 minutes 300
Module 2

Changes in SQL Server 2012 Engine for Data Warehousing
  • Columnstore Indexes
  • Optimization of Queries for Block-Oriented Processing

60 minutes 400
Module 3

ETL and Integration Services Novelties in SQL Server 2012
  • The New Designers
  • Special Tasks for Change Data Capture Mechanism
  • SSIS Catalog and Database
  • SSIS Monitoring and Management

90 minutes 400
Module 4

Business Intelligence Semantic Model (BISM)
  • New BI Semantic Model
  • Differences between Tabular and Multidimensional Model
  • Comparison of DAX and MDX Languages

60 minutes 400
Module 5

SQL Server Analysis Services
  • Changes in Multidimensional Model
  • New Tabular Work Model
  • Implementation of and Managing Tabular Model

90 minutes 400
Module 6

  • New Configuration Tool
  • Changes in PowerPivot
  • New Extensions of DAX
  • Hierarchies
  • Key Performance Indicators

90 minutes 400
Module 7

Changes in Master Data Management
  • Changes in Master Data Services
  • Master Data Services Add-In for Excel

60 minutes 400
Module 8

Data Quality Services
  • Business Quality and Integrity Of Data
  • Introduction to Data Quality Services
  • DQS Components
  • Knowledge Bases
  • Data Quality Services in MDS
  • Data Quality Services in SSIS

90 minutes 300
Module 9

Reporting Services
  • Changes in Reports
  • New Architecture and Installation of Reporting Services in Sharepoint Environment
  • Report Alerts

60 minutes 400
Module 10

Data Visualization in PowerView
  • PowerView Architecture
  • PowerView Requirements
  • BISM Data Sources Data Visualization in PowerView

90 minutes 300


Ask Question