20463D - Implementing a Data Warehouse with Microsoft SQL Server 2014

20463D - Implementing a Data Warehouse with Microsoft SQL Server 2014


This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


5 Days

Target Audience

This course is intended for 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 include:
Implementing a data warehouse.
Developing SSIS packages for data extraction, transformation, and loading.
Enforcing data integrity by using Master Data Services.
Cleansing data by using Data Quality Services.


Introduction to Data Warehousing
Data Warehouse Hardware Considerations
Designing and Implementing a Data Warehouse
Creating an ETL Solution with SSIS
Implementing Control Flow in an SSIS Package
Debugging and Troubleshooting SSIS Packages
Implementing an Incremental ETL Process
Enforcing Data Quality
Using Master Data Services
Extending SQL Server Integration Services
Deploying and Configuring SSIS Packages
Consuming Data in a Data Warehouse

A more comprehensive course outline is available in the Course Download section, to the right of this page.

Course Details

Course Ref:


Course Duration:

5 Days

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk