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
microsoft_powerbi_logo
microsoft_sql_server_logo

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