Equa bank, a new bank on the Czech market, asked Adastra to build them a data warehouse as the core of its bank reporting. On the one hand, we were creating a three-layer data warehouse where only the last layer caters to reporting directly while the other two layers are purely technical, to ensure:
On the other hand, we were also creating an on-line database with core client data, closely associated with the data warehouse.
The project was an exciting challenge as a brand new bank was being built in a very short time.
2 crucial bank reports. We created reporting layers for individual departments – providing support for reporting to the Czech National Bank and to risk departments were the most important. Both have their own specifics – for instance, the risk department creates the final reports itself and all it needs is accurate data.
Part of the data warehouse implementation was what is known as client unification – the merging of multiple entries about clients.
Simple rules were used to determine which entries could be placed together – i.e. for identical clients duplicated in the systems. Consequently, we used the same logic with regard to saving new entries in the online mode. These rules can be easily modified and added, and our solution is fully satisfactory, even though, at the present time, special tools for this particular issue are available.
The data warehouse implementation – i.e. the basic creation of necessary reporting – was realized promptly (within months).
Subsequent phases (such as extending individual reports, creating reporting for other departments) were carried out in gradual steps that changed according to customer changes. This process also depends on the data placed in customer entries. Indeed, it is possible to obtain the data from user applications (Excel, Access etc.). What matters most is the functionality of the online section which is now an inseparable part of automatic bank approvals.
How do you create a data warehouse and bank reporting for a newly established bank? Would you like to know? Keep reading! Equa bank is exactly such a case. Not only that, the bank requested some data from an online data warehouse. No small feat considering the data had to keep its consistency and be integrated in the data warehouse to provide an…
The client is an international company that sells its products worldwide which must report results in an exact and precise way on a monthly basis. Adastra provides the company with a system that guarantees complete overview and accountability of all key indicators, generates annual closing numbers, in addition to forecasts for the end of the…