Implementing a Data Warehouse with Microsoft SQL Server 2014 Databases 70-463

New York City

Implementing a Data Warehouse with Microsoft SQL Server 2014: Course 20463D

Course Objectives:

• 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.
• Deploy and Configure SSIS packages.
• Describe how BI solutions can consume data from the data warehouse.

Course Content:

Introduction to Data Warehousing

• Overview of Data Warehousing
• Considerations for a Data Warehouse Solution

Data Warehouse Hardware Considerations

• Considerations for building a Data Warehouse
• Data Warehouse Reference Architectures and Appliances

Designing and Implementing a Data Warehouse

• Logical Design for a Data Warehouse
• Physical design for a data warehouse

Creating an ETL Solution with SSIS

• Introduction to ETL with SSIS
• Exploring Data Sources
• Implementing Data Flow

Implementing Control Flow in an SSIS Package

• Introduction to Control Flow
• Creating Dynamic Packages
• Using Containers
• Managing Consistency

Debugging and Troubleshooting SSIS Packages

• Debugging an SSIS Package
• Logging SSIS Package Events
• Handling Errors in an SSIS Package

Implementing an Incremental ETL Process

• Introduction to Incremental ETL
• Extracting Modified Data
• Loading Modified data

Enforcing Data Quality

• Introduction to Data Quality
• Using Data Quality Services to Cleanse Data
• Using Data Quality Services to Match data

Using Master Data Services

• Master Data Services Concepts
• Implementing a Master Data Services Model
• Managing Master Data
• Creating a Master Data Hub

After completing this module, you will be able to:

• Include custom scripts in an SSIS package
• Describe how custom components can be used to extend SSIS

Deploying and Configuring SSIS Packages

• Overview of SSIS Deployment
• Deploying SSIS Projects
• Planning SSIS Package Execution

Consuming Data in a Data Warehouse

• Introduction to Business Intelligence
• Introduction to Reporting
• An Introduction to Data Analysis