• Overview of Data Warehousing
• Considerations for a Data Warehouse Solution
• Lab : Exploring a Data Warehousing Solution
• Exploring Data Sources
• Exploring and ETL Process
• Exploring a Data Warehouse

2. Planning Data Warehouse Infrastructure

• Considerations for Data Warehouse Infrastructure
• Planning Data Warehouse Hardware
• Lab : Planning Data Warehouse Infrastructure
• Planning Data Warehouse Hardware

3. Designing and Implementing a Data Warehouse

• Data Warehouse Design Overview
• Designing Dimension Tables
• Designing Fact Tables
• Physical Design for a Data Warehouse
• Lab : Implementing a Data Warehouse
• Implement a Star Schema
• Implement a Snowflake Schema
• Implement a Time Dimension

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
• Exploring Data Sources
• Transferring Data by Using a Data Flow Task
• Using Transformations in a Data Flow

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
• Using Tasks and Precedence in a Control Flow
• Using Variables and Parameters
• Using Containers
• Lab : Using Transactions and Checkpoints
• Using Transactions
• Using Checkpoints

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
• Debugging an SSIS Package
• Logging SSIS Package Execution
• Implementing an Event Handler
• Handling Errors in a Data Flow

7. Implementing a Data Extraction Solution

• Planning Data Extraction
• Extracting Modified Data
• Lab : Extracting Modified Data
• Using a Datetime Column
• Using Change Data Capture
• Using the CDC Control Task
• Using Change Tracking

8 . Loading Data into a Data Warehouse

• Planning Data Loads
• Using SSIS for Incremental Loads
• Using Transact-SQL Loading Techniques
• Lab : Loading a Data Warehouse
• Loading Data from CDC Output Tables
• Using a Lookup Transformation to Insert or Update Dimension Data
• Implementing a Slowly Changing Dimension
• Using the MERGE Statement

9. Enforcing Data Quality

• Introduction to Data Quality
• Using Data Quality Services to Cleanse Data
• Using Data Quality Services to Cleanse Data
• Lab : Cleansing Data
• Creating a DQS Knowledge Base
• Using a DQS Project to Cleanse Data
• Using DQS in an SSIS Package

10. Master Data Services

• Introduction to Master Data Services
• Implementing a Master Data Services Model
• Managing Master Data
• Creating a Master Data Hub
• Lab : Implementing Master Data Services
• Creating a Master Data Services Model
• Using the Master Data Services Add-in for Excel
• Enforcing Business Rules
• Loading Data Into a Model
• Consuming Master Data Services Data

11. Extending SQL Server Integration Services

• Using Scripts in SSIS
• Using Custom Components in SSIS
• Lab : Using Custom Scripts
• Using a Script Task

12. Deploying and Configuring SSIS Packages

• Overview of SSIS Deployment
• Deploying SSIS Projects
• Planning SSIS Package Execution
• Lab : Deploying and Configuring SSIS Packages
• Creating an SSIS Catalog
• Deploying an SSIS Project
• Running an SSIS Package in SQL Server Management Studio
• Scheduling SSIS Packages with SQL Server Agent

13.Consuming Data in a Data Warehouse

• Introduction to Business Intelligence
• Enterprise Business Intelligence
• Self-Service BI and Big Data
• Lab : Using a Data Warehouse
• Exploring an Enterprise BI Solution
• Exploring a Self-Service BI Solution