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.
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.
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
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.
Thanks a lot sir, after months my search about OLAP concepts ended here.
Very clear, concise, and to the point. Thanks for this explanation!
This is a FANTASTIC explanation of OLAP Cubes. Thank you for posting this. Cheers!
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.
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.
Great lessons. Thanks you so much. You clarified CUBE very well, cleared my mind :)
Thanks, I always wondered what this OLAP means while I refeshed pivots.
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
Finally ended up at this video understanding the concept. Thanks a lot
You are welcome!
I totally understood. Excellent explanation!!
Appreciate the way how you made me understand
Great Work Mr ExcelCentral!
Clear explanation. Thank you for creating this.
Great explanation, very comprehensive, Thank you!
great explanation !
Great presentation. Thank you very much.
Great insight on OLAP . thanks
Very good explanation!!!!
Thank you, this was very well-explaned
very clear explanations
Very informative. Thank u.
I love this video, You are awesome.
Very well explained.
Well represented about cube.. It helped a lot... :)
Thanks, very well explained
Great explanation!
Thank you so much very well explained
You are welcome!
Good video👍
Great lessons ! Thanks !
Very well explained
Glad it was helpful.
Brilliant and Easy
Thanks for view
great video
very nice sir thank you
Excellent!
great job
You are the best
Thank you, very pleased you found it useful.
Excellent
Thanks; nice video
Best Video !!!
Glad you liked it
thankyou... great help.. :))
excellent
Thanks!
Thanks a lot.
Very good
pretty great
thanks
Great!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Great thanks.
Thank You!
pretty helpful!
Thank you :)
AWESOME
Thx
Where is lesson 6-4?
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.
hi, can I get a free copy of this book?
thanks..
great
British English should be the spoken language of the world,
Sweet.
great
Very pleased that you found it useful.