Latest Courses
Getting Started with AWS Mobile ServicesCheck course
Oracle APEX Low-code Platform Fundamentals - Hands OnCheck course
AWS Database- RDS, DynamoDB, Redshift, Neptune, ElasticacheCheck course
Building Professional Websites Locally Without Web HostingCheck course
COMPLETE PERL Programming 2020Check course
Advanced Automation framework with Appium C# - 2020 UpdatedCheck course
Build 10 JavaScript Projects in less than 6 Hours .Check course
Learning Analytics Through RCheck course
Build three custom, functional websites in Django 3.0Check course
JavaScript for beginners For StudentsCheck course
Getting Started with AWS Mobile ServicesCheck course
Oracle APEX Low-code Platform Fundamentals - Hands OnCheck course
AWS Database- RDS, DynamoDB, Redshift, Neptune, ElasticacheCheck course
Building Professional Websites Locally Without Web HostingCheck course
COMPLETE PERL Programming 2020Check course
- 76% MDX Training Part 2

MDX Training Part 2

$49.99 $11.99Track price

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

In MDX training Part2 video training course advanced concepts of MDX queries are discussed

The basic concepts are already discussed in MDX training course Part 1

Multidimensional eXpressions are used to query and get the data from Multi Dimension OLAP cube.

These video tutorials have used SSAS Cubes to write MDX Queries

This advance online MDX training course is a part of SSAS Training (SQL Server Analysis Services) . The SSAS comes under MSBI Training (Microsoft Business Intelligence) This course is very important to get familiar with all concept of MDX and expert knowledge of the same.

Following are the course contents

Playing with Hierarchies

Descendants Function

Ascendants Functions

Parent

Ancestor

Siblings FirstSibling LastSibling

Firstchild Lastchld

item

PrevMember NextMember

Lag Lead

Hierarchize Function

CurrentMember

Ordinal

More on Order Function

Rank Function

More functions

iif Function

Switch function

Crossjoin Union Except Intersect

DrilldownMember and DrilldownLevel

DrilldownLevelTop and DrilldownLevelBottom

DrilldownMemberTop

DrilldownMemberBottom

Generate Function

Working with Time

How to add Time Intelligence to a Dimesion

YTD QTD MTD WTD

PeriodsToDate

OpeningPeriod

ClosingPeriod

Parallelperiod

LastPeriods

Business Scenarios

Percent Sales Contribution of every Product to the business

Percent Sales Contribution of every Product to its Subcategory and then Percent Sales Contribution of every Subcategory to its Category

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: MDX Training Part 2

Duration 4 hours
Year 2019
Level Intermediate
Certificate Yes
Quizzes No

5 reviews for MDX Training Part 2

4.4 out of 5
2
3
0
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Muthu Savarimalai

    Its good to learn complex MDX queries based on real time business case. Since i had little working knowledge on OLAP and as i had taken MDX part 1 prior to this course, i am catching up well and its wonderful to learn further.

    Helpful(0) Unhelpful(0)You have already voted this
  2. 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
  3. Avatar

    Yara Mayer

    This course nicely expands upon MDX Training Part 1 and brings all the concepts together. Only thing that could really be improved is the varying audio quality. Thanks!

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

    Karthick Vasudevan

    The content is good. I am on the half the way. Need to continue the course

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

    Heikki Moisander

    I believe so.

    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.

    Price tracking

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