Ventana Research Analyst Perspectives

How to Get Business Users to Switch from Spreadsheets

Posted by Ventana Research on Feb 26, 2015 3:27:06 AM

In our benchmark research at least half of participants that use spreadsheets to support a business process routinely say that these tools make it difficult for them to do their job. Yet spreadsheets continue to dominate in a range of business functions and processes. For example, our recent next-generation business planning research finds that this is the most common software used for performing 11 of the most common types of planning. At the heart of the problem is a disconnect between what spreadsheets were originally designed to do and how they are actually used today in corporations. Desktop spreadsheets were intended to be a personal productivity tool used, for example, for prototyping models, creating ad hoc reports and performing one-off analyses using simple models and storing small amounts of data. They were not built for collaborative, repetitive enterprise-wide tasks, and this is the root cause of most of the issues that organizations encounter when they use them in such business processes.

Read More

Topics: Planning, Sales Performance, ERP, Forecast, GRC, Reporting, closing, dashboard, enterprise spreadsheet, Excel, plan, Customer Performance, Operational Performance, Analytics, Business Analytics, Business Collaboration, Business Intelligence, Business Performance, Financial Performance, Information Management, Accounting, Data, Risk, application, benchmark, Financial Performance Management, spreadsheet

Boardwalktech Addresses Spreadsheet Woes in Business

Posted by Robert Kugel on Jan 15, 2014 10:17:39 AM

Our benchmark research on enterprise spreadsheets explores the pitfalls that await companies that use desktop spreadsheets such as Microsoft Excel in repetitive, collaborative enterprise-wide processes. Because people are so familiar with Excel and therefore are able to quickly transform their finance or business expertise into a workable spreadsheet for modeling, analysis and reporting, desktop spreadsheets became the default choice. Individuals and organizations resist giving up their spreadsheets, so software vendors have come up with adaptations that embrace and extend their use. I’ve long advocated finding user-friendly spreadsheet alternatives.

Read More

Topics: Sales Performance, GRC, Reporting, Boardwalktech, enterprise spreadsheet, Operational Performance, Analytics, Business Analytics, Business Collaboration, Business Performance, Cloud Computing, Customer & Contact Center, Financial Performance, Governance, Risk & Compliance (GRC), Information Applications, Information Management, Workforce Performance, Risk, BCP, benchmark, Financial Performance Management, spreadsheet

Spreadsheets Consume More Time Than It Seems

Posted by Robert Kugel on Aug 7, 2013 10:47:02 AM

The spreadsheet is one of the five most important advances in business management over the last 50 years. It has changed all aspects of running an organization. It was the original “killer app” that made people go out and buy personal computers. So you see I’m enthusiastic about spreadsheets, but I realize they have limits that must be respected to work efficiently. One of the more important findings from our benchmark research Spreadsheets for Today’s Enterprise was about the time spent in maintaining spreadsheets. We asked participants how much time they spend per month in updating, revising, consolidating, modifying and correcting the spreadsheet used in the most important process associated with their job. The answers varied depending on the intensity with which people work with spreadsheets. On average, the heaviest users – those whose work requires them to spend all or almost all of their time using them – spend 18.1 hours per month on maintenance – the equivalent of more than two days per month! Even those who spend more than half their time in this fashion use up nearly two days (15.7 hours). For a tool designed to enhance personal productivity, these results should be sobering to executives and managers.

Read More

Topics: Sales Performance, Supply Chain Performance, Reporting, enterprise spreadsheet, Operational Performance, Analytics, Business Analytics, Business Intelligence, Business Performance, Customer & Contact Center, Financial Performance, Information Applications, Information Management, Visualization, Workforce Performance, Risk, benchmark, Financial Performance Management, spreadsheet

Investigate User-Friendly Spreadsheet Alternatives

Posted by Robert Kugel on Apr 18, 2013 10:11:08 AM

I’ve been using spreadsheets for more than 30 years. I consider this technology tool among the five most important advances in business management of the 20th century. Spreadsheets have revolutionized many aspects of running an organization. Yet as enthusiastic as I am about them, I know the limits of desktop spreadsheets and the price we pay if we fail to respect those limits. The essential problem arises when people use desktop spreadsheets for purposes beyond what they were originally designed to do. Desktop spreadsheets were designed to be a personal productivity tool, and they are good for prototyping models and creating analytics used in processes, performing one-off analyses using simple models and storing small amounts of data. They were not designed built to be used to manage or support repetitive, collaborative enterprise-wide processes. As a rule of thumb, when a spreadsheet is used by more than six people six or more times, it’s time to look for an alternative. Otherwise, errors and inconsistencies easily creep in and undermine the accuracy and value of important data.

Read More

Topics: Sales Performance, Supply Chain Performance, Reporting, enterprise spreadsheet, Operational Performance, Analytics, Business Analytics, Business Intelligence, Business Performance, Customer & Contact Center, Financial Performance, Governance, Risk & Compliance (GRC), Information Applications, Information Management, Visualization, Workforce Performance, Risk, benchmark, Financial Performance Management, spreadsheet

Spreadsheet Denial is a Big Issue

Posted by Robert Kugel on Mar 1, 2013 9:16:59 AM

Our recent benchmark research project, Spreadsheet Use in Today’s Enterprise, demonstrated that some companies have made modest progress in addressing spreadsheet issues, but there’s still much left to be done. Desktop spreadsheets can be an important source of productivity but, as I’ve noted, you need to understand their limitations and understand the practical alternatives. Users underestimate the impact of spreadsheet problems on their productivity because they tend to overlook the myriad little issues that constantly crop up. Being human, they overlook the ill effects that occur when spreadsheets are misused, and may be spurred to look for alternatives only when disaster strikes (as it did for one major bank).

Read More

Topics: Sales Performance, Supply Chain Performance, Reporting, enterprise spreadsheet, Operational Performance, Analytics, Business Performance, Customer & Contact Center, Financial Performance, Visualization, Workforce Performance, Risk, benchmark, Financial Performance Management, spreadsheet