Disclosure: when you buy through links on our site, we may earn an affiliate commission.

MDX Training Part 2

Advanced MDX Queries Video Training Course using SQL Server Analysis Services (SSAS) OLAP cubes
4.3
4.3/5
(196 reviews)
1,594 students
Created by

8.4

CourseMarks Score®

7.4

Freshness

8.3

Feedback

9.0

Content

Platform: Udemy
Video: 3h 52m
Language: English
Next start: On Demand

Table of contents

Description

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
•Dividing Products into sections.For Example if the sale of the product has above 20% of contribution to the business then Product belongs to Class A
•If the contribution of the product is between 10 to 20 % then class B else class C
•To find monthly sales and for every month what is the average per day sales

•For every country what are the top 5 best selling products
•Sales of first 6 months of a given year
•Comparing current year sales with previous year sales
•Comparing sales of first 6 months of the current year with the previous year sales
•Comparing current month sales with the average of last three months sales
•You need to find out opening stock at the start of the month or Closing Stock at the end of the month for an inventory
•Providing Ranking to the Products based on Sales
•Summary Sales details of all the countries except one country . Eg USA , in this you want to see state wise sales as well

After learning this online training course participant will be able to write complex MDX expressions and feel confident in writing the commands

You will learn

✓ Participant will be able to write complex MDX queries by himself or herself

Requirements

• MDX Training Part 1

This course is for

• Who are working on OLAP cubes or planning to work on OLAP cubes and want to learn MDX queries using SSAS Technology. It is also useful who are working with Microsoft AX

How much does the MDX Training Part 2 course cost? Is it worth it?

The course costs $14.99. And currently there is a 70% discount on the original price of the course, which was $49.99. So you save $35 if you enroll the course now.
The average price is $15.0 of 2 MDX Query courses. So this course is 0% cheaper than the average MDX Query course on Udemy.

Does the MDX Training Part 2 course have a money back guarantee or refund policy?

YES, MDX Training Part 2 has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the MDX Training Part 2 course, but there is a $35 discount from the original price ($49.99). So the current price is just $14.99.

Who is the instructor? Is Vikas Munjal a SCAM or a TRUSTED instructor?

Vikas Munjal has created 8 courses that got 1,702 reviews which are generally positive. Vikas Munjal has taught 13,192 students and received a 4.4 average review out of 1,702 reviews. Depending on the information available, Vikas Munjal is a TRUSTED instructor.
SQL Server | MSBI Microsoft Certified Trainer & Consultant
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 Professional
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 52m
Language: English
Next start: On Demand

Students are also interested in