Introduction to Data Warehousing
o Overview of Data Warehousing
o Considerations for a Data Warehouse Solution
Data Warehouse Hardware
o Considerations for Building a Data Warehouse
o Data Warehouse Reference Architectures and Appliances
Designing and Implementing a Data Warehouse
o Logical Design for a Data Warehouse
o Physical Design for a Data Warehouse
Creating an ETL Solution with SSIS
o Introduction to ETL with SSIS
o Exploring Source Data
o Implementing Data Flow
Implementing Control Flow in an SSIS Package
o Introduction to Control Flow
o Creating Dynamic Packages
o Using Containers
o Managing Consistency
Debugging and Troubleshooting SSIS Packages
o Debugging an SSIS Package
o Logging SSIS Package Events
o Handling Errors in an SSIS Package
Implementing an Incremental ETL Process
o Introduction to Incremental ETL
o Extracting Modified Data
o Loading Modified Data
Incorporating Data from the Cloud into a Data Warehouse
o Overview of Cloud Data Sources
o SQL Server Database
o The Windows Azure Marketplace
Enforcing Data Quality
o Introduction to Data Quality
o Using Data Quality Services to Cleanse Data
o Using Data Quality Services to Match Data
Using Master Data Services
o Introduction to Master Data Services
o Implementing a Master Data Services Model
o Using the Master Data Services Add-in for Excel
Extending SQL Server Integration Services
o Using Custom Components in SSIS
o Using Scripts in SSIS
Deploying and Configuring SSIS Packages
o Overview of SSIS Deployment
o Deploying SSIS Projects
o Planning SSIS Package Execution
Consuming Data in a Data Warehouse
o Introduction to Business Intelligence
o Introduction to Reporting
o Introduction to Data Analysis
