mplementing SQL Data Warehouse (SSIS) training course imparts core skills on the implementation of data warehouse platform for supporting a BI solution. Participants enrolled for this SQL Data Warehouse certification will learn to create the data warehouse with Microsoft SQL Server 2016 and Azure SQL Data Warehouse. The course also covers the Implementation of ETL using Integration Services, validation and cleansing of data using Data Quality Services and Master Data Services.

Implementing SQL Data Warehouse course is ideal for database professionals, BI developers, and professionals who are responsible for creating BI solutions in an enterprise environment.

SSIS is an ETL tool that performs various operations like loading the data based on need, executes data related calculations and defines a workflow for the process and tasks.

How will this Course help You

Upon Completion of this Course, you will accomplish following:

Understand the components of a data warehousing solution

Implement a logical and physical design to create a data warehouse

Implement a physical design for a data warehouse

Understand SSIS for implementing data flows

Create dynamic packages using parameters and variables
Implement Data Quality Services and Master Data Services
Implement custom components for extending SSIS
Implement Business Intelligence and its common scenarios in this SQL Data Warehouse certification training

Prerequesites

None