Bloggurat
          rss       feed       personal mail       professional mail       msn       facebook       linkedin        

Friday, November 11, 2005

OLAP defined


What is this OLAP thing?
Almost a year ago, I spent an entire week on the ultimate Business Intelligence course. I have taken and passed the corresponding brainbench tests (Data warehousing and OLAP). Still I must admit that I am not confident about OLAP (especially MDX). Having lots of stuff boiling in my sub-conscious mind, I will get there eventually (maybe I am a bit slow, he he). And my guess is that any BI specialist confident about their understanding of leveraging OLAP technology, has stopped developing.


googling
Wikipedia (initially) states
“OLAP is an acronym for online analytical processing. It is an approach to quickly provide the answer to complex analytical queries.”

google define gives eg.

www.georgetown.edu/uis/ia/dw/GLOSSARY0816.html
On-line retrieval and analysis of data to reveal business trends and statistics not directly visible in the data directly retrieved from a data warehouse. Also known as multidimensional analysis

www.intoweb.co.za/it-terms.php
On-line Analytical Processing. Information analysis that pass the FASMI test: Fast Analysis of Multidimensional Information.


Aha!
FASMI: Fast Analysis of Shared Multidimensional Information. The summary description of OLAP applications used in The OLAP Report, and now very widely referenced elsewhere.
http://www.olapreport.com/fasmi.htm: We think that the FASMI test is a reasonable and understandable definition of the goals OLAP is meant to achieve.


Definition
So, here some of my own definitions (it depends on what angle you want to see it, of course):
OLAP (personal): An interesting possibility I would like to be more involved with.
OLAP (informative): A tool for converting data into actable information.
OLAP (technical): Information analysis that is fast, statistical, multi-dimentional, ad hoc, secure and built on a large amount of data.
OLAP (for the dba): All the groupings and aggregates you can do on a dataset precalculated.
OLAP (measurable): Analysis leveraging a tool that passes the FASMI test.

(F)ast
Tools must give most answers in less than five secounds

(A)nalysis     
It should be possible to add value to the data, converting it to information, being data mining, statistical formulas, score-carding, exception alerting or other special applications

(S)hared     
Integrate into the security model and following any complaience requirements

(M)ultidimentional     
This is not hard to understand: it must take into account more than two measures at a time, eg. the three or four: "what is it", "where is it", "when is it" and possibly "is it".

(I)nformation     
Much information. It must be able to gather, manage and use much information.


Thanks
Thanks goes to two undisputed geniuses
Reed Jacobsen, genius, Hitachi
Kamal Hathi, Lead Program Manager (=genius) for SQLIS (DTS/ETL) (SQL Server 2005) and (Lead, I think) Program Manager for OLAP (SQL Server 2006+), Microsoft

28 Comments:

Blogger Tito Maury said...

Hello,

I am searching for fresh information
for my etl spain , 30,000 daily updated Information Pages about all kind of subjects.

It might interest you to know that your blog has been visited and has been read. I hope you enjoy your "Blogging".

I wish you all the luck I can, keep the good work going!

Kind regards,
Jos
etl spain

2:21 AM, January 26, 2006  
Blogger Tito Maury said...

Good morning gorm_norway, I find it quite refreshing to occasionally find a post such as yours with a different topic completely. It somehow ads to ones little list of lifes experiences.

I seem to have a soft spot for blogs related to
# #LINK## and /or sites that have a central theme around submit articles type items. I guess this comes from being a webmaster as well.

3:55 AM, January 27, 2006  
Blogger Crazy Dan said...

Good morning gorm_norway, I find it quite refreshing to occasionally find a post such as yours with a different topic completely. It somehow ads to ones little list of lifes experiences.

I seem to have a soft spot for blogs related to
# #LINK## and /or sites that have a central theme around submit articles type items. I guess this comes from being a webmaster as well.

1:52 AM, January 28, 2006  
Blogger Crazy Dan said...

Tis the season! I was searching the web and found your entry OLAP defined I really like your site and found it worth time reading through the post. I am looking to publish a comprehensive site ranges many types of historical needlework. All those interested in this area will find this article of interest as it is written from many perspective. Please feel free to take a look at my blog at etl tools and add any thing your want.

3:15 AM, February 01, 2006  
Blogger Crazy Dan said...

Tis the season! I was searching the web and found your entry OLAP defined I really like your site and found it worth time reading through the post. I am looking to publish a comprehensive site ranges many types of historical needlework. All those interested in this area will find this article of interest as it is written from many perspective. Please feel free to take a look at my blog at etl developer and add any thing your want.

3:16 AM, February 01, 2006  
Blogger gorm_norway said...

>>> "Please feel free to take a look at my blog at etl developer and add any thing your want"

Greetings, Dan

OK, I'll put a copy of "OLAP defined" there for starters
How?

Gorm

3:47 PM, February 01, 2006  
Blogger Tito Maury said...

Hi i am totally blown away with the blogs people have created its so much fun to read alot of good info and you have also one of the best blogs !! Have some time check my link to !! ##LINK

2:07 AM, February 03, 2006  
Blogger Crazy Dan said...

I have a
etl spain site/blog. It pretty much covers OLAP defined related stuff.
Come and check it out if you get time :-)

1:13 AM, February 07, 2006  
Blogger Tito Maury said...

Cheers,
etl certification

1:27 AM, February 08, 2006  
Blogger Tito Maury said...

Your one of my favorite people now gorm_norway. Great Blog! I'm sure glad I found your information... thank you for the knowledge! If you are interested, go see my etl certification related site. It isn't anything special but you may still find something of interest.

1:28 AM, February 08, 2006  
Anonymous Anonymous said...

compare car insurance
car insurance quote canada
progressive car insurance quote
texas car insurance
young driver car insurance
cheap car insurance rate
car insurance estimate
florida car insurance
car insurance san diego
car insurance estimate
auto insurance quote
agent car company home insurance life quote rate
car insurance
young driver car insurance
auto cheap insurance
low car insurance
car insurance cost
auto insurance company
car insurance canada
young driver car insurance
new york car insurance
rental car insurance
car insurance quote canada
free car insurance quote
new york car insurance
low cost car insurance
texas car insurance
car insurance for mexico
churchil
l car insurance

car insurance quote

http://cheap-car-insurance.quickfreehost.com

Random Keyword: :)
car insurance group

2:53 PM, January 15, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

6:08 AM, January 18, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

6:31 PM, January 19, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

5:39 AM, January 26, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

10:08 PM, January 27, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

12:37 PM, February 10, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

1:18 PM, February 12, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

3:52 PM, February 14, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

11:31 AM, February 15, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

1:06 PM, February 15, 2007  
Anonymous Anonymous said...

MESSAGE

10:14 PM, February 15, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

10:14 PM, February 15, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

4:03 AM, February 20, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

10:39 PM, February 20, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

5:59 AM, February 22, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

12:12 PM, March 01, 2007  
Anonymous Anonymous said...

http://www.adquity.com

Classifieds for our community. Buy, sell, trade, date, events... post anything. Adquity Classifieds.

http://www.adquity.com

1:14 PM, March 06, 2007  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

1:35 PM, March 08, 2007  

Post a Comment

Links to this post:

Create a Link

<< Home