Data warehouse

A data warehouse is usually defined as a collection of subject-oriented, integrated, nonvolatile and time-varying data and is structured for querying, reporting and analysis.

The data warehouse, which can include both transactions as well as non-transaction data, is typically used as the foundation of a decision support system (DSS) that aims to meet the requirements of large business user community.

It is situated at the center of a decision support system (DSS) of an organization and contains historical data. The systems have become a key component of the corporate information system architecture, in which they play a crucial role in building business decision support system.

A data warehouse provides and infrastructure that enables users to obtain efficient and accurate response to complex queries. Data warehousing technology is becoming for effective business, business strategy formulation and implementation in a globally competitive environment, wherein larger and larger amounts of data are required to be processed faster and faster for comprehension of its real meaning and impact.
Data warehouse 

Model Financial Drivers

In order for the users to the financial data warehouse to analyze historical performance of corporate operations, you need to make sure that these vital business rules are modeled into your data warehouse.

This is called business intelligence. Business intelligence is what added value from a printed report, to where the model itself can explain exceptions and variance in your data.

A financial data warehouse developed with a focus on human resources data will be able to answer questions about Monday sick leaves, tend in wages for certain departments and other questions related to providing financial analytics for employees in the human resource department.

However, this business intelligence is in most companies mainly located in the heads of salespeople, senior managers, accounting departments and other key people in your company.

The challenge is to transform all this valuable knowledge into rules sets in your data warehouse.

Users of the system are never a very homogenous group, request are coming to the financial department today from east and west for a wide variety of information.

There are a few reasons why this will change. On the contrary, you will probably see an explosion of requests to the system, and to what data it will contain when it goes live.

Thus it is important to conduct in depth research when modeling the system.
Model Financial Drivers