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

Подписаться 22 тыс.

Просмотров 432 тыс.

50% 1

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

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 66

@umerwaqas5943 7 лет назад

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

@budduvcawce 8 лет назад

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

@PSAGrader 5 лет назад

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

@jyotiyemul7628 3 года назад

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 3 года назад

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.

@shilpakar2 8 лет назад

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

@motas92 6 лет назад

Great explanation, very comprehensive, Thank you!

@victorrivas7911 5 лет назад

I totally understood. Excellent explanation!!

@joenorbe2711 4 года назад

Clear explanation. Thank you for creating this.

@uraaxeecaqligaaga4890 5 лет назад

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 7 лет назад

Great presentation. Thank you very much.

@lukasyu1204 4 года назад

Great lessons ! Thanks !

@hamman_samuel 5 лет назад

Thank you, this was very well-explaned

@poojarajashekar 3 года назад

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

@TheSmartMethod 3 года назад

You are welcome!

@ashishlogin 6 лет назад

Great insight on OLAP . thanks

@nelsonthekinger 6 лет назад

Great Work Mr ExcelCentral!

@asifpatel7681 7 лет назад

Appreciate the way how you made me understand

@SolidSnake59 4 года назад

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

@uu8967 8 лет назад

Great explanation!

@nickwu5317 4 года назад

great explanation !

@santhuthgreat 4 года назад

Very good explanation!!!!

@dennismwangi3573 4 года назад

Very informative. Thank u.

@ashokd5951 8 лет назад

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

@sidid2865 8 лет назад

Thanks, very well explained

@AxelYinYang 5 лет назад

I love this video, You are awesome.

@garyparmar6914 5 лет назад

Very well explained.

@VinLopez 8 лет назад

very clear explanations

@adarshroy9655 5 лет назад

Excellent!

@johnelmasry2536 4 года назад

Brilliant and Easy

@JT2751257 3 года назад

pretty helpful!

@picklepirate 5 лет назад

Thank You!

@arpit8495 4 года назад

pretty great thanks

@tallwaters9708 6 лет назад

Great thanks.

@user-dm3ww1cy5h 7 лет назад

Thanks a lot.

@17primas 9 лет назад

thankyou... great help.. :))

@faisalhameed2591 4 года назад

Good video👍

@adityatiwari811 5 лет назад

Thank you :)

@kkmingming 4 года назад

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

@mabu3854 6 лет назад

great video

@JW-tf1kj 5 лет назад

Excellent

@yashashreejoshi1050 4 года назад

very nice sir thank you

@anishvarghese8169 5 лет назад

Thanks; nice video

@amadoucoulibaly6439 5 лет назад

great job

@ushnishd 7 лет назад

AWESOME

@mqurram 2 года назад

Thank you so much very well explained

@TheSmartMethod 2 года назад

You are welcome!

@yurd563 5 лет назад

Thanks for view

@kashmirism 3 года назад

Sweet.

@rajkumarphand6469 3 года назад

Very well explained

@TheSmartMethod 3 года назад

Glad it was helpful.

@devi.elvira 6 лет назад

thanks..

@devashishprasad1509 3 года назад

Best Video !!!

@TheSmartMethod 3 года назад

Glad you liked it

@ChPetru 6 лет назад

Very good

@medjl6083 3 года назад

You are the best

@TheSmartMethod 3 года назад

Thank you, very pleased you found it useful.

@markososa23 7 лет назад

great

@afzaalawan 3 года назад

excellent

@TheSmartMethod 3 года назад

Thanks!

@RalphNgOfficial 6 лет назад

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

@dvesfvhssss 3 года назад

Thx Where is lesson 6-4?

@TheSmartMethod 3 года назад

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 RU-vid. 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.