Introduction to Data Warehousing

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

Data Warehouse Hardware

• 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 Source Data
• 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

Incorporating Data from the Cloud into a Data Warehouse

• Overview of Cloud Data Sources
• SQL Server Database
• The Windows Azure Marketplace

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

• Introduction to Master Data Services
• Implementing a Master Data Services Model
• Using the Master Data Services Add-in for Excel

Extending SQL Server Integration Services

• Using Custom Components in SSIS
• Using Scripts in 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
• Introduction to Data Analysis