Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-40009 - Updating your Business Intelligence Skills to Microsoft SQL Server 2012

This three-day instructor-led course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.

Click here to print this page »


Before attending this course, students must have:
  • Experience of creating database solutions in SQL Server, including basic Transact-SQL programming.
  • Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting.

Detailed Class Syllabus

Module 1: Introduction to SQL Server 2012 for Business Intelligence

Overview of SQL Server 2012 for Business Intelligence
SQL Server 2012 for Enterprise Integration Management
SQL Server 2012 for Data Warehousing
SQL Server 2012 for Data Analysis and Reporting

Module 2: New and Enhanced Features in SQL Server Integration Services

Using the CDC Control Task for Incremental Data Loads
Deploying and Operating SSIS Packages

Module 3: Data Quality Services

Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data

Module 4: Master Data Services

Introduction to Master Data Services
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub

Module 5: SQL Server 2012 Reporting Services

Reporting Services Overview
Reporting Services and Microsoft SharePoint Server
Introduction to Data Alerts

Module 6: Creating Tabular Data Models with PowerPivot

Introduction to Tabular Data Models and PowerPivot Technologies
Using PowerPivot
Using DAX in a PowerPivot Data Model

Module 7: Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Model Projects
Developing an Analysis Services Tabular Data Model

Module 8: Creating Data Visualizations with Power View

Introduction to Power View
Visualizing Data with Power View

Module 9: Using Cloud Technologies in a BI Solution

Overview of Cloud Data Sources
SQL Azure
SQL Azure Reporting Services
The Windows Azure Marketplace DataMarket