Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence.

This video lesson fully explains the concepts of Business Intelligence, OLAP, MDX and how they apply to Excel 2013.

The lesson begins with an explanation of OLAP and its purpose. You'll learn about OLAP Cubes and how they are divided into Dimensions, Measure and Hierarchies to create a multidimensional data structure. You'll also learn about how the MDX query language is used to extract values from OLAP cubes. This lesson also explains the concept of Business Intelligence and how it applies to OLAP.

This video comes from the Data Model, OLAP, MDX and BI session (Session 6 in our Excel 2013 Expert Skills free video training course).

I’ve written a more up to date (and completely free) overview of OLAP that you can read on this link:

[umerwaqas]

Thanks a lot sir, after months my search about OLAP concepts ended here.

[budduvcawce]

Very clear, concise, and to the point. Thanks for this explanation!

[RedmondGamer]

This is a FANTASTIC explanation of OLAP Cubes. Thank you for posting this. Cheers!

[jyotiyemul]

Wow....thanks for explaining the concepts in such a simple and quickly understandable way. Thanks for sharing notes and all other material, it's very helpful. Looking forward to more videos.

[shilpakar]

Great lessons. Thanks you so much. You clarified CUBE very well, cleared my mind :)

[poojarajashekar]

Finally ended up at this video understanding the concept. Thanks a lot

[uraaxeecaqligaaga]

I'm the first to comment on this wonderful clip I really appreciate the way you make me understand this concept. God bless you sir and thank you very much

[SolidSnake]

Thanks, I always wondered what this OLAP means while I refeshed pivots.

[victorrivas]

I totally understood. Excellent explanation!!

[asifpatel]

Appreciate the way how you made me understand

[joenorbe]

Clear explanation. Thank you for creating this.

[SK-kgen]

Great presentation. Thank you very much.

[motas]

Great explanation, very comprehensive, Thank you!

[ashokd]

Well represented about cube.. It helped a lot... :)

[hamman_samuel]

Thank you, this was very well-explaned