Home | Solutions | Goals | Data Consolidation

Page web address: http://www.loginom.com/solutions/goals/data_consolidation/ - return to graphical version

Data Consolidation

Today, most companies are geographically distributed structures and thus use many information systems. Their poorly interconnected programs do not allow prompt analysis of the general situation in the organization. Generation of a very simple report requires great effort to gather data, verify the information from different sources and make it analyzable.

In this case it is advisable to use specialized systems designed for resolving data consolidation problems. Such complex systems make it possible to collect information from various sources, bring the data to a consistent representation and remove redundant and incorrect information. The analytical platform Loginom contains everything necessary for developing such solutions:

  • Data warehouse. Loginom contains a cross-platform storage — Loginom Warehouse, a specialized database into which information from existing data storage systems are loaded. It is designed specifically for processing analytical queries. It contains a convenient semantic layer with which users can extract any information they need without composing complex queries, and working with understandable business terminology. Loginom Warehouse itself performs all the operations required for extracting the data.
  • Support of diversified data sources. Loginom works with virtually any data source: office applications, popular DBMS, ERP-, CRM-, BI-systems, text files, XML and dozens of other sources. Wherever the information is stored, it can be extracted, transformed to the desired form and loaded into the data warehouse.
  • Data cleansing. The data stored in distributed systems nearly always contains different errors, discrepancies and mismatchings. To ensure correct processing, the information must be cleaned and systematized. Loginom offers all the necessary tools: error searching and fixing mechanisms, deduplication algorithms, various data unification and transformation methods.
  • Data enhancement. With Loginom, in addition to loading information from data storage systems to the warehouse, users can also enhance it, adding useful data from different external sources, and merging this with information collected within the organization. Such data, for example about competitors, partners, and the economic environment, allows the quality of the decisions made to be considerably improved.
  • Reports. The consolidated data are most often used for generating different kinds of reports. Loginom supports many types of visualization in the form of various tables, charts, diagrams, maps etc. It contains a full-fledged OLAP module which makes it possible to perform multivariate analysis, handle all the data on-the-fly and generate any type of analytical report.

Loginom is a powerful platform designed for creating data consolidation solutions. It allows implementation of the entire work cycle within a unified system, from gathering information to generating reports. The set of modules included in Loginom allows data to consolidate at any level of the organization, from a small branch to the company’s headquarters.