This is a Business Intelligence system based on a data warehouse enabling the collection and integration of distributed data, as well as their processing and storage in structured business areas.
The system users gain access to the organizational data and get assistance with the generation of ad-hoc reports and advanced analyses. Asseco Data Warehouse can be operated as an independent solution or integrated with other Asseco suite systems. The system features a built-in Business Data Model ensuring consistency and transparency across the reporting process. The integrated control mechanisms enhance the quality of data and provide support for data management responsibilities. The system offers a set of flexible tools allowing business users for modifications and further development of the solution.
Major modules
BDM – Basic Module
Information on concluded contracts. Client profiles. Transactions carried out by clients. Bank accounting books, income statement.
BDM – Sales and Marketing
Profitability of sales: clients, products. Analysis of contract-related events. Analysis of the level of customer activity. Monitoring of products
CMR – Mandatory Reporting
Finrep/Corep, WEBIS ITS NB300, BFG, Cerber, other.
ODS - Operational Data Store
Data integration and consistency. Data cleansing (DQ). Metadata management. Interfaces
Key functionalities
Business Data Model
Data on the organization’s business processes are presented in a transparent and orderly fashion, facilitating their understanding and reporting
Open architecture
Ability to customize the model to match the client’s specific needs and providing the necessary tools to enable independent development of the solution in the future
Business user tools
Providing business users with metadata management tools – defining of business transformation rules, management of data quality rules, reporting tools
Integration of distributed data from multiple sources
Taking advantage of sophisticated ETL tools allowing for the integration of data from various sources, including unstructured data
Empowering the client’s development teams to enhance the solution
Automation of processes
Automatic data feeding and generation of reports, minimizing the task completion efforts
Business benefits
One consistent source of information
Quick access to reliable information necessary for efficient business decision-making and monitoring of key operational areas within the organization.
Boosting the profitability of sales
Advanced tools for the analysis of customer and product profitability that can be used to increase the level of sales.
Reduction of operating costs
Automation of both internal and external reporting processes.
Improved flow of information
Ability to implement automatic distribution of key data and reports within the organization.
Reduction of maintenance costs
Extensive parameterization capabilities of the system. Possibility of independent development of the solution in the future.
Technology stack
ETL tools
Informatica PowerCenter, PLSQL IBM Data Stage, Pentaho, MS Integration Services