Data warehouse in insurance

Realizations
1

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.

Challenge Image
2

Solution

microsoft_powerbi-ar21.svgmicrosoft-sql-server-logo-svgrepo-com.svgmicrosoft_azure-ar21.svg
  • Microsoft SQL Server (baza danych, SSIS, SSRS)
  • PowerBI
  • Informatica
3

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