
IMPLEMENTING DATA WAREHOUSE WITH MICROSOFT SQL SERVER® 2014
Modular Course (Select your Modules)
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.
Datawarehouse ( 1 day)
• Introduction to Data Warehousing
• Data Warehouse Hardware Considerations
• Designing and Implementing a Data Warehouse
ETL Fundamental (1.5 days)
• 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
ETL Advanced Topics & Deployment (2 days)
Additional Topic (0.5 day)
• Consuming Data in a Data Warehouse



