Course Outline

1. ETL Trends
   • ETL Competitors
   • Industry Trends
   • ETL vs. Data Delivery
   • What to look for in ETL
     
     
2. Data Architecture
   • Business Logical Models
   • Data Warehouse Model
   • Dimensional Model
   • Star Schema
   • Target Schemas
   • MS Data Transformation Services Lab
     
     
3. Architecture Strategies
   • Atomic Level
   • Independent Data Marts
   • Atomic Level with Dependent Data Marts
   • Syncsort Lab
     
     
4. Understanding ETL
   • Terms
   • The Transformation Explosion
   • Components of Extraction & Transformation
   • Transformation Component Chain
   • An Architectural View
   • Transformation Segments
   • Transformation Types
   • SAS ETL Lab
     
     
5. Source Systems Analysis
   • Source System Identification
   • Source System Assessment
   • DFD-Pro Data Flow Diagramming Lab
     
     
6. Data Quality
   • Data Quality Indicators
   • Data Quality Surveys
   • Cleansing Strategies
   • Ascential DataStage Lab
     
     
7. Transformation Strategies
   • Warehouse Refresh Strategies
   • Formal Acquisition Documentation
     
     

     Course Description>