Insurance

Corporate Analytic Model

Data warehouse and analytical model of the areas of production, portfolio, claims and finance.

GOAL

Optimize commercial and actuarial management by monitoring results on a daily basis.

Continuous push of commercial information and technical results at all levels, from managers to agents.

Automation of financial processes by business lines.

STRATEGY

  • Incorporation of all company data sources.
  • Normalization.
  • Data warehouse design and processes.
  • Analytical model design / semantic layer.
  • Creation of a reporting portal (SSRS, Excel, Power BI, mobile).

RESULTS

  • Guaranteed traceability and data integration.
  • Creation of a classification engine for mediators and clients based on commercial criteria and technical performance.
  • Data availability on mobile devices.
  • Immediate availability of information and results.
19,493 million in premiums

19,493 million in premiums

13 lines of business

13 lines of business

96,155 policies

96,155 policies

Related Projects