OLAP
Another important area of Logexsoft's activities is the application of Data Warehouses (DW), Executive Information Systems (EIS) and On-Line Analytical Processing (OLAP) technologies for providing decision support for executives and managers. Software systems based on DW, EIS and OLAP technologies have proved to be efficient in assisting managers by providing quick and easy access to information that is critical for making adequate decisions in complex business environments.
The concept of building DW has been established due to a recognized need for providing easy access to integrated up-to-date data related to various aspects of a company's operations.
Why is there a need for building Data Warehouses?
Data accumulated in the majority of companies often cannot be efficiently used in the framework of traditional information systems. The main reason for this is that traditional corporate information systems are based on transactional databases that are not designed for providing fast and efficient access to information. Neither are they designed to present the results of information queries in an easy to understand manner, which is often critical to support decision making processes. The main limitations inherent to such information systems are as follows:
Managers responsible for decision making are not provided with direct access to historical business data accumulated over a significant period of time; Data required for analysis are typically distributed among a number of isolated information systems servicing the needs of different departments of a company; Complicated queries on a database tax the system and response time usually gets excessively high; Data models used are not suitable for decision support systems since they were specifically designed to handle short transactions only. Because of such limitations, the data stored in traditional systems cannot be efficiently retrieved by managers and analysts involved in decision making.
DW technology, offered to businesses by Logexsoft, eliminates these problems by storing current and historical data from disparate information sources required for business decision-makers into a single, consolidated data warehouse based on utilizing multi-dimensional data modeling techniques. These multi-dimensional data objects provide a conceptual link between groups of related data and the company's business processes. This approach makes data and information readily accessible and eliminates the excessive time required by on-line operational staff to compile data from different sources and then perform the necessary analysis. Deliverables of the Technology
Data Warehouses provide for:
- Efficient analysis and monitoring of the operational and financial data of an entire company, as well as the company's divisions and subsidiaries;
- Evaluation of internal and external business factors related to the operational, economic and financial conditions of a company and its stock performance.
- Analysis of production capacities, volumes and nomenclature of produced goods by division, enterprise and region;
- Analysis of raw materials and finished product transportation;
- Operational and financial analysis of all business activities;
- Evaluation and monitoring of the distribution and sales systems.
- Logexsoft provides its customers with services in building data warehouses and systems for on-line analytical processing. Our consultants work closely with the customer, transferring the state-of-the-art technologies of developing, updating and maintaining DW information systems. Logexsoft has experience with the most advanced software tools currently available for building DW and OLAP applications (PowerPlay, OracleExpress, EssBase, Forest&Trees, etc.).
