Robert Kugel's Analyst Perspectives

Get to Know Enterprise Spreadsheets to Improve Business Effectiveness

Posted by Ventana Research on Sep 25, 2016 12:14:45 AM

Ventana Research coined the term “enterprise spreadsheet” in 2004 to describe a variety of software applications that add a desktop spreadsheet’s user interface (usually that of Microsoft Excel) to components that address the issues that arise when desktop spreadsheets are used in repetitive, collaborative enterprise processes. Enterprise spreadsheets are designed to provide the best of both worlds in that they offer the ease of use and flexibility of desktop spreadsheets while overcoming their defects – chiefly inability to maintain data integrity, lack of referential integrity and dimensionality, absence of workflow and process controls, limited security and access controls as well as poor auditability. All of these issues can cause serious problems for business use, which I’ll discuss below.

Read More

Topics: Operational Performance Management (OPM), Business Analytics, Uncategorized, Business Intelligence (BI), Business Performance Management (BPM), Customer Performance Management (CPM), Financial Performance Management (FPM), Information Management (IM), Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), Analytics, benchmark, enterprise spreadsheet, Fina