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.
At the end of the program, the participants will be able to :
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:
This program is 5 days of intensive training class.
This course requires that you meet the following prerequisites:
At the end of the program, the participants will be assessed with 2 hours of Implementing a Data Warehouse with Microsoft® SQL Server® 2014Exam.
-
Lab : Exploring a Data Warehousing Solution
Lab : Planning Data Warehouse Infrastructure
Lab : Implementing a Data Warehouse Schema
Lab : Implementing Data Flow in an SSIS Package
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
Lab : Debugging and Troubleshooting an SSIS Package
Lab : Loading Incremental Changes
Lab : Extracting Modified Data
Lab : Cleansing Data
Lab : De-duplicating data
Lab : Implementing Master Data Services
Lab : Using Custom Components and Scripts
Lab : Deploying and Configuring SSIS Packages
Lab : Using Business Intelligence Tools