zeb//control warehouse

Integrate and explore your data!

Create a standard database

One of the success factors for the interaction of the various products in zeb//control is a uniform and consistent data warehouse. This task is performed by zeb/data-warehouse. All the structures which are of relevance for evaluations, such as organisational and customer structures or portfolios, are stored in this system. zeb/data-warehouse integrates all management-related information on all balance sheet and off-balance sheet transactions performed by your bank.

The system's open architecture enables you to add to the data volume as required and flexibly adapt it to changing corporate structures.

• The automated interfaces can be used to transfer all customer transaction data, import it into the system and make calculations using the market rate or present-value method.
• You can also import data from various bank-specific upstream systems (cost accounting, personnel administration, etc.). This provides you with a comprehensive, internal controlling database.
• Via the zeb //control frontend, the administration of the ETL process may be simplified by the respective data controller.
• To ensure data quality, a validator is incorporated in the process which automatically recognises missing or corrupt data.
• Comprehensive data and information management tools will assist you with the identification and correction of mistakes along the data flow.
• Manual deliveries or corrections can be conducted with the zeb//control frontend in an auditable manner.
• Structured data warehousing and preparation enables you to precisely analyse your bank's income structures.
• You can store all proprietary trading transactions so that current positions and limits are provided for risk measurement.
• At the same time, you can obtain a historical evaluation of the performance statement. Evaluations by identifier code, securities class or trading segment are also possible.