Modular Course (Select your Modules)

IMPLEMENTING 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.

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

ETL Advanced Topics & Deployment (2 days)

• Enforcing Data Quality

• Using Master Data Services

• Extending SQL Server Integration Services

• Deploying and Configuring SSIS Packages

Additional Topic (0.5 day)

• Consuming Data in a Data Warehouse