MDX Training Part 2 | Vikas Munjal | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (1h 2m)
    • Terminologies-Dimension, Attribute ,Members ,Children,Level,MeasureGroup,Measure

      14:07
    • How to modify an existing cube

      9:55
    • How to perform Lab Exercises

      10:33
    • Set and Tuple

      12:32
    • More on Set and Tuple

      14:30

About This Class

In this video series 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 series

 i will also explain how to modify an existing cube.

It means  how you will be going to add measure group , measures and dimensions into an existing cube.

Also you will learn how to perform Lab Exercises .

Please click on the following links to download the resources


Link to Download Adventureworks Data warehouse

https://msftdbprodsamples.codeplex.com/downloads/get/165405

Link to download AdventureWorks Multidimensional Models SQL Server 2012 SSAS Project

https://msftdbprodsamples.codeplex.com/downloads/get/258486

What is the difference between Set and Tuple

There is a quiz provided as a class project to identify what is Set and what is Tuple

--

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Vikas Munjal

Microsoft Certified Trainer

I am Microsoft Certified Trainer. Having around 10 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 understan...

See full profile

Report class