The purpose of the databases behind the business systems used in the day-to-day running of the company is to ensure that the software operates quickly and efficiently in all cases. In these systems, a huge amount of data accumulates during use. These data need to be analyzed during the preparation and support of decisions, the preparation of medium and long-term plans, and the management of work processes.
The data structure of transaction systems is not designed to support business decisions. Without a data warehouse, decision preparation is done manually, using a lot of resources. Data sorted from different systems are transformed and integrated into a report. In the case of a protracted decisions, keeping the reports up to date and reproducing them a month or two later is an additional problem.
To solve the problems, the company’s information service is usually placed on a data warehouse. One of the most important tasks of a data warehouse is the integration of data in different source systems and at the same time the unification of the company's data assets. In the life of well-functioning companies, the data warehouse is the reference source of information that is accepted and trusted throughout the organization. A data warehouse not only serves as a basis for analysis, in many areas within a company it considered to be the primary data source for analytical and statistical systems. Thus, the data marts that build on the data warehouse satisfy different levels of information needs.
The hunger of information for business users requires the availability of tools that enable the utilization of strategic information. Today, a leader is no longer content with lists printed on paper, but wants to use Dashboard, Scorecard technologies in a self-service way, which can only be based on a separate data warehouse.