Microsoft SQL 2012 - New Features for Business Intelligence Developers — A 1-day course
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.
On completion of this training course, delegates should be able to:
- Describe key features of Microsoft SQL Server 2012 Business Intelligence Implement new features in Analysis Services, Reporting Services, Integration Services and additional enhanced products such as MDS and DQS
Before attending this course, students should have:
- Exposure to SQL Server 2005 / 2008 as Business Intelligence developers using :
- Reporting Services
- Integration Services
- Analysis Services
- Knowledge of related products such as PerformancePoint, ProClarity and Master Data Services would be beneficial
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®.