SSAS Contents

1. A brief studay on Analysis Services
    - OLTP,DWH
    - OLAP TYPES
    - SSAS Architecture
    - Dimension Tables
    - Fact tables
    - Cubes
    - Analysis Services Tools

 2. Cube Design Storage and Concepts
    - Dimensions
    - Measure groups
    - Creating Simple Calculations
    - Aggregations and Hierarchies
    - Dimensions Relationships
    - Transactions
    - Perspectives

 3. Advanced Cube Design Process
    - MDX introduction and Queries
    - Implementing KPI
    - Implementing Actions
    - Using Write back

 4. SSAS Administration
    - Apply Security Roles
    - Levels of Security
    - VLDB with partitioning
    - OLAP Processing
    - Monitoring Cube activity
    - Deployment and Scheduling
    - Planning for Disaster Recovery
    - Performance Tuning SSAS

5. Advanced SSAS
    - Using multiple fact tables
    - Modeling intermediate fact tables
    - Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
    - Modeling changing dimensions – Dimension Intelligence w/ Wizard
    - Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence