Data Warehouse Implementation with 2012

Implementing a Data Warehouse with Microsoft SQL Server 2012

Course Code: 10777

Course Duration: 5 Days

Course Cost: $3,375.00 ex. GST


This five-day instructor-led course describes how to implement a BI platform to support information worker analytics. Participants will learn how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for the exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.

Book SQL Server Training Implementing a Data Warehouse with Microsoft SQL Server 2012 Enquire

Live Schedule


No scheduled public courses for the next 120 days.


Who Should Attend

The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities will include:

  • Implementing a data warehouse
  • Developing SSIS packages for data extraction, transfer, transformation and loading
  • Enforcing data integrity using Master Data Services
  • Cleansing data using Data Quality Services

Course Objectives

After completing this course, particpants will be able to:

  • Describe data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement Data Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Implement an SSIS solution that supports incremental DW loads and changing data
  • Integrate cloud data into a data warehouse ecosystem infrastructure
  • Implement data cleansing by using Microsoft Data Quality Services
  • Implement Master Data Services to enforce data integrity at source
  • Extend SSIS with custom scripts and components
  • Deploy and Configure SSIS packages
  • Describe how information workers can consume data from the data warehouse

Course Prerequisites

In addition to their professional experience,participants should have technical knowledge equivalent to the following course:

  • 10774A: Writing Queries with Microsoft SQL Server Transact-SQL 2012