BI Expert Data warehouse

In the modern world the problem of storage and use of the saved-up enormous information volumes is relevant for a set of the companies. Using this information it is possible to solve different managerial and analytical problems, but difficulties with information warehousing and online access to necessary data, considerably complicate this process. Activity of the specialists working in the field of information technologies is directed to the solution of the matter.

The data warehouse – the modern answer to difficulties of the organization of work with information. Often in need of decision-making it is necessary to use information from several databases of different structure and contents. At the same time there is a problem of inconsistency and inconsistency of the available data due to the lack of a uniform logical view of corporate data. A basis of the concept of the data warehouse is integration of earlier separated unstructured information into the single database.

The data warehouse is aimed not only at business process automation, but also at informative information analysis, and intended for decision support, and its users are a top and average management of the organization, analytics, representatives of divisions of a financial analysis, marketing and other departments.

The data warehouse is designed to be the only source to analytical information in which already at a collecting stage from information systems there is reconciliation, cleaning and standardization of data. Such approach gives to management of the company of a guarantee that in their hands there will be reliable information with uniform analytical structure.

It allows us to judge main advantages of the data warehouse:

• the repeated analysis can be carried out so many time how many it is necessary;
• use of a data mart does not reduce performance of the operating system;
• increase in number of analytic functions and improvement of opportunities of reports generation;
• can be initial data for an analytical system or the existing sources, or specially * organized storages and data marts.

Creation of the Data warehouse on the basis of the Microsoft SQL Server allows to create the scalable data warehouses satisfying to requests as average, and large enterprises.