Most read

Automation Data Platform Energy Financial Retail Analytics
Real-time trading dashboard as a competitive advantage
Back to overview

Customer Story

Fast and simple risk management

For the European DataWarehouse (ED), Trivadis has developed a solution in the Azure Cloud that enables banks to analyze and compare securitization portfolios.

In Short

CHALLENGE

Raw data in CSV and Excel format cannot be aggregated and visualised.

SOLUTION

Intelligent complete solution: a data warehouse based on Microsoft SQL Server in the Microsoft Azure Cloud.

BENEFIT

Fast, simple risk analysis to analyse and compare complete securitisation portfolios

Our solution

This detailed information is mainly used by investors, but also by investment banks, brokers, data vendors and rating agencies. Up to now, it was made available as raw data in Excel and CSV format. What was lacking, however, was the capability to quickly aggregate and visualize the data. The objective was therefore to enable data users to compare and analyze entire portfolios within a short period of time. It should also be possible to access the data easily and from any location. Installation of software or specific firewall activation settings at the customer end were to be avoided at all costs to allow the data to be used directly and with no routing delays. At the same time, demanding requirements have to be fulfilled where data availability is concerned. Secure access to the data was also essential.

Retaining proven elements

The focal point of this project was on the one hand simple usability, while on the other it should be possible to retain proven elements of the risk analysis with regard to possible variable data analyses:

  • Retention of the front end familiar to all end users -> user acceptance
  • Total variability in the user interface (Microsoft Excel) -> simplicity
  • Data transfer via the HTTP/HTTPS protocol -> no specific port activations or software installation at the user end required
  • Microsoft Windows Azure environment -> variability
  • Microsoft SQL Server Analysis Services (multi-dimensional) -> aggregated values for direct access

Data is uploaded via ETL processes to a Microsoft SQL Server-based data warehouse in the Microsoft Azure cloud. An OLAP Cube provides aggregated values in line with the technical requirements for direct access by end users.

Trivadis understood our needs: professionally and technically. The combination of banking and IT know-how ultimately made the decisive difference on this complex project.

Markus Schaber, CEO, European DataWarehouse GmbH

Cloud approach: flexible, scalable and agile

In view of the anticipated high growth, both in terms of the data volume as well as the number of users, the cloud approach offers the highest possible degree of flexibility, scalability and agility. The extremely simple access possibilities mean that future risk analyses can be displayed from practically any terminal. This contributes decisively to raising user acceptance and satisfaction. Using the Microsoft cloud meant that this project could be implemented very quickly as there was no need for cost and time-intensive hardware procurement, commissioning and productive use concepts – and consequently costs. European DataWarehouse now disposes of an all-in-one solution that helps to accommodate customer requirements faster and with higher capacities.

ABOUT ED

The European DataWarehouse GmbH was established in 2012, and offers a repository and analysis service for the fixed income market (European ABS market) in the field of loan and bond level data.

Technologies used

  • Microsoft SQL Server
  • Microsoft Azure Cloud
  • Microsoft Excel

More stories

AI Cloud IoT Analytics Data Platform Microsoft Health Care
How artificial intelligence helps children breathe
Data Platform Cloud Automation Microsoft Automotive Analytics
With central data plat­form to the self­driving car
Data Platform IoT Cloud Microsoft Public Administration Analytics
Platform analyses and visualises large amounts of data