MDX 101

The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language.
Check Out Our SSAS Blog - blog.pragmaticworks.com/topic/...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning Courses FREE Trial: www.pragmaticworkstraining.co...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️CZcams: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]

[@lukasyu1204]

Really concrete and useful presentation! It helps me much more than dull books.

[@FoodieMing]

Thanks a lot! Such a clear and great intro for MDX.

[@pow5782]

Amazing demo. I really learned a lot. I hope to see more of this! thank you mitchell

[@abc123birdsandbees]

Really clear and effective. I was able to grasp the information with ease.

[@maurotorres5675]

This was a fantastic tutorial. I learned SSAS about 5 years ago, but haven't used it since then, so this was the perfect tutorial to refresh my memory. Also thank you for your good indentation. It really helps for learning. You're a talented teacher.

[@PragmaticWorks]

You're very welcome!

[@georgemelek]

Excellent video!!! Thank you

[@samitauqeer]

Excellent Knowledgeable Video of SSAS thanks brother

[@juanm555]

God... this guy is such a good trainer !! thank you very much Mitchell

[@PragmaticWorks]

I appreciate that!

[@sahuanalogchannel]

Really a great explanation

[@nusratchowdhury50]

it was helpful. thanks a lot

[@elvistsang832]

This is amazing! Though if you don't mind constructive criticism, I would much prefer the backspace around the screen recording to be gone, but it is otherwise a fantastic tutorial!

[@severtone263]

Great demo! Thank you :)

[@PragmaticWorks]

Thanks! Glad you enjoyed.

[@fernandoarce804]

Amazing! thanks.

[@PragmaticWorks]

Glad you enjoyed!

[@chrispacho5043]

great stuff, helped me very much , thanx a lot !

[@PragmaticWorks]

You are very welcome! Glad it helped!

[@Mastaafa]

Thank you Man , It very useful :)

[@PragmaticWorks]

Thanks. That means a lot to us. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.

[@polinasemykina7660]

Good demo. Thank you !

[@PragmaticWorks]

Thanks for watching!

[@CtfXable]

Zjbs video, krasavcik!

[@nandhinim7100]

Thanks a lot . It's very helpful to me ,but I have an doubt after deploy the SSAS our end user will see the report using SSRs graphical view , they are not writing those mrx queries in sqlserver right ? If yes then why we need this. Could please clarify me

[@ikihidayat6707]

I have a question in related to MDX calculation. The question is How to display last 5 years in Power BI using MDX Calculation? Let me know if you have solution on this.
I have solved the calculation previously in DAX Power BI just for reference. The Dax formula for this case here and I attached the visualization example:
Last 5 Years = CALCULATE(SUM(Dummy[Value]),FILTER(Dummy,Dummy[Year]=SELECTEDVALUE(Calender_1[Year])-4))
The problem is, I need to create the calculation using MDX because the data source is Multidimensional Analysis Services.
Much appreciate for your helping.

[@ashish7750]

If we have to apply AVG/MAX operator on sales, how can that be done?

[@ahmadyamout6867]

I am new to power bi and I need a mentor . Is this video of mdx sufficient to learn from it and apply for a job that is in need of it?

[@Dunblide]

Does this apply for MS Excel Pivot Table OLAP MDX? I tried with SELECT and WHERE but it keeps giving me error.

[@fanglanwang911]

It is applied to add-in (essbase, smartview) in excel.

[@fanglanwang911]

Amazing demo. I really learned a lot. I hope to see more of this! thank you mitchell

[@PragmaticWorks]

Thanks so much! Please subscribe to view more content like this one :)