"Without Schematiq the project would have taken months, and we would still not have had the same confidence in the outcome"

Project Manager

NOVAE - INSURANCE CASE STUDY

Using the Schematiq Discovery service, Novae were able to rapidly complete a complex company-wide Excel upgrade programme with minimal impact on stakeholders

The Problem

  • Excel 2007 nearing end-of-life support

  • Huge number of spreadsheets in recent use (nearly 30,000)

  • Client had experienced serious problems on previous upgrade attempt

  • Very short amount of time to identify all business-critical spreadsheets and remediate to enable successful migration

Our Solution

  • Use Schematiq to scan entire Excel estate and identify high risk spreadsheets

  • Confirm business-critical processes with stakeholders

  • Prioritise remediation by risk-level

  • Deliver targeted solutions with minimal impact to users

Our Delivery Differentiators

  • Using Schematiq to perform Risk analysis greatly reduces time needed from stakeholders

  • Risk assessment is based on data, not opinions

  • Schematiq Workbench can control and supercharge non-performant spreadsheets which cause biggest risk

Results

  • Of 20,000 spreadsheets, around 300 were classified as medium or high risk

  • Full analysis and remediation plan rapidly completed within 4 weeks to enable upgrade

  • Significant process improvement opportunities identified, transforming core processing time from hours to seconds