1. Installation
   1. Cannot upgrade/change b/w modes
   2. Modes
      1. UDM (Multidimenional/Data Mining)
      2. BISM (Tabular)
      3. PowerPivot for Sharepoint
      4. Use Vertipaq data engine
   3. One mode per SSAS instances
2. Benefits
   1. Fast in memory by default/Vertipaq
   2. Connect with many data sources
   3. Overcome PowerPivot memory limitation
   4. Role-based security
   5. Integrates with Powerview
3. Query Modes
   1. In memory (vs MOLAP)
      1. Technologies
         1. Column Store
         2. In-Memory
         3. Compression
         4. All data copied
      2. Limits
         1. Memory required
         2. Processor required
         3. Out of date data
   2. DirectQuery (vs ROLAP)
      1. Single relational data source
      2. one partition only
      3. Restricted DAX functions
      4. Restricted client tools: SSRS & PowerView
      5. No Row Level security
      6. No Calculated Columns
      7. Only be queried by using DAX (Not support Excel Pivot Client)
      8. Real Time analysis
      9. No processing
   3. DirectQuery with In-Memory
      1. Occasional processed in memory data
      2. PowerView (or DAX issuing Client Tool)
   4. In-Memory with DIrectQuery
      1. Occasional real-time queries required
      2. Mainly using Excel
   5. Solution must conform to DirectQuery design
4. Client Software
   1. SSRS
   2. Excel
   3. PowerPivot
   4. PowerView
   5. Pyramid Analytics
5. Partitions
   1. In-memory
      1. multiple
   2. DirectQuery
      1. One Tabular Model Partition only
      2. Utilise Partitioning and ColumnStore Index technology on SQL Server 2012
6. Process
   1. Parallel Processing
   2. Database
      1. Process Default
      2. Process Full
      3. Process Clear
      4. Process Recalc
   3. Table
      1. Same as database proc.
      2. +Process Data
      3. +Process Defrag
   4. Partitions
      1. Same as database
      2. +Process Add
7. Overview
8. Security
   1. Permissions
      1. None
      2. Read and Process
      3. Read
      4. Process
      5. Administrator
      6. Show in SSMS only
   2. Roles definition (database roles)
   3. Row filters
   4. Dynamic Security
      1. USERNAME Function (DAX)
      2. CUSTOMDATA Function (DAX)
      3. LOOKUPVALUE
   5. Perspective
9. Performance Monitor
   1. Profiler
      1. Identify MDX statements that run slowly.
      2. Debug
      3. Monitor the performance of an instance of Analysis Services
      4. capturing events
      5. Audit and review activity
      6. capture and save data
   2. DMV
      1. $System.discover_object_activity
      2. $System.discover_object_memory_usage
      3. $System.discover_sessions
      4. $System.discover_locks
   3. Perform. Monitor
      1. Cache
      2. Connection
      3. Locks
      4. Memory
   4. No query log, though
10. Create
    1. New project
    2. Import from SSAS Tabular
    3. Import from PowerPivot
11. Programmatic Interfaces
    1. AMO
    2. DAX
    3. MDX
    4. CSDL
    5. XMLA
12. Backup & restore
    1. administrative permissions
    2. permission to write/read to the backup location