(11)What are the benefits of data warehouse?

Answer: Following are the benefits of data warehouse:

 

(1)Helps in understanding the data:

•  Data warehouse helps an organization to better understand the data that it is currently being collected and, equally important, what data is not being collected. 

(2)Centralized View:

• Data warehouse helps in centralized view of all data being collected. 
•  It also provides a means for determining inconsistent data.

(3)Data Consistency: 

• Consistent data helps in generating correct and accurate information
• This is important when the company wants to report consistent statistics such as revenue or number of employees.

(4)Historical Records:

• Data warehouse helps in capturing snapshots of data over time.
• It creates a historical record of data which helps in analysis of trends.

(5)New Information:

• Data warehouse helps in combining various data. 
• This provides new information and analysis.