Microsoft SQL 2012 - New Features for Business Intelligence Developers — A 1-day course

contact usEnquire about this course

Course Synopsis

Please note that this course has been retired and is no longer available. Please see the Microsoft SQL Server 2012 page for courses currently available in this subject area.

This one-day instructor-led course teaches students how to implement updated Business Intelligence related features within Microsoft SQL Server 2012.

This course is intended for MCTS and MCITP SQL 2005/8 Business Intelligence developers.

Course Objectives

On completion of this training course, delegates should be able to:

Course Prerequisites

Before attending this course, students should have:


This course has been retired and is no longer available.

Outline Course Contents

Section 1: What's New in Analysis Services and PowerPivot

Overview of new developments in SQL Server Analysis Services and PowerPivot for the SQL Server 2012 release, along with guidance on when to use the tabular data model versus the traditional MDX model.

Section 2: BI Semantic Model Hands-on Lab

Learn how to import and develop a BI Semantic Model in Microsoft Visual Studio™.

Section 3: Introduction to SQL Server 2012 Reporting Services

Overview of the new features of SQL Server Reporting Services, including Power View, Self-Service Alerting, improved SharePoint Integrated Mode, and SQL Azure Reporting.

Section 4: Power View/Project Crescent Hands-on Lab

Get a technical introduction to Power View and walk through the process of how to build reports using Power View.

Section 5: What's New for MDS and DQS

Learn what's new for the next release of Master Data Services (MDS) and how it improves user experience for information workers. Also, see how the new Data Quality Services (DQS) can manage and clean data.

Section 6: Enterprise Information Management Hands-on Lab

Learn how to implement DQS in SQL Server 2012 and see the new features of SQL Server Integration Services.

Section 7: Database Development with SQL Server Developer Tools Code Name "Juneau"

Learn how this new developer experience in Visual Studio makes database development and deployment easy for SQL Server and Microsoft SQL Azure®.