MicroSoft SSAS Training

MicroSoft SSAS Syllabus

Download Syllabus

  • Introduction to SSAS
  • Schemas
  • Star Schema
  • Snowflake Schema
  • Data source
  • Data source views
  • Options in DSV
  • Dimension
  • Measures
  • Cube Creation
  • Build
  • Deploy
  • Process
  • How to Brows the CUBE
  • Types Of Relationships inside CUBE
  • No relationship
  • Regular Relationship
  • Fact Relation
  • Referenced Relationship
  • Many to Many
  • None
  • Hierarchies
  • What are KPI’s and How to Create KPI’s in SSAS
  • What are Perspective and how to create
  • What are Partitions
  • What are Translations
  • What are Actions
  • What are Calculations
  • Aggregations
  • Storage design – ROLAP, MOLAP , HOLAP
  • How to use Cube in Excel
  • MDX in Report
Quick Enroll