Vikas Munjal
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
Courses : 6
Specification: SSAS Training MultiDimensional Model – Part 3
|
11 reviews for SSAS Training MultiDimensional Model – Part 3
Add a review
| Price | $11.99 |
|---|---|
| Provider | |
| Duration | 6 hours |
| Year | 2019 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$11.99
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.
manpreet Singh –
Absolutely amazing content wit great simplicity in mind. Many thanks and keep it up please.
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.
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!!!
Adriana Jazm n Gonz lez Aguilar –
excellent course, quite complete
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.
Muthu Savarimalai –
Its good to get real time knowledge on detailed concepts of OLAP !
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. : )
Rajender Singh –
Great knowledge ,way of teaching is far better.Thanks Vikas for providing this kind of learning
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.
Nikhil Patil –
Informative and precise. highly recommend it for beginners!