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:
- Data consolidation (merging of associated data from various systems)
- Unification (merging of identical entries from various systems into one)
On the other hand, we were also creating an on-line database with core client data, closely associated with the data warehouse.