Introduction to Data Warehouse and SSIS for Beginners

About Introduction to Data Warehouse and SSIS for Beginners

This course is a beginners course that will show you how to implement enterprise data warehouse solution using Microsoft SQL Server ,Microsoft SQL Server Integration Services SSIS and Microsoft SQL Server Data Tools -SSDT. You will learn how to implement ETL ( Extract,Transform, Load) process using SQL Server Integration services . Students will learn how to :

Deploy and Configure SSIS packages.

Download and installing SQL Server 2014

Download and attaching Adventureworks2014 database

Download and installing SSDT

Download and installing Visual studio

Describe data warehouse concepts and architecture considerations.

Select an appropriate hardware platform for a data warehouse.

Design and implement a data warehouse.

Implement Data Flow in an SSIS Package.

Implement Control Flow in an SSIS Package.

Debug and Troubleshoot SSIS packages.

Implement an ETL solution that supports incremental data extraction.

Implement an ETL solution that supports incremental data loading.

Implement data cleansing by using Microsoft Data Quality Services.

Implement Master Data Services to enforce data integrity.

Extend SSIS with custom scripts and components.

Databases vs. Data warehouses

Choose between star and snowflake design schemas

Explore source data

Implement data flow

Debug an SSIS package

Extract and load modified data

Enforce data quality

Consume data in a data warehouse After completing this course you will be able to :

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