Power BI in ICT for Monitoring of Insurance Activity Based on Indicators of Insurance Portfolios

Abstract

The article proves the relevance of operational business intelligence in insurance in terms of VUCA-world. For this purpose, the use of Microsoft Power BI software as a method of information and communication technologies, its purpose and benefits for business monitoring are considered. Among the advantages of using Microsoft Power BI is the analysis of existing insurance contracts and current indicators of insurance portfolios. The research substantiates the feasibility of operational analysis of insurance activities based on the calculation of indicators of insurance portfolios that form insurance statistics, which provides results in real-time. This approach eliminates the shortcomings of common means of retrospective operational analysis based on financial statements. Within the research, the insurance portfolio is defined as a set of insurance contracts for a separate line of business of the insurer on a certain date. It is emphasized that for each date of insurance activity the insurance portfolio is a unique set of contracts. A positive factor in the article is the possibility of timely response of managers to fluctuations in the profitability and technical risk of insurance portfolio. The application of the studied elements made it possible to propose a method of monitoring insurance activities based on the calculation of indicators of insurance portfolios and their visualization on analytical panels (dashboards).