Case Study: Simplyhealth achieves 87.5% faster data refreshes and a leaner BI team with WhereScape data warehouse automation

WhereScape automation speeds up data-driven decision making for optimum business health

Simplyhealth, a UK healthcare provider serving over three million customers, needed to boost BI team productivity and redeploy six of ten developers without degrading service. Their legacy PL/SQL ETL across SQL Server and Oracle was slow, complex and prevented reliable period-over-period reporting, so they chose WhereScape (using WhereScape 3D and WhereScape RED) to automate their data warehouse development.

WhereScape automated the pipeline from source to warehouse—WhereScape 3D for prototyping and WhereScape RED to generate code and run builds—delivering dramatic gains: refresh times fell from eight hours to one (87.5% faster), headcount was reduced from 10 to 4 while service improved, a single developer built the solution in four weeks instead of the prior 18‑month effort, and average change time dropped from 4–7 hours to minutes. WhereScape’s code generation also improved documentation and maintainability, enabling daily refreshes and a lean, more agile BI team.

Simplyhealth

Carl Richards

Business Intelligence Development Manager