Thursday, July 31, 2008

DATA WAREHOUSE


What is a data Warehouse?



"A warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process".

subject-oriented : Data that gives information about a particular subject instead of about a company's ongoing operations.

integrated : Data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole.

time-variant : All data in the data warehouse is identified with a particular time period.

non-volatile : Data is stable in a data warehouse. More data is added but data is never removed. This enables management to gain a consistent picture of the business.


What is Data WareHousing?

Data warehousing is essentially what you need to do in order to create a data warehouse, and what you do with it. It is the process of creating, populating, and then querying a data warehouse.


Data WareHousing tool

SAP-BW, SAP-BI (7.0, the latest version).

There area three data warehousing functions:

1. Modeling
2. Extraction
3. Reporting

Modeling : This talks about, the architecture and design of the data objects, how you are going to store the data and where and what type of data.

Extraction: This is about how you are loading the data from OLTP (R/3) to OLAP (SAP-BW). In this process, you will take care of filtering the data and adding up more data based business requirements. Here you have various extractors using which you can extrat data of a particular application.

Reporting: What ever is done till now on a warehouse tool, is ultimtely to generate a report. Reporting is done based on business requirement, for the higher executives to take business decisions after analysing the reports.


6 comments:

Srinath VJ said...

Hi Sateesh,

Very throughly prepared and informative post, keep up the good work!!

What is happening at your BI front, keep in touch.

srinath_vj@yahoo.com

Thanks,
Srinath

Unknown said...

hi sateesh....

its great work frnd.
please send me if you have any navigational material about BI.

iam searching on BW in bangalore, openings are not good.

basically iam from A.P(tirupati)

waiting for your reply


chandrababu.mba@gmail.com


thanks,
chandrababu

sateesh bandi said...

THanks chndra..
let me know , what can i do for you.

sateesh bandi said...

THanks srinath!!
BI , not much.
Have to learn that too..

how are the things from your side?

-sateesh

Hana Max said...

Hi,

very detailed explanation on lo extraction, always got confused after reading any post or blog on
lo, after reading this post I fully understood lo extraction.
Thanks for sharing your knowledge.

Hana

salero said...

hi,

i begin with BI SAP,i'm trying to unserstand cockpit and the different extractors types ( LO cockpit,generic ... )

i'm in lack of documentation and i need help !!

thank you for sending me any doc or website that can help me at salaheddine.bentalba@gmail.com

thank you