MDX Training Part 1
4.6 (342 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,757 students enrolled

MDX Training Part 1

Beginning MDX Queries Training Course using SQL Server Analysis Services (SSAS) OLAP cubes
Bestseller
4.6 (342 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,757 students enrolled
Created by Vikas Munjal
Last updated 12/2019
English
Current price: $31.99 Original price: $49.99 Discount: 36% off
21 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 14 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Participant will be able to write basic MDX scripts by himself or herself and will feel more confident on MDX queries. Participant will understand the rules to write MDX queries . If the participant is working in a company where MDX scripts are prewritten then participants will be able to understand those scripts after learning this course.
Requirements
  • Participant should have basic knowledge of Relational Database Management Systems (RDBMS), Primary Key (P.K) and Foreign Key (F.K) for the better understanding of the course .
Description

The full form of MDX is Multi Dimensional eXpression. This is used to query OLAP cube. It means you can select or retrieve the data from OLAP cube using MDX . In this course i have used SQL Server Analysis Services technology to fetch the data using MDX queries.

To make it more clear i can say , we write SQL commands to select the data from the database . In the same way we write MDX queries to select the data from OLAP cube. 

In this online MDX Training video Course, following are the course contents which are covered

•Structure of the cube

•How MDX Queries Fetch the data from the cube

•How to create a basic cube

•What is the purpose of Hierarchy

•How to create hierarchies

•How to modify the existing cube

•Terminologies - Children,Member and Level

•Set - { }

•Tuple - ( )

•Default measure

•Filter condition

•Having condition

•Where condition

•Difference between where and having condition in MDX

•Calculated Member

•Named set

•Query scoped and Session scoped Calculated Member

•Query scoped and Session scoped Namedset


In this MDX video tutorial ,quiz, lab exercises  and  demonstration exercises are also included. With all these practice activities participant will feel more confident and will be able to write basic MDX scripts by himself or herself. If participant is working in a company where MDX scripts are prewritten then participants will be able to understand those scripts after learning this course.


But i will not stop only to this course , very soon i will release MDX Part 2 which will have advanced MDX queries and functions . After that course participant will be able to write complex MDX commands and feel more confident in writing MDX commands.


Who 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
Course content
Expand all 43 lectures 04:48:18
+ Module 1
7 lectures 01:13:36

According to our opinion , Udemy asks feedback very early . I request you to please go through the course completely or at least to a good extent before providing any review.I believe giving review so early is not the good justice to the course.

You can click on review later if feedback popup appears

Information
00:13
Installation - SQL Server , SSAS , SSMS and SSDT
20:33
Installation - Quick Notes
00:07
Theoretical Explanation - How to create a cube
12:14
Practical Demonstration - How to create a cube
27:27

In this video lesson i have explained what is Hierarchy, how to create hierarchy and what is the purpose of Hierarchy

How to create hierarchy and the purpose of creating hierarchies
03:59
+ Module 2
2 lectures 14:16
Terminologies
00:09

In this video you will learn terminologies used in MDX such as

Dimension, Attribute or Attribute Hierarchy , User Defined Attribute Hierarchy, Members ,Children,Level,Measure Group and Measure.

I will also write first MDX command in this video

Terminologies-Dimension, Attribute ,Members ,Children,Level,MeasureGroup,Measure
14:07
+ Module 3
6 lectures 21:46
How to modify an existing Cube
00:07

In this video you will learn how to modify an existing cube which means how you will be going to add Measures and Dimensions into an existing cube.

How to modify an existing cube
09:55
Links to download to perform lab exercises
00:05
Alternative way to restore Adventureworks SSAS Cube using the backup file
00:50
A Quick Note
00:14
+ Module 4
2 lectures 27:02
More on Set and Tuple
14:30

This quiz will help you to practice when to use  which brackets either { }  or ( )

Please note there are explanations written against each correct answer , Therefore please click on the correct answer if your first attempt is wrong.

Quiz : Set and Tuple
14 questions
+ Module 5
8 lectures 40:21
Default Measure
07:32
Key and Name Member
01:21
Operators in MDX ( , : -)
04:16
Difference between Having and Where in MDX
02:01
Having Condition
13:53
Where Condition
06:50

Please note there are explanations written against each correct answer , Therefore please click on the correct answer if your first attempt is wrong.

Quiz 2 : Set and Tuple
3 questions
Filter Condition
04:14
Please download Labs and Demonstrations
00:14
+ Module 6
8 lectures 40:50
Calculated Member and Named Set
00:32
Calculated Member
12:33
Query Scoped and Session Scoped Calculated Member
07:55
Multiple Calculated Members
01:40
Named Set
06:50
Orderset - One example of named set
09:09

Please note there are explanations written against each correct answer , Therefore please click on the correct answer if your first attempt is wrong.

Quiz 3 : Some more functions discussed
2 questions
The result of a Tuple will return a Set
01:56
Please download Labs and Demonstrations
00:14
+ Module 7
9 lectures 32:12
Decide when to create named set and calculated member
02:50
Calculated Member - Starts with the Dimension name
00:13
Sum Function
11:13
Calculated Member Deployment starts with Dimension Name
01:48
Allmembers
02:26
Static and Dynamic Named Set
11:31
More clarification on Dynamic and Static Named Set
00:23
Please download Demonstration Exercises
00:01
Bonus Lecture
01:46