Data warehouse in insurance

Challenge

The aim of the project was to develop a data warehouse with new information areas, as well as to implement practices related to data management (data quality, data lineage, data governance). An important aspect of the project was the development of integration of the on-premise data warehouse with the Microsoft Azure analytical ecosystem.

Solution

Microsoft SQL Server (baza danych, SSIS, SSRS)
PowerBI
Informatica

Result

Implementation of data martów, allowing the analysis of actuarial data; including the reconciliation of the results with the General Ledger
Collaboration with the Group to develop guidelines for data warehouse architecture
Implementation of a data quality monitoring tool

Building a repository of actuarial data

Enabling reporting

Enabling insurance risk management