What is OLAP?
ฝัง
- เผยแพร่เมื่อ 20 ต.ค. 2024
- 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.
Talk with a Specialist: www.intricity....
www.intricity.com
This is excellent. One of the most lucid explanations I have encountered in a very long time. Well done.
Thanks for your kind comments!
I agree with other commenters. The clear explanations + cool animations, make for a brilliant presentation of these concepts. E-learning at its best.
I cant believe I was 9 when this video was uploaded. Now I'm 23 and in college for CS.
Yeah some grey hairs have settled in since then :)
Yea, this video is still hugely helpful haha.
@@Intricity101 wow u still reply after 13 years
@@sontranha3822 Still kicking...
this is great. So many bells ringing in an order I can kinda make sense of... finally!
Came to your page via Brent Ozar for Column-based dbs - these videos are great! Very well explained!
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.
Thank you so much. That was succinct and really well presented!
Beautiful, Beautiful Presentation
Thank you SO much
Nicely explained the basic fundamental use of OLAP. Looking for more connected clips for self learning!
Thanks Bhaskar, take a look at some of the other channel videos on similar topics.
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.
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.
brilliant - crystal clear explanation, thanks
Thank you! Very helpful! Great vulgarization of the concepts
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
very well done. Thanks
This one is an oldie, but it's still relevant!
what software was used in the creation of these videos?
To the point on OLAP well done!
A real good job on OLAP well done!
A very nice presentation! Well organized and clear information! Liked it!
FYI: OLAP = online analytical processing
Well done, Thank you.
interesting view.
great summary
perfect explanation
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"?
Both require the ETL tool to load. But a relational dimensional model isn't a precalculated result set, pigeon holing the direction of the analysis.
Absolutly great
Great summary thank you!
very nicely explained. thank you.
Good explanation, thank you.
Great job!
Thank you so much, help me a lot
Great explanation and very good animation!
Can u plzz suggest which tool is used to exectute data into datacube
Cubes are a technology that today is almost solely used for Budgeting and Planning applications. If it's not for that application I would seek out another avenue. If you are doing Budgeting and Planning, you might want to look at G2Crowd www.g2.com/categories/budgeting-and-forecasting#grid
Thanks ivanosito!
Thanku sir
thank you.
The CC is so far off it makes things confusing.
still don't know what olap is
Thx! Great video
Now, "I know... OLAP"! :)
Thx! Great video.
Nice presentation. BPR
well explained thx
It's laudable to make an effort to explain terms but less so, if facts presented are simply wrong. OLAP is a term based on Codd's rules: www.cis.drexel.edu/faculty/song/courses/info%20607/tutorial_olap/definition_Codd.htm Vendors used it as a marketing means to sell solutions. Nowhere in Codd's rules is the necessity of "pre- calculated" and they never had a clear technical specification. OLAP is nearly entirely about an analysis user experience and nearly every BI tool on every database technology under the sun caters to these principles now. The most widely used "OLAP tool" is a Pivot Table.
Managility Business Intelligence I’m not a purest when it comes to these things. When the devisor of the concept is miles from the user experience, I really don’t care about the devisor, because it doesn’t help explain what people are experiencing in their BI deployments. You’ll notice that we introduce the video by describing the question of whether or not to use OLAP in our architecture. Yes a pivot table is OLAP, but the focus of the video is enterprise BI not personal data sources.
Doesn't answer my point about referring to OLAP as "precalculated". OLAP is a pretty good idea in nearly any BI context. A properly setup data warehouse is in our view a great example of OLAP. The comment about Pivot Tables shows that you are not really across where the Pivot Tables have moved to... I recommend a look at the concepts of "Modern Excel"...
I recommend you read my article titled Goldilocks Guide to Enterprise Analytics, then lets talk. Too much nuance to swim through over youtube. intricity.attach.io/BkJZaQxfz
We just spoke with one of the leading Pharmaceutical Analytics firms in the world. After reading this article, their Chief Architect said, "This reads like the multi-million dollar journey we had to step through to discover scalable analytics." If you're really feeding information to an enterprise, you have to put your personal BI analyst hat down and put your enterprise architect hat on. Feeding petabytes of data to thousands of people isn't something you can just push to an in memory structure and forget about.
I have read your article and agree with most aspects of the architecture presented. It actually matches our approach ( www.agilityplanning.com ) in many ways... ;o) Finally, just for the record: I have not mentioned "in-memory" although I believe this is a feasible approach for a lot of BI project requirements particularly given the options that scalable cloud platforms provide...
@MoMoney8181 Thanks MoMoney!
I love OLAP cubes.
Good big picture!!!
thank you for theses videos , please if is it possible next time make videos with English subtitles
All the videos have English subtitles. Click the CC button in your TH-cam video screen.
nice
ケビンマスクの必殺技だよ
First rate!
good video!! nice animations also! Im not worthy haha poor server
The speaker don't know how to explain
LOL
doesn't*
full of marketing words
What is OLAP? What a terrible video.