What is OLAP?

This video explores some of OLAP's history, and where this solution might be applicable. We also look at situations where OLAP might not be a fit. Additionally, we investigate an alternative/complement called a Relational Dimensional Model.

[MarkMeed]

This is excellent. One of the most lucid explanations I have encountered in a very long time. Well done.

[ITBroom]

I agree with other commenters. The clear explanations + cool animations, make for a brilliant presentation of these concepts. E-learning at its best.

[kennethringo]

Thank you so much. That was succinct and really well presented!

[dadautube]

very nicely done video presentation with a super professional grammatically correct flawless talk ...
i really like that!

still however, OLAP's definition is not clear enough here, as you can see from other people's comments! :)

on a different note though: if businesses had / still have trouble working out their data mining processes successfully, not even God can help them much less OLAP or ETL etc would, simply because the main source of the problem is in their GREED to make more money (or havce control over anything on which they require to mine data) thus expecting MIRACLES to happen to them while they're not PROPHETS so God could help them out in that respect!

bless

[eugenea]

Online Analytical Processing, or OLAP, is a powerful data discovery tool designed to enable users to perform multidimensional analysis of data. It aids users to access, extract, and view data (using a computer) from different perspectives or points of view.

[Intricity]

Online Analytical Processing is a very abstract name in my opinion. I've found that spelling out it's acronym just glazes people over trying to make sense of it.

[RIDDLEMASTER]

So if I understand it right, in the old days a regular transaction data was taken and turned into dimensions in the cube for further "slice and dice", while nowadays, the transaction data goes though ETL into a star schema which I can load to a visualizing tool (like Tableau) and "slice and dice it there"?

[halebale]

Great explanation and very good animation!

[StopWhining]

FYI: OLAP = online analytical processing

[sundaramg]

Can u plzz suggest which tool is used to exectute data into datacube

[SaurabhGupta-ltsv]

The speaker don't know how to explain

[richhemmings]

Came to your page via Brent Ozar for Column-based dbs - these videos are great! Very well explained! 

[sumayahghamdi]

Beautiful, Beautiful Presentation
Thank you SO much

[sarahetc]

Thank you! Very helpful! Great vulgarization of the concepts

[RichardSmartTelco]

this is great. So many bells ringing in an order I can kinda make sense of... finally!

[nafegogo]

A very nice presentation! Well organized and clear information! Liked it!

[schtat]

brilliant - crystal clear explanation, thanks

[lecadou]

i don't know how many times people comes to our office ( or suite) to ask for one cube or another. this is very interesting.

[immehtabh]

Nicely explained the basic fundamental use of OLAP. Looking for more connected clips for self learning!

Now, "I know... OLAP"! :)
Thx! Great video.