InsuranceData Engineering

Dashboards and Report automation for the commercial development of a startup

A startup in the insurtech industry manages its insurance policies through INSTANDA. However, certain problems regarding data handling were observed.

Industry: Insurance
Solution: Data Engineering

Book a meeting

Success Case: Dashboards and report automation for the commercial development of a startup in the insurtech companu

01 / 03

The challenge

A US startup company in the Insurtech Industry dedicated to the sale of property flood insurance, manages the sales, payments and management of its insurance policies through INSTANDA.

However, the company's management observed certain problems regarding the handling of its data.

When making decisions at the managerial level, they were based on inaccurate or incomplete data. Not having a proper visualization of their data, there was not a clear understanding of what was happening in the company and this caused the wrong decisions to be made.
Vast amounts of time and effort were involved in trying to understand anda analyze data without visualization.
There was difficulty in communicating results and trends to the different teams of the company, and to the agencies when evaluating their performance, since the data was not visualized effectively.
They did not have an easy way to spot patterns and trends as these were not apparent in a data set simply by looking at tables and numbers. This, in turn, impeded the prediction of future behaviors and the ability to plan accordingly.

02 / 03

What Tekne did

Objectives

This company wanted to achieve a better management of its data by:

Optimizing the search and access to the INSTANDA generated data.
Having their data in an orderly and efficient way to be able to establish priorities, draw conclusions, detect patterns, predict future behavior and generate business strategies based on it.
Automating the sending of monthly reports to their insurance agencies so that they could carry out an analysis of their monthly performance.
Building of analytical environment that allowed scalability without the loss of quality in services.

Proposed solution

We worked in tandem with the company to carry out business and technical evaluations in order to identify the best solution for their data access and visualization problems.
After our initial meetings, it was agreed to implement an analytical platform that allowed the creation of a series of dashboards and reports, both internal and external, that visually organized the data, in order to achieve better general and operational management of the company and, consequently, facilitate the decision making process. This was implemented in a centralized repository, with a scalable data architecture, thus facilitating the use of data in analytical applications (Interfaces - APIs, reports and Dashboards).
The development of various Dashboards with indicators and visualizations agreed with the company for the global vision of its operations was also defined.
The generation and sending of external reports to the various insurance agencies was automated so that they could obtain a monthly review of their performance and make decision or draw conclusions based on it.
We continue with the advice and collaboration with the company with the objective of establishing good practices in data management and facilitating the rapid implementation of technological tools for management.

Architecture

03 / 03

Results

After working with us, the company has:

Dashboards that make it possible to know the situation of the company in relation to the sales of insurance policies, and the assembly of commercial strategies. These have indicators such as:
- Bound policies
- Cancelled Policies
- Total Quotes made
- Agencies/Users Actively Quoting
- Total Insured Sums
Automated generation and monthly sending of external reports to insurance agencies, which allow them to evaluate their performance, draw conclusions from it and make the necessary decisions.
A safe and efficient environment to provide data to Dashboards and applications quickly, optimizing infrastructure costs.
Tools that enable the communication of internal company applications with products and services from other companies.
An environment that allows scalability, that is, that can be adapted without losing quality in services with continuous growth in a fluid manner.