SQL Server 2012 for Business Intelligence New Features Training


Course Duration: 5 Day(s)


SQL Server 2012 provides the foundation to the cloud-ready information platform and will help customers unlock breakthrough insights across the organization and quickly build solutions that extend data across on-premises and public cloud backed by capabilities for mission critical confidence.
Participants will learn new features for Business Intelligence in SQL Server 2012.


  • Operating System Support and Prerequisites
  • SSIS Enhancements
  • Visual Studio 2010
  • SSIS Designer Enhancements
  • Data Flow Enhancements
  • Introduction to Parameters
  • Introduction to Environments
  • New Deployment options
  • Management Enhancements
  • Migrating SSIS Projects to Denali
  • SSAS Enhancements
  • Server Instance and Server Monitoring
  • Tabular Modeling
  • Multidimensional Modeling
  • PowerPivot for Excel
  • PowerPivot for SharePoint
  • Programmability
  • SSRS Enhancements
  • Master Data Services – Introduction
  • Data Quality Services – Introduction

Who Should Attend

Participants attending this course must have development experience on:

  • Concepts of Relational Database Design & Implementation
  • Working Experience/Knowledge of SQL and TSQL.
  •  Working Experience/Knowledge of SSIS, SSAS, SSRS
  •  Working Experience/Knowledge of PowerPivot
  •  Working Experience/Knowledge of SharePoint 2010 Basics

Target Audience



Chitra Iyer

Chitra has been delivering exceptionally well in her professional capacity as consultant and trainer.  She has been successful at adopting new technologies for tackling IT challenges which makes her forefront in driving new technology adoption cycle amongst the growing developer base in India.

An excellent communicator, Chitra perfectly fits the bill in handling clients whilst offering technological solutions them by understanding the key requirements of the client expectations.  

Mr. Kedar Ghanekar

Definitely an asset to Synergetics, Kedar has played an in dominatable role in delivering training engagements as well as enterprise solutions. Over the years, Kedar has garnered immense training skills which are put to use along with his knowledge on beta technologies. He has been able to comply to the toughest of software challenges by applying beta technologies in real time scenarios.