Über den Kunden

Client is a privately owned bank and was founded in 1590. It is one of Europe’s leading private banks with 1600 employees in different departments. Its headquarters is located in Hamburg where it is led by managing partners. It has offices in Frankfurt, London, New York and Zurich, among other financial centers.

Problemstellung

For faster results the bank wanted to provide their users the ability to build and adapt their own self-service BI platform without the need of IT support. Moreover, it also wanted to build a data warehouse that would be capable of producing internal and external reports from a single source while also displaying all relevant data from across the enterprise.

The current database did not support the above use cases due to its following design constraints:

  • Data quality and scalability
  • Single-table storage systems with huge amounts of data were harder to maintain

Die Herausforderung

To implement the data vault based solution to solve the problem there were the following challenges that had to be overcome:

  • Limited memory to store data
  • The code was not accessible to everyone
  • Due to limited disk storage, complex calculations become a problem

Die Lösung

The client was offered a solution from Scalefree that included:

  • An agile approach to manage projects into fixed-length sprints
  • A high performance system regardless of volume and velocity
  • A flexible data model that has no limitation to add new data and refactor existing data
  • A reference architecture that has the capability to support big data concepts and supports the integration of NoSQL data sets and real time data

Konkrete Ergebnisse für den Kunden

The project provided the following results for the bank:

  • The bank was able to create auditible solutions
  • Fully-automated parts of the data warehouse were able to help the client make less errors as compared to manual development of SQL statements and ETL processes
  • The bank was able to achieve a higher level of data security and privacy
Manage Self-Service BI for Useful Reporting
Manage Self-Service BI for Useful Reporting
Manage Self-Service BI for Useful Reporting
Manage Self-Service BI for Useful Reporting

Verwendete Technologien

  • MID
  • AnalytixDS
  • Wherescape
  • Excel
  • Tableau
  • SaaS
  • QlickView

Möchten Sie mehr erfahren? Holen Sie sich die ausführliche Fallstudie!

Vereinbaren Sie einen Termin mit uns

Profilfoto von Jürgen Dackweiler
JÜRGEN DACKWEILER

SALES MANAGER

Telefon: +49 (511) 879 89342
Mobil: +49 (175) 811 0336