CASE STUDY

A custom analytics tool for reinsurance

Purpose-built visualizations that off-the-shelf BI tools couldn't deliver

A bespoke analytics application that ingests any data source, works out its structure on its own, and renders interactive dashboards shaped around how the team actually works.

The Challenge

A reinsurance company relied on detailed model output, but the analyses and visualizations they needed were too specialized to build in Tableau or other BI platforms. They wanted something purpose-built around their data, and flexible enough to absorb whatever source came next.

Off-the-Shelf BI Fell Short
Tableau and similar platforms were locked to a fixed set of chart types, and couldn't express the analyses the team needed.
Specialized Reinsurance Views
Catastrophe exposure maps and bespoke interactive charts that had to be built from scratch.
Disparate Data Sources
Analyses spanned model outputs and varied datasets that had to be explored together.

The Solution

We built the tool from scratch and shaped it around their workflow. It ingests any source, works out the data structure on its own, and renders the specialized, interactive views they couldn't get elsewhere.

Ingest Any Data Source
The tool takes raw outputs from model data, or any other source, and makes them immediately available for analysis, with no per-source setup.
Any Data Source
Raw outputs from model data, or any other source, ingested as-is.
SQL Server
SQL Server
Data stored and served from SQL Server.
Auto-Detection
The app automatically classifies each variable as a dimension or a metric.
React
Interactive Dashboards
A React + TypeScript front end renders the views and interactions.
Point it at a new source and it's explorable immediately, with no schema mapping or manual setup.
Automatic Dimensions & Metrics
There's no manual configuration. The app inspects each incoming field and decides whether it's a dimension or a metric, which is what lets it adapt to any dataset on the fly.
Visualizations Built for Reinsurance
Catastrophe exposure maps and bespoke interactive charts, rendered in the browser with full control over layout and interaction.

Results

New Datasets, No Rebuild
Analysts can drop in a new source and explore it the same day, instead of waiting on a new report.
Faster Analysis Turnaround
Work that once took significant manual effort now happens far faster.
Reusable, Customizable Exposure & Weather Visuals
Customizable exposure maps and time-series weather visualizations that analysts can reuse across portfolios and tailor to each question.

TECHNOLOGIES USED

SQL Server
SQL Server
Python
Python
TypeScript
TypeScript
React
React