Avante DMP analytical data warehouse allows companies to solve problems of collecting, processing and analyzing large volumes of information, building reports or providing this information for further processing in BI systems.
Avante DMP allows to make the intelligent analysis of huge data arrays, quickly form aggregated reports, effectively solve problems of correlation of heterogeneous data, reduce the burden of queries on transactional systems, expand data accounting structures caused by various changes in the organizational structure of the company.
The data warehouse building approach used in Avante DMP for integration of heterogeneous data sources is fundamentally different from the approach of dynamic integration of heterogeneous databases.
The system performs normalization, unification and integration of heterogeneous data in a single storage. Data can come from the repository of historical information, operational databases (CRM, Billing, Service Desk, Inventory, etc.) and external sources.
Based on the results of processing, Avante DMP puts the data into "showcases". Showcase is a set of axes and data for further processing by BI tools. Usage of BI tools allows to add columns from the showcases in real time, so client can build visual forms of reports and change their format on their own. Avante DMP includes a basic tool for building and displaying reports. This tool can be used together with complex BI systems.