Case Study: Punter Southall Analytics achieves 12x faster, fully documented bespoke client data warehouses with WhereScape

How does Punter Southall Analytics Build an Automated Data Warehouse for Every Single Client

Punter Southall Analytics (PSA), part of the Punter Southall Group, provides bespoke data warehouses for each of its clients across financial services and payments. PSA’s challenge was delivering fast, auditable builds with full data lineage and documentation for every client while leveraging existing cloud infrastructure (SQL Server, Azure DW) and meeting strict regulatory and compliance needs.

WhereScape supplied an automation platform (WhereScape RED and WhereScape 3D) that allowed PSA to prototype, generate code onto Azure and produce metadata, lineage and audit trails automatically. The result: PSA cut build time by about 12x (from roughly 12 weeks to around one week), can get a data warehouse up with lineage in a week or two, prototyped designs ahead of build, and documented two systems in under 30 minutes — enabling a scalable, low‑risk network of bespoke client data warehouses managed from a central warehouse.

Punter Southall Analytics

Steven Lim

Head of Analytics