The company has developed more than 30 QlikView analytical reports, which are used by more than 250 employees.

​

The top management of the company, as well as VTB Group, is provided with weekly management reporting from QlikView, which includes the main indicators of the company's activity - plan-fact analysis of sales, visualization of forecasts, reports on insurance products, business segmentation and so on.

​

Key users and their tasks:

• Finance Department. The first users of QlikView appeared in the Finance Department - financiers needed regular reports on financial indicators in more than 20 different sections. Now financiers receive full information about losses, reserves, financial results (premiums, insurance amounts, unprofitability), can calculate RNP and IBNR “on the fly” on any date.

• Top Management. Management reporting from QlikView is provided on a weekly basis to the company's management, as well as to VTB Group, and includes key performance indicators of the company - plan-fact analysis of sales, visualization of forecasts, reports on insurance products, business segmentation, etc. The underwriting department is responsible for the management of the company.

• Underwriting Department. Underwriters use financial applications to analyze risks by products, types of insurance and analyze motor insurance.

• Sales Department. Uses a BI system to track marketing campaigns and segment the customer base based on history of customer relations and communications, sales and renewal of insurance contracts.

• Operations department. QlikView helps the operations unit to improve the quality of data control - we have developed a model for handling incorrect data, which recognizes more than 100 types of errors related to operational input into accounting systems. In addition, operations management uses the BI system as a tool to monitor the contract cycle, analyze and optimize the process.

• IT Department. IT staff developed utilitarian applications to track BI system performance, including both technical aspects, such as server load, and user aspects, such as which applications are most frequently customized, who uses analytics the most, and who, on the contrary, does not access it often.

• From the atypical for BI: the analytics system helped to automate communications with clients. In conjunction of QlikView with NPrinting report distribution product and communication systems, we configured the preparation of reports for automatic client distribution by e-mail and sms. Reminders about contract renewals and upcoming payments are sent out automatically, and customer call lists are generated for the call center.