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

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

[@RedmondGamer]

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

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

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

[@shilpakar2]

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

[@TheSmartMethod]

You are welcome!

[@nelsonthekinger]

Great Work Mr ExcelCentral!

[@victorrivas7911]

I totally understood. Excellent explanation!!

[@SolidSnake59]

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

[@joenorbe2711]

Clear explanation. Thank you for creating this.

[@motas92]

Great explanation, very comprehensive, Thank you!

[@nickwu5317]

great explanation !

[@faisalhameed2591]

Good video👍

[@AxelYinYang]

I love this video, You are awesome.

[@santhuthgreat]

Very good explanation!!!!

[@ashokd5951]

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

[@asifpatel7681]

Appreciate the way how you made me understand

[@ashishlogin]

Great insight on OLAP . thanks

[@devashishkprasad]

Best Video !!!

[@TheSmartMethod]

Glad you liked it

[@SK-kg6en]

Great presentation. Thank you very much.

[@uu8967]

Great explanation!

[@garyparmar6914]

Very well explained.

[@VinLopez]

very clear explanations

[@dennismwangi3573]

Very informative. Thank u.

[@rajkumarphand6469]

Very well explained

[@TheSmartMethod]

Glad it was helpful.

[@johnelmasry2536]

Brilliant and Easy

[@medjl6083]

You are the best

[@TheSmartMethod]

Thank you, very pleased you found it useful.

[@lukasyu1204]

Great lessons ! Thanks !

[@hamman_samuel]

Thank you, this was very well-explaned

[@JW-tf1kj]

Excellent

[@mabu3854]

great video

[@RockyBalboa2024-w9r]

Excellent!

[@mqurram]

Thank you so much very well explained

[@TheSmartMethod]

You are welcome!

[@sidid2865]

Thanks, very well explained

[@amadoucoulibaly6439]

great job

[@yurd563]

Thanks for view

[@anishvarghese8169]

Thanks; nice video

[@afzaalawan]

excellent

[@TheSmartMethod]

Thanks!

[@kkmingming]

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

[@yashashreejoshi1050]

very nice sir thank you

[@17primas]

thankyou... great help.. :))

[@庄甚]

Thanks a lot.

[@ChPetru]

Very good

[@tallwaters9708]

Great thanks.

[@picklepirate]

Thank You!

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

[@ushnishd]

AWESOME

[@adityatiwari811]

Thank you :)

[@arpit8495]

pretty great
thanks

[@JT2751257]

pretty helpful!

[@RalphNgOfficial]

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

[@devi.elvira]

thanks..

[@kashmirism]

Sweet.

[@markososa23]

great

[@elguapo3811]

British English should be the spoken language of the world,

[@zabilibayev2279]

great

[@TheSmartMethod]

Very pleased that you found it useful.