sales@dynamicsedge.com
202-410-6400

About this course

This 5-day instructor led 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® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Who Should Attend:

The primary audience for this course are 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.

After completing this course, students will be able to:

Course Outline

Module 1: Introduction to Data Warehousing

Describe data warehouse concepts and architecture considerations.

Lessons

Lab : Exploring a Data Warehouse Solution

Module 2: Planning Data Warehouse Infrastructure

This module describes the main hardware considerations for building a data warehouse.

Lessons

Lab : Planning Data Warehouse Infrastructure

Module 3: Designing and Implementing a Data Warehouse

This module describes how you go about designing and implementing a schema for a data warehouse.

Lessons

Lab : Implementing a Data Warehouse Schema

Module 4: Columnstore Indexes

This module introduces Columnstore Indexes.

Lessons

Lab : Using Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse

This module describes Azure SQL Data Warehouses and how to implement them.

Lessons

Lab : Implementing an Azure SQL Data Warehouse

Module 6: Creating an ETL Solution

At the end of this module you will be able to implement data flow in a SSIS package.

Lessons

Lab : Implementing Data Flow in an SSIS Package

Module 7: Implementing Control Flow in an SSIS Package

This module describes implementing control flow in an SSIS package.

Lessons

Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints

Module 8: Debugging and Troubleshooting SSIS Packages

This module describes how to debug and troubleshoot SSIS packages.

Lessons

Lab : Debugging and Troubleshooting an SSIS Package

Module 9: Implementing an Incremental ETL Process

This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.

Lessons

Lab : Extracting Modified Data
Lab : Loading Incremental Changes

Module 10: Enforcing Data Quality

This module describes how to implement data cleansing by using Microsoft Data Quality services.

Lessons

Lab : Cleansing Data

Module 11: Using Master Data Services

This module describes how to implement master data services to enforce data integrity at source.

Lessons

Lab : Implementing Master Data Services

Module 12: Extending SQL Server Integration Services (SSIS)

This module describes how to extend SSIS with custom scripts and components.

Lessons

Lab : Using Scripts and Custom Components

Module 13: Deploying and Configuring SSIS Packages

This module describes how to deploy and configure SSIS packages.

Lessons

Lab : Deploying and Configuring SSIS Packages

Module 14: Consuming Data in a Data Warehouse

This module describes how to debug and troubleshoot SSIS packages.

Lessons

Lab : Using Business Intelligence Tools

Prerequisites

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
https://www.dynamicsedge.com/
sales@dynamicsedge.com
Solutions
Company
202 Church Street S.E. , Suite 203 Leesburg, VA 20175
202-410-6400
800-453-596 (Toll Free)
sales@dynamicsedge.com