What is Business Intelligence?

Business Intelligence is Transformation of raw data into a meaningful and useful information for business purposes

Data Warehouse Concepts

What is a Data warehouse? Why we need Data warehouse?

 What is a Data warehouse?

A data warehouse is a relational database that is designed for querying and analyzing the business but not for transaction processing. 

It usually contains historical data derived from transactional data (different source   systems).

A Data warehouse is a Subject oriented, integrated, time variant and non-volatile collection of  Data used to support strategic decision Making process.

Characteristic features of a Data warehouse:

1.Subject-oriented

2.Integrated

3.Time-variant

4.Non-volatile 

1.Subject-oriented:Data warehouses are designed as a Subject-oriented that are used to analyze the business by top level management, or middle level management, or for a individual department in an enterprise.

2.Integrated: A data warehouse is an integrated database which contains the business information collected from various operational data sources.

3.Time Variant: A Data warehouse is a time variant database which allows you to analyze and compare the business with respect to various time periods (Year, Quarter, Month, Week, Day)  because it  maintains historical data.

4.Non-volatile:A Data warehouse is a non-volatile database. That means once the data is entered into data warehouse ,it cannot change. It doesn’t reflect to the changes taken place in operational database. Hence the data is static.