Quantemplate Integrate is a suite of self-service data preparation and integration tools, enabling business users who understand the data to control how it is transformed. This video shows a full workflow demonstration of a bordereaux cleansing scenario: harmonising disparate data sources from multiple MGAs / Coverholders, then analysing and sharing that data.
Read more about Quantemplate's Bordereaux Management solution.
- Import data in range of formats and define the structure
- Map column headers to a common schema aided by
- Map data values such as company names to a consistent
- Join premium and claims data to precisely determine exposure
- Join external data to enrich bordereaux
- Cleanse invalid data
- Add calculations to determine profitability
- Analyze the data with Quantemplate’s business
intelligence tools to gain actionable insights
- Automate Solvency II reporting including data exports for
Annual Solvency Returns, ASR 249, 250 & 252
- Share data with regulators and following underwriters