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:
thesmartmethod.com/excel-powe...

[@umerwaqas5943]

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!

[@PSAGrader]

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

[@shilpakar2]

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

[@jyotiyemul7628]

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.

[@TheSmartMethod]

Hi Jyoti, really pleased that you found this useful. OLAP is one of those IT subjects that is massively misunderstood even amongst IT professionals. So pleased you took the time to read my articles using the link in the description too.

[@victorrivas7911]

I totally understood. Excellent explanation!!

[@motas92]

Great explanation, very comprehensive, Thank you!

[@joenorbe2711]

Clear explanation. Thank you for creating this.

[@nelsonthekinger]

Great Work Mr ExcelCentral!

[@uraaxeecaqligaaga4890]

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

[@SK-kg6en]

Great presentation. Thank you very much.

[@lukasyu1204]

Great lessons ! Thanks !

[@SolidSnake59]

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

[@poojarajashekar]

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

[@TheSmartMethod]

You are welcome!

[@ashishlogin]

Great insight on OLAP . thanks

[@hamman_samuel]

Thank you, this was very well-explaned

[@asifpatel7681]

Appreciate the way how you made me understand

[@uu8967]

Great explanation!

[@nickwu5317]

great explanation !

[@santhuthgreat]

Very good explanation!!!!

[@dennismwangi3573]

Very informative. Thank u.

[@ashokd5951]

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

[@AxelYinYang]

I love this video, You are awesome.

[@sidid2865]

Thanks, very well explained

[@garyparmar6914]

Very well explained.

[@VinLopez]

very clear explanations

[@adarshroy9655]

Excellent!

[@johnelmasry2536]

Brilliant and Easy

[@faisalhameed2591]

Good video👍

[@picklepirate]

Thank You!

[@JT2751257]

pretty helpful!

[@arpit8495]

pretty great
thanks

[@mabu3854]

great video

[@17primas]

thankyou... great help.. :))

[@tallwaters9708]

Great thanks.

[@yashashreejoshi1050]

very nice sir thank you

[@JW-tf1kj]

Excellent

[@user-dm3ww1cy5h]

Thanks a lot.

[@amadoucoulibaly6439]

great job

[@yurd563]

Thanks for view

[@anishvarghese8169]

Thanks; nice video

[@adityatiwari811]

Thank you :)

[@kkmingming]

Great!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@ushnishd]

AWESOME

[@mqurram]

Thank you so much very well explained

[@TheSmartMethod]

You are welcome!

[@devi.elvira]

thanks..

[@ChPetru]

Very good

[@kashmirism]

Sweet.

[@devashishprasad1509]

Best Video !!!

[@TheSmartMethod]

Glad you liked it

[@markososa23]

great

[@medjl6083]

You are the best

[@TheSmartMethod]

Thank you, very pleased you found it useful.

[@rajkumarphand6469]

Very well explained

[@TheSmartMethod]

Glad it was helpful.

[@afzaalawan]

excellent

[@TheSmartMethod]

Thanks!

[@RalphNgOfficial]

hi, can I get a free copy of this book?

[@dvesfvhssss]

Thx
Where is lesson 6-4?

[@TheSmartMethod]

Greetings
This lesson is a video version of a lesson from Session 6 in the 2013 version of the book “Learn Excel Expert Skills with The Smart Method”. I did record all 10 lessons from Session 6 back in 2013 but only Lessons 6-1, 6-3 and 6-9 are really relevant to OLAP in 2021 so I’ve left these on UA-cam.
Microsoft’s current OLAP solution (Power Query/Get & Transform, 3D Maps, Power Pivot and DAX) is now included in all modern versions of Excel and are hugely more powerful than they were in the (now retired) 2013 version.
I’ve written a more up to date (and completely free) overview of OLAP that you can read on this link:
thesmartmethod.com/excel-power-pivot-2-minute-overview/
I hope this article helps you to understand more about OLAP and relational database principles.
The current version of my book “Learn Excel 365 Expert Skills with The Smart Method, Jan 2021 Fifth Edition”, has150 pages devoted to Microsoft’s current OLAP solution.

[@elguapo3811]

British English should be the spoken language of the world,

[@zabilibayev2279]

great

[@TheSmartMethod]

Very pleased that you found it useful.