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