Excel is over 30 years old, but remains one of the most widely used, most powerful and important software applications of all time. However, increasingly severe problems are surfacing that create risk and inefficiency in today's businesses.
When source data changes, with Excel, you typically need to repeat each step of data preparation. This could mean copying and pasting data, adjusting formulas, lengths of columns and tables to ensure the new data fits. All this consumes a huge amount of non-value adding time and increases the risk of an unseen error.
Its easy to develop functionality in a spreadsheet so users often embark on developing their own solutions when something similar already exists. This means duplicated effort and inconsistencies. Similarly, if an error is found in a spreadsheet that has been shared widely, it is impossible to track all instances of it and make the corrections.
Although Excel can now support over 1m lines of data per sheet, the performance can still suffer when complex calculations are applied on a small fraction of those.
Compounding the problem, there is little to no guidance or on how to optimise formulas or where particular performance issues exist within a sheet.
With Schematiq, data is always pulled from source as a live Data-Link so that if the data changes your spreadsheet changes and analysis will always be up-to-date. Connectors include Microsoft SQL Server, Oracle, MySQL, Access, Haven OnDemand, Twitter, web pages, and many other file types. Additionally Schematiq can be rapidly extended to any other data sources you may have in your business.
Schematiq allows you to validate, transform and perform calculations on an entire data set in a single cell rather than copying and pasting down whole columns. This really unblocks the data limitations present in Excel whilst simultaneously reducing the size of sheets. Schematiq also allows you to see the result of each step of the transformation directly within the sheet, just like Excel.
Schematiq is completely integrated into everything you do in Excel. There's no need to move in and out of your spreadsheet. The core of Schematiq, the Workbench, is empowered by a series of brand-new functions that blend seamlessly into existing workbooks.
Schematiq runs outside excel as a parallel service taking the burden of data calculation and leaving Excel to concentrate on what it does best. Your Excel sessions will run quicker and crash less, helping you to get more done.
When the truth is buried in the data, you want to drill down to extract and analyse the nugget of knowledge you're looking for. The Schematiq Viewer is a dockable window that shows the detail of every cell, calculation or data structure. You can see the whole solution and every detail at the same time.