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