Avoiding Spreadsheet Hell
Have you ever found an error in your work well into your analysis and had to retrace and then redo all of your work? Have you ever come back to your work a few days later, having forgotten exactly how you got to where you are?
Ten things FreeSight does to ensure you never have to go through “spreadsheet hell” again…
- FreeSight automatically saves your work at all times. If your system freezes or crashes, FreeSight will recreate your work exactly where you left off.
- FreeSight works with a copy of your data. Your source data never changes.
- When you edit data, you can always see what changes have been made. Plus, you can revert to your original data values at any time if desired.
- A workflow diagram is created, enabling you to see the complete progress and process of your work at any time. No more need for hidden macros or lookups to other data sources. Everything is visible and transparent.
- When data is edited or updated in a FreeSight model the changes are dynamic. Meaning, they will always flow forward, and all Data and Analysis Tables downstream in the model will be updated with your corrections – automatically. You don’t have to redo your previous work when you correct an earlier mistake!
- FreeSight displays warnings when data columns appear mismatched, or when joined data appears to have missing values.
- Previously deleted rows and columns can be retrieved at any time — even after saving the file and revisiting it at a later date.
- Any previous action can be reversed, even if out of sequence (e.g. not a simple sequential “undo”, although sequential “undo” and “redo” features exist in FreeSight as well).
- “Drill down” to source data makes it easy to ensure that error corrections are made at the most optimal location in your model.
- “Replace Matching Values”, Reference Tables, and other similar rules-based processes ensure that you only have to make your data corrections once. FreeSight remembers your corrections and applies them to future data updates to your model.
The list goes on and on. But 10 points is a good start…