Microsoft SSAS Multidimensional Model Technology is a part of Microsoft Business Intelligence - MSBI. The OLAP cubes MDX expressions to generate the report. Please check MDX Training Part 1 and MDX Training Part 2 to learn MDX expressions

The following topics are covered in Microsoft SQL Server Analysis Services OLAP Cube Online Video Training Course

Impersonation Options in SSAS

Named Calculation Key Column Name Column

Sorting one attribute using another attribute

How to increase processing performance using attribute relationship

Ragged Hierarchy

Parent-Child Hierarchy

Star and SnowFlake Schema

Types of Relationships - Regular,Referenced,Fact and Many to Many

Role Playing Dimension

Creating Empty Cube

Creating Multiple Cubes in a Project

Dimensions at project level and cube level

Why do we need Partitions in SSAS

How to create Partitions in SSAS

Aggregations in SSAS

Usage Based Aggregations

How to enable and disable Usage Based Aggregations

Storage Modes - MOLAP ROLAP HOLAP

Outdated Cube and what is the need of Proactive Caching

ProActive Caching Implementation

Perspectives - Subset of Cube's Objects

Translations - Multi Language Support

Key Performance Indicators Implementation

Trends Implemetation using Isempty() and ParallelPeriod

Actions in SSAS

Backup and Restore - SSAS Database

Scheduling Process Full  Option using XMLA and SQL Server Agent

Processing Options at DimensionLevel -  Process Update Process Add

Processing MeasureGroup - Process Data, Index,  Add, Clear,Default

Processing Multiple Objects(Dimensions and Measure Groups) together in SSAS

Write Back Option - WhatIF Analysis in Excel

SSAS Security

Security at Dimension Level

CellSecurity - Restricting Measures Data

How to test Security Settings in SSMS

How to test Security Settings in Excel