Retired: Implementing A Data Warehouse With Microsoft SQL Server 2014 M20463 - Belgium

Implementing a Data Warehouse with Microsoft SQL Server Outline

Module 1: Introduction to Data Warehousing

• Overview of Data Warehousing

• Considerations for a Data Warehouse Solution

Lab: Exploring a Data Warehousing Solution

Module 2: Data Warehouse Hardware Considerations

• Selecting hardware

• Considerations for building a Data Warehouse

• Data Warehouse Reference Architectures and Appliances

Lab: Planning Data Warehouse Infrastructure

Module 3: Designing and Implementing a Data Warehouse

• Logical Design for a Data Warehouse

• Physical design for a Data Warehouse

Lab: Implementing a Data Warehouse Schema

Module 4: Creating an ETL Solution with SSIS

• Introduction to ETL with SSIS

• Exploring Data Sources

• Implementing Data Flow

Lab: Implementing Data Flow in an SSIS Package

Module 5: Implementing Control Flow in an SSIS Package

• Introduction to Control Flow

• Creating Dynamic Packages

• Using Containers

• Managing Consistency

Lab: Implementing Control Flow in an SSIS Package

Lab: Using Transactions and Checkpoints

Module 6: Debugging and Troubleshooting SSIS Packages

• Debugging an SSIS Package

• Logging SSIS Package Events

• Handling Errors in an SSIS Package

Lab: Debugging and Troubleshooting an SSIS Package

Module 7: Implementing an Incremental ETL Process

• Introduction to Incremental ETL

• Extracting Modified Data

• Loading Modified Data

Lab: Extracting Modified Data

Lab: Loading Incremental Changes

Module 8: Enforcing Data Quality

• Introduction to Microsoft SQL Server Data Quality Services (DQS)

• Using Data Quality Services to Cleanse Data

• Using Data Quality Services to Match Data

Lab: Cleansing Data

Lab: De-duplicating data

Module 9: Using Master Data Services

• Master Data Services Concepts

• Implementing a Master Data Services Model

• Managing Master Data

• Creating a Master Data Hub

Lab: Implementing Master Data Services

Module 10: Extending SQL Server Integration Services

• Using Scripts in SSIS

• Using Custom Components in SSIS

Lab: Using Custom Components and Scripts

Module 11: Deploying and Configuring SSIS Packages

• Overview of SSIS Deployment

• Deploying SSIS Projects

• Planning and Monitoring SSIS Package Execution

Lab: Deploying and Configuring SSIS Packages

Module 12: Consuming Data in a Data Warehouse

• Introduction to Business Intelligence

• Introduction to Reporting

• An Introduction to Data Analysis

Lab: Using Business Intelligence Tools