Course Outline

1. Overview
   • Common Terms
   • Analytical Spectrum
   • Dimensional Spectrum
   • OLAP vs ROLAP
   • Market Segments
   • OLAP Leaders
   • Common Applications
   • MS Analytics Lab
     
     
2. The BI Organization
   • A Conceptual Diagram
   • Data Structure Dependency
   • Enterprise Deployment
   • Microstrategy Enterprise Server Lab
     
     
3. Building An OLAP Solution
   • Why Model?
   • Business Question Components
   • Using Line Segments
   • Dimensional Diagrams
   • A Tuple Cell
   • Hierarchies
   • Metric Maps
   • Source-to-target Maps
   • Data Flow Diagrams
   • Other Modeling Considerations
   • DFD-Pro Data Flow Diagramming Lab
     
     
4. Working With Dimensions
   • What Makes a Good Dimension
   • Choosing The Right Dimensions
   • Working With Large Dimensions
     
     
5. Working With Facts
   • Fact Rules
   • Different Fact Values
   • Different Fact Tables
   • Cognos Transformer and PowerPlay Lab
     
     
6. OLAP Performance
   • Performance Considerations
   • Dealing with the Inflation Factor
   • Calculating the Inflation Factor
   • Avoid the Inflation Factor
   • The Challenge with Sparsity
   • Sparsity & Derived Data
   • Storing Multidimensional Data
   • Pre-Query vs. Port-Query Calculation
   • Hyperion Essbase Lab
     
     
7. Exploiting OLAP, ROLAP & Stars
   • Applying the Dimensional Diagram
   • Exploiting the Star Schema
   • Staging Data in a Star
     
     
8. The Future Of OLAP
   • The OLAP-Aware Database
   • OLAP Web Services

     Course Description>