Implementing A Data Warehouse With Microsoft SQL Server VC M20463

Introduction to Data Warehousing: Overview of Data Warehousing - Considerations for a Data Warehouse Solution

Planning Data Warehouse Infrastructure: Considerations for Data Warehouse Infrastructure - Planning Data Warehouse Hardware

Designing and Implementing a Data Warehouse: Data Warehouse Design Overview - Designing Dimension Tables - Designing Fact Tables - Physical Design for a Data Warehouse

Creating an ETL Solution with SSIS: Introduction to ETL with SSIS - Exploring Data Sources - 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 a Data Extraction Solution: Planning Data Extraction - Extracting Modified Data

Loading Data into a Data Warehouse: Planning Data Loads - Using SSIS for Incremental Loads - Using Transact-SQL Loading Techniques

Enforcing Data Quality: Introduction to Data Quality - Using Data Quality Services to Cleanse Data - Using Data Quality Services to Cleanse Data

Master Data Services: Introduction to Master Data Services - Implementing a Master Data Services Model - Managing Master Data - Creating a Master Data Hub

Extending SQL Server Integration Services: Using Scripts in SSIS - Using Custom Components 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

Enterprise Business Intelligence

Self-Service BI and Big Data