Latest Courses
Modern .NET Ecosystem and .NET CoreCheck course
Python Programming Bible: Hands-On Python 3 with 10 ProjectsCheck course
Introduction to Cloud Computing on Amazon AWS for BeginnersCheck course
Learn basics of Redux in React Native in 2 hours!Check course
Learn Python Django From ScratchCheck course
The Complete PHP Bootcamp Course With Video Sharing ProjectCheck course
ODI 11g Hands On TutorialsCheck course
Shopify Empire Masterclass: The Complete Shopify CourseCheck course
Machine Learning & Deep Learning in Python & RCheck course
JavaScript Web Projects: 20 Projects to Build Your PortfolioCheck course
Modern .NET Ecosystem and .NET CoreCheck course
Python Programming Bible: Hands-On Python 3 with 10 ProjectsCheck course
Introduction to Cloud Computing on Amazon AWS for BeginnersCheck course
Learn basics of Redux in React Native in 2 hours!Check course
Learn Python Django From ScratchCheck course
- 88% SSAS Training MultiDimensional Model – Part 3

SSAS Training MultiDimensional Model – Part 3

$99.99 $11.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.4/10 (Our Score)
Product is rated as #19 in category Business Intelligence

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

Instructor Details

I am Microsoft Certified Trainer. Having more than 12 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India. My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understand , remember and learn all the things in pictures , diagrams or images . This is the science of learning. My Microsoft Certifications are: Microsoft Certified Solution Expert Data Platform Microsoft Certified Solution Expert Business Intelligence Microsoft Certified Solution Expert Data Management and Analytics Microsoft Certified Solution Associate SQL Server 2012/2014 Microsoft Certified Trainer Microsoft Certified Professional

Specification: SSAS Training MultiDimensional Model – Part 3

Duration

6 hours

Year

2019

Level

Intermediate

Certificate

Yes

Quizzes

No

11 reviews for SSAS Training MultiDimensional Model – Part 3

4.7 out of 5
9
1
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Hrishikesh Samant

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    manpreet Singh

    Absolutely amazing content wit great simplicity in mind. Many thanks and keep it up please.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Richard W. Memmer

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Michael Gyekye

    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!!!

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Adriana Jazm n Gonz lez Aguilar

    excellent course, quite complete

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Dimitar Shutev

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Muthu Savarimalai

    Its good to get real time knowledge on detailed concepts of OLAP !

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Vadim Koscheev

    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. : )

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Rajender Singh

    Great knowledge ,way of teaching is far better.Thanks Vikas for providing this kind of learning

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Kinchit Chawla

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Nikhil Patil

    Informative and precise. highly recommend it for beginners!

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    SSAS Training MultiDimensional Model – Part 3
    SSAS Training MultiDimensional Model – Part 3

    $99.99 $11.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare