This thesis has two primary objectives. The first is to develop the data mart layer of the data warehouse with a new, complex, multi-source table that integrates extensive claims information. The second objective is to use the data extracted from this table to test specific hypotheses regarding various factors affecting insurance claims and subsequently model the claim amount. Specific requirements for the content and structure of the new table in the datamart, part of the XDWH data warehouse pr... show full abstractThis thesis has two primary objectives. The first is to develop the data mart layer of the data warehouse with a new, complex, multi-source table that integrates extensive claims information. The second objective is to use the data extracted from this table to test specific hypotheses regarding various factors affecting insurance claims and subsequently model the claim amount. Specific requirements for the content and structure of the new table in the datamart, part of the XDWH data warehouse project, were developed in close collaboration with the analytical team. The specifics of this project were described, including the functioning of the team, the structure of the data warehouse and the data flow process within it. The implementation of the XDWH extension was done in SQL, and after thorough testing, the code was deployed to the production environment. This spreadsheet is key for the insurance company as it provides an integrated view of claims data from multiple sources, significantly improving the ability to analyze risks and trends in claims. This allows for better identification of patterns and causes of claims, leading to more efficient setting of insurance rates and terms. In addition, with this information, insurance company analysts can more accurately model potential financial impacts and predict future claims, helping to optimize reserves for claims. Finally, this spreadsheet enables faster and more accurate reporting, which is essential to meet regulatory requirements and maintain transparency of operations. |