MSBI -- Data Warehousing Concepts -- Part-5

                                    As we know that Data warehouse is nothing but a Collection of Data.

  Based on the behaviour of the data, it has been classified into two types.

Types of Data:

                            Any Organization running business has two kinds of data

1.   Master Data

2.   Transaction Data

Master Data:

                          Master data is nothing but a Organizational or High Level Data

                           For Example:

1.     Store

                                                

2.     Customer

3.     Date

4.     And Product so on….

Transactional Data:

                                   Transactional Data is nothing but a Day-to-Day business transaction details.

For Example:

1.     Each store wise Sales Amount Information.

2.     Each employee wise Salary Details.