Lesson 1: Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for Building a Data Warehouse
- Lab: Exploring a Data Warehousing Solution
Lesson 2: Planning Data Warehouse Infrastructure
- Consideration for Building a Data Warehouse
- Planning Data Warehouse Hardware
Lesson 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
Lesson 4: Creating an ETL Solution with SSIS
- Introduction to ETL with SSIS
- Exploring Source Data
- Implementing Data Flow
- Lab : Implementing Data Flow in a SSIS Package
- Exploring Data Sources
- Transferring Data by Using a Data Flow Task
- Transformations in a Data Flow
Lesson 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
Lesson 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
Lesson 7: Implementing a Data Extraction Solution
Planning Data Extraction
- Extracting Modified Data
- Using a Date time Column
- Lab : Extracting Modified Data
- Using Change Data Capture
- Using the CDC Control Task
- Using Change Tracking
Lesson 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
- Using a Lookup Transformation to Insert or Update Dimension Data
- Implementing a Slowly Changing Dimension
- Using the MERGE Statement
Lesson 9: Enforcing Data Quality
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
- Lab : Cleansing Data
- Creating a DQS Knowledge Base
- Using a DQS Project to Cleanse Data
- Using DQS in an SSIS Package
Lesson 10: Using Master Data Services
- Introduction to Master Data Services
- Implementing a Master Data Services Model
- Managing Master Data
- 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
Lesson 11: Extending SQL Server Integration Services
- Using Custom Components in SSIS
- Using Scripts in SSIS
- Lab : Using Custom Components and Scripts
- Using a Script Task
Lesson 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
Lesson 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