MSBI -- Data Warehousing Concepts -- Part-1

What is Data Warehousing:

             A Data Warehouse is 

1.     Subject-Oriented

2.     Integrated

3.     Time-Variant

4.     Non-Volatile 
                                        Collection of Data, which is used for effective decision making of organisations High & Middle Level Management.

1.   Subject-Oriented: 

                              In Data Warehouse we can store each subject related data separately in terms of Data marts.

DataMart: 

                     DataMart is a subset of Data Warehouse which deals with particular Department data.

2.   Integrated: 

                              Data Warehouse data is Integrated data from multiple source systems.

3.   Time Variant: 

                              Historical It is not possible to take Analysis with referring time.
Each Record in Data Warehouse will be related to particular point of time.

4.   Non-Volatile: 
                                  The Data Present in Data Warehouse is Non-Editable.