Analysis Services What is the Difference between Tabular and Multidimensional Models

In Microsoft Analysis Services there are two model types: the Multidimensional and the Tabular. In this video, we'll explain what the difference is and which should you choose?

[sau]

I came back to this video once more. Never found a better intuitive explanation for a Cube.

[davidw.]

finally, someone who speaks proper English

[clnguye]

Video was made 5 years ago, yet still relevant. Your explanation of MDX OLAP as a series of pre-calculated group by queries saved on disk is brilliant.

[jawadkazmi]

Seriously this was the best most concise talk on the subject I listened to. Raised pertinent questions and the answers were on the point. Brilliant.
Thanks.

[nicks]

You are a great example of someone who is really understand the topic. Your ability to clarify and give simple examples helped me a lot!
Thank you once again

[alisadreddini]

Probably one of the best videos i've watched on a deep and technical topic. I'm a complete noob when it comes to BI and it's been daunting to say the least, but I've answered so many questions for myself with this 30 minutes that has saved me hours of running around the net to figure out the answers. Thank you

[zakariahaddouche]

So clean explantation !! Bravo, really so clear and makes you perfectly get the difference between Multidim & Tabular models ! can't believe i didn't come accross this beafore ! Thank you !

[giovannimaglie]

The best practical explanation I got so far about multidimensional models!

[pallejohnson]

Bryan the way you explain things is awesome. I am one of those “dinosaurs” and your lessons have really kickstarted my journey back. Thx

[e.menezes]

By far, the best video I've seen on the subject

[salsalvatierra]

I have used cubes since SQL Server 2000 and this is the best explanation of the two models I have seen. Great work. The book mentioned by Marco Russo and Alberto Ferrari is a great way to go. They have been key to BI for over a decade.

[ulysses]

Good stuff, you made it very clear the differences between the two. I'm transitioning from an IT support career to SQL and database management and I will be watching more of your videos. BTW it's good to hear a Northern accent, I moved from New England to the mid-South a few years back. When I move back I'll be joining your RI user groups.

[PriG]

Excellent video. There's no nonsense. Straight to the point with great examples.

[DRathore]

All clarification is really crystal clear and thanks a lot for an awesome video.

[gwen]

Great Video! much better than most of the tutorials on this topic.

[wendywang]

very clear explanation and really helpful. I found it is very important to understand theses basic concepts and the relationships among them. Thanks for your great job!

[sau]

Please consider writing a a book. You have solid practical experience.

[CaribouDataScience]

Are Multidimensional Models just pivot tables for MS SQL/SSAS?

[kamilszpyrka]

what a great explanation. highly appriaciate.

[hendrag]

Thank you Bryan for this great video so as a beginner, I will focus on studying the Tabular instead. GBU.