Overview

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.

Duration

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.

Topics

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