Ventana Research Analyst Perspectives

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.

For several years I have been advocating that sales organizations adapt their processes and applications to optimize both sales performance and the customer experience. For details see my research agenda for last year. However, it appears that not many sales organizations have responded to this challenge; many can barely maintain their quarterly sales forecasts and monthly pipeline, track progress toward quotas and ensure that sales commissions are processed promptly and paid accurately. A great many are still using spreadsheets for these critical activities. Yet our benchmark research finds that more than half (61%) who use them for commissions said this makes the effort more difficult. Elsewhere, I have seen B2B sales organizations continue down the old path of annoying prospects with direct cold calling and email instead of nurturing real relationships. For B2C sales, the digital age of search engine optimization (SEO) and pay-per-click (PPC) has begun to haunt prospects by inserting ads in our personal social media channels. My research suggests that these practices are not due to bad intentions but to force of habit and lack of desire, time and resources to develop a modern strategy and plan. Most are just managing the basics of their sales processes and relying on sales force automation (SFA) systems, reporting and dashboards, which will only produce more of the same, less than optimal results.

Businesses and their human resource organizations feel pressure to maximize the value of their human capital in today’s intensely competitive world. Many have made or considered investments in new applications that better exploit information to efficiently recruit, engage and retain the best talent. Advanced applications not only advance these processes but also help management assess the performance of the workforce and compensate individuals fairly so that they advance their careers and find the level of employee satisfaction in the organization. A year ago I outlined the priorities in human capital management (HCM). During the past year our research found a significant number of companies lacking a unified HCM strategy that includes processes and the applications to support it. As others advance, HR organizations that are not equipped with such skills, resources and tools risk falling behind in human capital management as it contributes to business success.

Technology innovation is accelerating faster than companies can keep up with. Many feel pressure to adopt new strategies that technology makes possible and find the resources required for necessary investments. In 2015 our research and analysis revealed many organizations upgrading key business applications to operate in the cloud and some enabling access to information for employees through mobile devices. Despite these steps, we find significant levels of digital disruption impacting every line of business. In our series of research agendas for 2016 we outline the areas of technology that organizations need to understand if they hope to optimize their business processes and empower their employees to handle tasks and make decisions effectively. Every industry, line of business and IT department will need to be aware of how new technology can provide opportunities to get ahead of, or at least keep up with, their competitors and focus on achieving the most effective outcomes.

Using information technology to make data useful is as old as the Information Age. The difference today is that the volume and variety of available data has grown enormously. Big data gets almost all of the attention, but there’s also cryptic data. Both are difficult to harness using basic tools and require new technology to help organizations glean actionable information from the large and chaotic mass of data. “Big data” refers to extremely large data sets that may be analyzed computationally to reveal patterns, trends and associations, especially those related to human behavior and interaction. The challenges in dealing with big data include having the computational power that can scale to the processing requirements for the volumes involved; analytical tools to work with the large data sets; and governance necessary to manage the large data sets to ensure that the results of the analysis are accurate and meaningful. But that’s not all organizations have to deal with now. I’ve coined the term “cryptic data” to focus on a different, less well known sort of data challenge that many companies and individuals face.

Analyst Perspective Policy

Ventana Research’s Analyst Perspectives are fact-based analysis and guidance on business, industry and technology vendor trends. Each Analyst Perspective presents the view of the analyst who is an established subject matter expert on new developments, business and technology trends, findings from our research, or best practice insights.

Each is prepared and reviewed in accordance with Ventana Research’s strict standards for accuracy and objectivity and reviewed to ensure it delivers reliable and actionable insights. It is reviewed and edited by research management and is approved by the Chief Research Officer; no individual or organization outside of Ventana Research reviews any Analyst Perspective before it is published. If you have any issue with an Analyst Perspective, please email them to ChiefResearchOfficer@ventanaresearch.com