SSAS Training MultiDimensional Model - Part 3

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

4.50 (141 reviews)

Udemy

platform

English

language

Other

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

Why take this course?

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

Screenshots

SSAS Training MultiDimensional Model - Part 3 - Screenshot_01

SSAS Training MultiDimensional Model - Part 3 - Screenshot_02

SSAS Training MultiDimensional Model - Part 3 - Screenshot_03

SSAS Training MultiDimensional Model - Part 3 - Screenshot_04

Reviews

Michelle

August 3, 2022

Fabulous instructor. Very clear, easy to follow and understand. Great command of the course material - thank you - very good courses !

ChakrapaniNaidu

July 11, 2022

Thank you very much for the course...!!! But I felt it might be good where you can cover the most useful concepts first & less useful concepts later on as some concepts explanation is very good and some concepts are giving us some high level data which we aren't understandable(My opinion only)... But as combo pack, Your 3 courses are tooo good with that we can easily learn SSAS tool....Thank you once again....!!! : ) : ) : )

Salvatore

August 27, 2020

The Teacher is very clear, competent and passionate as usual. Really glad to have taken the 3 MDX courses.

Ajay

March 5, 2020

i learnt a lot many things i was not aware about SSAS, nice course and the way of teaching is amazing

Byron

March 3, 2020

Excellent... I took Microsoft course for exam 768 developing Data Models and failed (641)with very low MDX and bad design... Took these 3 courses (mdx 1 and 2) and the multidimensional Model and passed with (800) … these were excellent courses and all questions were answered very quickly... Very much appreciated

Wickedsur

March 1, 2020

I took his part 1 and 2 of this course and I don't recommend this course. He uses databases that he does not inform his students where to get and jumps from one cube to another without prompt. This class is incomplete. I suggest people to skip this one.

Kinchit

August 30, 2019

I took all three courses on MDX and then I'm leaving this review. I found the course very helpful, and I think this is the best course on udemy for MDX. Vikas did a great job in simplifying and explaining all the concepts. Hope to see more course from Vikas on SQL and SSAS on this platform.

Vadim

May 31, 2019

A great practical tool for me. Also Vikas explains theoretical reasons, so it's all clear. English is very-very specific but I got used to it. :-)

Dimitar

February 24, 2019

Informative course, but very poor presentation. The instructor is not very engaging, the audio is too loud and the accent is far too strong. Unfortunately, Udemy does not have many alternatives so will have to stick to this course.

Michael

November 14, 2018

I have been looking for SSAS training that will explain these concepts and configurations in SSAS for a long time. Thank God for the part 3 of the SSAS training series. The detail and clarity in explanation is excellent. I have all 3 courses and I am very happy I purchased them. 5 stars was easy to give!!!

Richard

October 28, 2018

Exceptional work, as always! Will provide more feedback as I go along. Update -- 3/4/2019: I've been off doing other things for a while, but now that I'm getting back into some multidimensional SSAS, this course is perfect for my needs. I'm certified in SSAS, but it's already clear that Vikas will help bring it all back to me just when I need it most. Exactly as he did in his exceptional courses on MDX (which nobody beats) -- he illuminates material in ways that few can do. I'll write another update later in the course.

Hrishikesh

October 1, 2018

Vikas I have taken all your courses and no doubt all the courses reflect upon the vast breadth of your experiences.I really liked the fact that you take your time and grind through the topic so less experienced folks like me can digest the material.Liked the way you tear down the wizard driven things and resort to doing things manually for the concepts to sink in.I also noticed you are quite responsive in the forums unlike some other instructors that is a true plus and shows that you are willing to improve the course and not abandon it. I do have minor nitpicks too and hence taken of a half a star and i need you to tell us when to pick an OLAP cube vs when to use some new technology like clustered column store indexes and also please share more of your real world experiences like you briefly mentioned in the OLAP course that when the number of rows exceed 2Million its time to bring in partitioning etc. Overall a very good course and worth every penny ,Thanks for making this course available to us.

Charts

Price

Rating

Enrollment distribution

SSAS Training MultiDimensional Model - Part 3 - Distribution chart