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.

[@motas92]

Great explanation, very comprehensive, Thank you!

[@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

[@joenorbe2711]

Clear explanation. Thank you for creating this.

[@victorrivas7911]

I totally understood. Excellent explanation!!

[@lukasyu1204]

Great lessons ! Thanks !

[@nelsonthekinger]

Great Work Mr ExcelCentral!

[@SK-kg6en]

Great presentation. Thank you very much.

[@hamman_samuel]

Thank you, this was very well-explaned

[@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

[@asifpatel7681]

Appreciate the way how you made me understand

[@uu8967]

Great explanation!

[@nickwu5317]

great explanation !

[@AxelYinYang]

I love this video, You are awesome.

[@santhuthgreat]

Very good explanation!!!!

[@dennismwangi3573]

Very informative. Thank u.

[@sidid2865]

Thanks, very well explained

[@garyparmar6914]

Very well explained.

[@ashokd5951]

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

[@VinLopez]

very clear explanations

[@adarshroy9655]

Excellent!

[@johnelmasry2536]

Brilliant and Easy

[@JT2751257]

pretty helpful!

[@arpit8495]

pretty great
thanks

[@picklepirate]

Thank You!

[@tallwaters9708]

Great thanks.

[@17primas]

thankyou... great help.. :))

[@user-dm3ww1cy5h]

Thanks a lot.

[@faisalhameed2591]

Good video👍

[@mabu3854]

great video

[@anishvarghese8169]

Thanks; nice video

[@adityatiwari811]

Thank you :)

[@yashashreejoshi1050]

very nice sir thank you

[@kkmingming]

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

[@mqurram]

Thank you so much very well explained

[@TheSmartMethod]

You are welcome!

[@amadoucoulibaly6439]

great job

[@JW-tf1kj]

Excellent

[@yurd563]

Thanks for view

[@devashishprasad1509]

Best Video !!!

[@TheSmartMethod]

Glad you liked it

[@ushnishd]

AWESOME

[@medjl6083]

You are the best

[@TheSmartMethod]

Thank you, very pleased you found it useful.

[@rajkumarphand6469]

Very well explained

[@TheSmartMethod]

Glad it was helpful.

[@kashmirism]

Sweet.

[@devi.elvira]

thanks..

[@ChPetru]

Very good

[@markososa23]

great

[@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 TH-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.