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 »

Prerequisites


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