New Business Intelligence and Analytics Landscape for a Ins…

INTRODUCTION One of Germany’s largest insurers needed a partner to implement a new,

modern business intelligence and analytics landscape based on the AWS Cloud. Consulting services were required in the area of strategic and conceptual consulting and conceptual consulting as well as in the concrete implementation. CASE DESCRIPTION The insurance company planned to establish a new BI and analytics landscape based on Amazon Web Services (AWS) and needed to create this based on a cloud strategy with a common database to cover requirements from analytical use cases and big data. The existing technology stack was to be questioned and, if necessary, replaced.

Suggested architecture:

Overall, the architecture aimed to transform raw data delivered by source systems into information useful to end users. This supported rational decisions by users in a data-driven organization.

The source systems on the left provided the necessary raw data. These can be operational systems such as PARIS and SAP but also user-generated files in structured or unstructured file formats (Excel, CSV files, forms). External parties can also supply or provide this data (e.g. telematics data). The delivered data is then recorded in the data lake. In the architecture, the data lake is fully inte- grated and is used to record data deliveries that are independent of itself. These are initially ingested in the data lake in raw form without further transformation or preparation. However, the data is organized so that it can be efficiently accessed later. The proposed architecture implements this reusability efficiently and consistently; thus, not only can data be reused but also the results of the business logic can be as well. This harmonized the data-driven solutions of the clients and made them comparable.

2/3