Case Study: Companhia de Seguros Tranquilidade achieves sub‑hour queries and daily reporting with Pivotal Greenplum Database

Companhia de Seguros Tranquilidade Utilizing better and faster intelligence to improve strategic decision making

Companhia de Seguros Tranquilidade is a leading Portuguese insurer founded in 1871 with a nationwide network of corporate, franchise and agent stores serving over 600,000 clients. The company struggled with a complex legacy data architecture—SAS files spread across eight departmental data marts—which made reporting slow, error-prone and available only to technical specialists, forcing monthly reports that took up to 48 hours to generate.

Tranquilidade implemented the Pivotal Greenplum Database, consolidating raw data into a single, scalable MPP data warehouse that simplified access and enabled department-wide querying. As a result query times fell from 48 hours to under an hour, reporting cadence moved from monthly to daily (and some reports to weekly), external partners gained near-real-time access, Big Data integration and predictive analytics became possible, and reporting costs and turnaround times were significantly reduced.

Tranquilidade