A major problem in using Excel for analysis is that when source data changes you typically need to go through each step of the data preparation again. This could mean not only copying and pasting data from the source system again, but also adjusting formulas, lengths of columns and tables to ensure the new data fits.
Even worse is if the source data changes format, which can lead to having to move around and reformat large sections of sheets.
All this consumes a huge amount of non-value adding time and also introduces the risk of an error, the likelihood of which increases with each manual step.
The ease with which new spreadsheets can be created can be as much a curse as a blessing. Rather than looking to see if functionality already exists somewhere in a business, users will often embark on developing their own solutions. This means effort duplicated and important calculations that can be inconsistent dependent on the user.An analogue of this problem is when a single, important, spreadsheet is shared across a business and a mistake is accidently introduced at some point. This then continues to propagate across all subsequent users. Even if the problem is then spotted, there is no native capability in Excel to find all instances of that mistake and fix it.
Even though Microsoft significantly upgraded the number of rows that Excel could handle with the release of Excel 2007, the performance of the application can still suffer when complex calculations are applied on relativley small volumes of data.
To compound that problem, there is little to no guidance or on how to optimise formulas to improve performance or even where particular issues exist within a sheet.
Schematiq provides tools to both pinpoint exaclty where the performance issues arise, and also provides hints and tips as spreasheets are being written to avoid the problems occurring in the first place.
Schematiq's server-based computing takes the burden of data calculations, leaving Excel to concentrate on what it does best. Your Excel sessions will run quicker and crash less, helping you to get more done. It's like getting a whole new farm of PCs.
Schematiq is completely integrated into everything you do in Excel. There is 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 introduces blending and analysis of multiple, unstructured data sources into Microsoft Excel and provides a workflow environment that allows you to transparently see, step-by-step, the result of each step of the data transformation as you prepare, blend and analyze that data directly within Excel itself.
Schematiq has a number of connectors out of the box including Microsoft SQL Server, Oracle, MySQL, Access, Haven OnDemand, Twitter, web pages, and many other file types. Additionally Schematiq can be rapidly extended to other data sources you may have internal to your business.
Once you have performed your analysis - you are then free to use either the built in visualisation tools in Excel or connect to the market-leading data visualisation platforms.
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.