MIGRATION

Schematiq helps bring down the barriers to strategic transformation where complex spreadsheets processes are blocking the way.

  • Easily migrate spreadsheet data to databases or the Cloud

  • ​Bring processes under control by simplifying and formalising business logic

  • ​Move reporting to preferred BI solution

  • Reduce need for refactoring of sheets by automating

  • Use Schematiq Discovery to find out where existing data and process complexity lie

Move data from spreadsheets to databases or the Cloud

  • Migrate the core data used in spreadsheet processes to the Cloud with minimal impact to existing processes using our patent-pending data-link technology

​​

  • ​Specific data needed (e.g. that day’s data) can then be resurfaced into spreadsheets in the required format, but now is mastered and archived in a single secure, auditable location

Migrate business logic to your preferred modelling platform

  • Move critical business logic out of spreadsheets into scalable, controlled libraries using either Schematiq’s native template repository or popular business-focused languages such as Python

​​

  • This logic can then be invoked either as part of an automated process or accessed and tested via Excel using the Schematiq Excel add-in

Move reporting to dedicated BI tool such as Power BI

  • Once data has been moved out of spreadsheets and into a formal data store, it makes it easy to lay your preferred business reporting solution over the top

​​

  • Power BI, Tableau, and QlikView are common integrations that have been used

How this has helped our clients

  • Excel Upgrade projects become easy as Schematiq can help discover complexity, automate testing and fix sheets that fail to function on upgrade

  • ​Schematiq Migration provides the quickest way to gain control over critical data being stored in spreadsheets, without having to completely re-engineer processes​

  • Process of removing data brings step-change in performance as the size of files reduces drastically and enables use of dedicated BI solutions

  • ​Excel becomes a thin client – managing links to data and models, allowing testing and development but not mastering either data or business logic

  • ​Once logic and data is removed from Excel our clients are then free to platform according to strategic priorities