Robert Kugel's Analyst Perspectives

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...

I’ve been using electronic spreadsheets for more than 30 years. I consider this technology among the 20th century’s top five most important advances in business management. Spreadsheets have revolutionized every aspect of running any organization. A spreadsheet (specifically, VisiCalc) was the original “killer app” that made business people feel the necessity to buy a personal computer.

Profit Velocity Solutions’ PV Accelerator is an analytic application designed to enable capital-intensive companies to consistently achieve substantially wider margins and higher return on assets (ROA). Companies in industries such as specialty chemicals, building materials, integrated steel mills and silicon chip fabrication (to name just four) routinely fail to make the right decisions about pricing, production and sales management because they use analytic methods that, from an economic...

One of the important lessons company executives should have learned over the past 15 years is that it’s dangerous not to do contingency planning, a subject that I’ve written about before. By this I mean real, think-outside-the-box contingency planning (not just extrapolating), which is especially important when doing long-range planning. The past decade or so has been punctuated by periods of elevated volatility in financial and product markets, and there’s a good probability it will occur...

To mark the fourth anniversary of the Securities and Exchange Commission’s (SEC) interactive data mandate, Columbia Business School (my alma mater) and its Center for Excellence in Accounting and Security Analysis (CEASA) published a review of the current state of eXtensible Business Reporting Language (XBRL) that notes the manifold issues that plague this promising technology. From its perspective, three key issues hamper greater use of XBRL. The first is the high error rate in the tagging...

IBM this week announced its pending acquisition of the Star Analytics product portfolio. Star Analytics is a privately held company that offers products designed to provide easy access to and integration with Oracle Hyperion data sources. While Star Analytics has a good product and solid references, it has lacked critical mass to support more effective sales and marketing efforts. Star Analytics’ strategic value to IBM lies in its ability to unlock data held in Oracle Essbase multidimensional...

The electronic spreadsheet is among the top five most important advances in business management to come along in the last hundred years. It revolutionized almost all aspects of running an organization. It was the original “killer app” that made it necessary for people to go out and buy a personal computer. Yet our recent benchmark research project Spreadsheet Use in Today’s Enterprise confirmed advice we have been giving for the past decade: Spreadsheets are a fabulous tool but they have...

Taxes – both indirect (sales or value added taxes, for example) and direct (income taxes) – are one the largest expense items on the corporate income statement. In recent years it has become common for large and even midsize companies to automate their indirect tax management process, but direct tax management has remained a bastion of manual processes built on a heap of desktop spreadsheets. In previous blog posts I discussed this issue and the role of the tax data warehouse as a necessary...

Banking giant JP Morgan raised eyebrows in 2012 when it revealed that it had lost a substantial amount of money because of poorly conceived trades it had made for its own account. The losses raised questions about the adequacy of its internal controls, and broader questions about the need for regulations to reduce systemic risk to the banking system. At the heart of the matter were the transactions made by “the London Whale,” the name given to a JP Morgan’s trading operation in the City by its...

For the past couple of years I’ve been pointing to the importance of in-memory computing to the future of business applications. It’s an integral part of Ventana Research’s business and finance research agenda for 2013, and it’s one of the core technologies that senior executives should have an appreciation for because it can transform all core business processes, especially those that are analytic in nature.