Benefits of Data WareHouse : -

• The Enablement of Better Decision Making - As companies are now able to get closer to their consumers than ever before, the corporate decision-makers no longer have to hedge their bets or make important business decisions based on partial or limited data. They're now backed up by facts and statistics housed within data warehouses that can be recalled ad hoc.

• Quick and Easy Data Access - If there's one thing the application economy has taught us, it's that speed is everything. Users can access an array of information, stored across multiple sources, almost instantly. It means you won't be wasting time attempting to manually pull information from various sources, or seeking help from your IT department.

• Consistent Quality Data - Data warehouses gather information from countless sources, but they convert it into a unified format to be used throughout your organization. What does this mean? Well, you can have confidence that each of your departments will be producing results which are in line and consistent with each other, which in turn ensures company-wide accuracy.

• Boosts Efficiency - It’s very time consuming for a business user or a data scientist to have to gather data from multiple sources. It’s far more advantageous for this data to be gathered in one place, hence the benefit of a data warehouse. Additionally, if for instance your data scientist needs data to run a fast report, they don’t need to get the assistance from tech support to perform this task. A data warehouse makes this data readily available – in the correct format – improving efficiency of the entire process.

• Scalability - The top key word in the cloud era is “scalable” and a data warehouse is a critical component in driving this scale. A topflight data warehouse is itself scalable, and also enables greater scalability in the business overall.

• Much Higher Query Performance And Insight - The constant business intelligence queries that are part of today’s business can put a major strain on an analytics infrastructure, from the legacy databases to the data marts. Having a data warehouse to more effectively handle queries removes some of the pressure on the system.

• Provides Major Competitive Advantage - This is absolutely the bottom line benefit of a data warehouse: it allows a business to more effectively strategize and execute against other vendors in its sector. With the quality, speed and historical context provided by a data warehouse, the greater insight in data mining can drive decisions that create more sales, more targeted products, and faster response times.

Features of Data WareHouse are : -

• Subject Oriented − A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations. These subjects can be product, customers, suppliers, sales, revenue, etc. A data warehouse does not focus on the ongoing operations, rather it focuses on modelling and analysis of data for decision making.

• Integrated − A data warehouse is constructed by integrating data from heterogeneous sources such as relational databases, flat files, etc. This integration enhances the effective analysis of data.

• Time Variant − The data collected in a data warehouse is identified with a particular time period. The data in a data warehouse provides information from the historical point of view.

• Non-volatile − Non-volatile means the previous data is not erased when new data is added to it. A data warehouse is kept separate from the operational database and therefore frequent changes in operational database is not reflected in the data warehouse.