Overview of Data Warehousing
Requirements for a Data Warehouse Solution
Explore the Extraction-Transformation-Load (ETL) process
Explore a Data Warehouse

Practical Workshops:

• Exploring a data warehousing solution
• Describe the key elements of a data warehousing solution
• Describe the main considerations for a data warehousing project

Data Warehouse Infrastructure Requirements
Planning Data Warehouse Hardware

Practical Workshops:

• Planning Data Warehouse Infrastructure
• Describe key considerations for BI infrastructure
• Data warehouse infrastructure plan

Warehouse
Design Overview Designing Dimension
Tables
Designing Fact Tables Designing the Physical Structure of a Data Warehouse

Practical workshops:

• Mse implementation of a data warehouse schema
• Describe a process for designing a dimensional model for a data warehouse
• Design and implement efficient physical data structures for a data warehouse

Introduction to ETL with SSIS
Explore Data Sources
Implement Data Flows

Practical Workshops: The implementation of data flows in an SSIS package

Introduce control flow
Create dynamic packages
Use containers
Manage consistency

Practical Workshops: Implementation of control flow in an SSIS package – Transactions and Checkpoints

Debug an SSIS package
Record SSIS package events
Take errors into account in an SSIS package

Practical Workshops: Debugging and Troubleshooting an SSIS Package

Plan data extracts
Extraction of changed data

Practical workshops:

• Extraction of modified data
• Loading of incremental modifications

Plan data loads
Use SSIS for incremental loads
Use Transact-SQL load techniques

Introduction to Data Quality

Use Data Quality Services to Cleanse Data