Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

MDX Training Part 1

Name: MDX Training Part 1
Rating: 4.3 (792 reviews)

Beginning MDX Queries Training Course using SQL Server Analysis Services (SSAS) OLAP cubes

Created byVikas Munjal

Last updated 12/2024

English

English [Auto],

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.

Course content

8 sections • 43 lectures • 4h 48m total length

Introduction - Facts Dimension DWH SSIS SSAS SSRS38:14
Explore the difference between OLTP and OLAP, define data warehouse concepts, and learn ETL with SSIS to load fact and dimension tables, enabling MDX-based reporting.

MultiDimension Cube Structure and How MDX Queries fetch the data from a cube9:03
Information0:13
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
Installation - SQL Server , SSAS , SSMS and SSDT20:33
Installation - Quick Notes0:07
Theoretical Explanation - How to create a cube12:14
Learn to create a cube from the Adventureworks data warehouse in SQL Server Analysis Services, configuring data source, data source view, and cube structure, then deploy and process with authentication.
Practical Demonstration - How to create a cube27:27
Create a cube from three tables in a data warehouse by configuring a data source, data source view, and cube in SQL Server Analysis Services, deploy and analyze with Excel.
How to create hierarchy and the purpose of creating hierarchies3:59
In this video lesson i have explained what is Hierarchy, how to create hierarchy and what is the purpose of Hierarchy

How to modify an existing Cube0:07
How to modify an existing cube9:55
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 perform Lab Exercises10:33
Shows how to create the Adventureworks data warehouse in SQL Server, attach the Adventureworks 2012 MDF, and deploy the OLAP project with SQL Server Data Tools for lab exercises.
Links to download to perform lab exercises0:05
Alternative way to restore Adventureworks SSAS Cube using the backup file0:50
A Quick Note0:14

Set and Tuple12:32
Explain the difference between sets and tuples in MDX, using curly braces for sets and round brackets for tuples, and show how unions and cross joins apply to attribute members.
More on Set and Tuple14:30
Explore advanced MDX concepts using sets and tuples to combine measures like sales amount with calendar year, handle nulls with non empty, and distinguish cross join from union.
Quiz : Set and Tuple

Default Measure7:32
Key and Name Member1:21
Learn how to represent members as key or name in MDX, using the ampersand to toggle representations, with Australia as a key and Germany in a set.
Operators in MDX ( , : -)4:16
Explore MDX operators for sales territory analysis by selecting Australia and Germany, using in and range operators, not in with minus signs, and combining results with sets and unions.
Difference between Having and Where in MDX2:01
Explore the MDX having and where clauses to filter data. Learn that where filters the cube before the result set, while having filters the result set after its creation.
Having Condition13:53
Where Condition6:50
Explore using the where condition as an axis in MDX to filter sales by year (2007) and by country, and use non-empty to prune nulls.
Quiz 2 : Set and Tuple
Filter Condition4:14
Learn to use the filter condition to restrict cube data, compare it with the having condition introduced in 2005, and write predicates with sets, current member checks, and in-string tests.
Please download Labs and Demonstrations0:14

Calculated Member and Named Set0:32
Calculated Member12:33
Create a calculated member for profit in a SSAS cube using MDX (sales amount minus total product cost), format currency, and add profit percentage via division and non empty behavior.
Query Scoped and Session Scoped Calculated Member7:55
Multiple Calculated Members1:40
Named Set6:50
Learn to create named sets in MDX as aliases to expressions, calculated members, using SQL Server data tools to define and deploy them, with query scoped and session scoped examples.
Orderset - One example of named set9:09
Explore sorting a country set by sales amount within a cube using MDX order, then return the top five via head or top count, and save as a named set.
Quiz 3 : Some more functions discussed
The result of a Tuple will return a Set1:56
Please download Labs and Demonstrations0:14

Decide when to create named set and calculated member2:50
Calculated Member - Starts with the Dimension name0:13
Sum Function11:13
Explore the mdx sum function, its syntax with a set expression and optional numeric expression, and learn how to compute total sales and percentage contributions using calculated members.
Calculated Member Deployment starts with Dimension Name1:48
Copy the calculated member expression to SQL Server Data Tools, name it dimsdale's territory sales territory country total sales Australia and Canada, apply euro format, and deploy the demo cube.
Allmembers2:26
Demonstrate validating a calculated member in a demo cube by comparing all members, including calculated ones, and confirming total sales for Australia and Canada.
Static and Dynamic Named Set11:31
Explore static and dynamic named sets, including query-scoped and session-scoped variants, to produce top five products by internet sales and observe caching effects.
More clarification on Dynamic and Static Named Set0:23
Please download Demonstration Exercises0:01
Bonus Lecture1:40

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

Orderset - One example of named set

The result of a Tuple will return a Set

Decide when to create named set and calculated member

•Query scoped and Session scoped Calculated Member

•Query scoped and Session scoped Namedset

Allmembers

Static and Dynamic Named Set

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

MDX Training Part 1

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 38min

Module 17 lectures • 1hr 14min

Module 22 lectures • 14min

Module 36 lectures • 22min

Module 42 lectures • 27min

Module 58 lectures • 40min

Module 68 lectures • 41min

Module 79 lectures • 32min

Requirements

Description

Who this course is for: