SSAS Training MultiDimensional Model - Part 3

Learn Microsoft SQL Server Analysis Services Cube - Extension to MDX Training Part 1 & Part 2 Video Course Series

Ratings: 4.26 / 5.00




Description

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


What You Will Learn!

  • Participant will be able to pass the job interview on this technology
  • If the participant is already working then the person will feel more confident in handling real time project as this course will deepen the understanding

Who Should Attend!

  • After the end of the course along with MDX Training Part 1 and MDX Training Part 2, participant will have comprehensive knowledge on SSAS technology