Excel users load, gather and calculate data within their spreadsheets. They will create copies, send it by email and manually manipulate the data. When data is stored in such a way, there is no way to safely preserve the original data. Confidentiality of the data is also an issue when the spreadsheet is copied and shared with others using email.
At Polymathic Systems we introduce and exploit Excel enabled technology that allows the business user to separate or “de-couple” their data from the spreadsheet while maintaining 100% of Excel’s power and functionality. This technology is the basis for providing a single source of truth for business data. With this enabling technology, data duplication and email attachment proliferation are dramatically reduced. Existing Excel business process cycle times are reduced and data confidentiality is improved. In addition, human error introduced by repeated manual manipulation and linking is also reduced. And finally, businesses will have more time to test scenarios and study results that will drive better decisions.
Business data however, is multi-dimensional. The Excel user will structure rows and columns across multiple tabs and linking them together in an attempt to arrange the data properly to create a multi-dimensional solution. Within Excel, this is how it is done, and throughout the world human ingenuity has created some very impressive solutions using theses techniques, to overcome the two dimensional limitation.
At Polymathic Systems we introduce Excel-based OLAP technology that turns Excel into a multi-dimensional analysis and reporting tool. With this integrated functionality human error and spreadsheet chaos is dramatically reduced. Time consuming manual manipulation that involves the stitching and linking of spreadsheets is eliminated. Traditional static one-off reports become dynamic and in real-time.