Spreadsheets: Still the King of Business Intelligence Tools

April 9, 2013
194 Views

spreadsheet business intelligence tool“BI is not an upgrade to the spreadsheet!” “Stop trying to use the spreadsheet as a BI tool!” BI vendors are frequently heard to make such comments.

spreadsheet business intelligence tool“BI is not an upgrade to the spreadsheet!” “Stop trying to use the spreadsheet as a BI tool!” BI vendors are frequently heard to make such comments. People may thus assume that the spreadsheet is on the decline, and feel embarrassed by their Microsoft Excel, RaqSoft esCalc, LibreOffice Calc, and OpenOffice Calc tools because they may have a wrong impression that these tools are not intelligent enough to cross the BI threshold. The technology consulting firm Gartner Group Inc. once precisely predicted that BI would be the hottest technology in 2012. The year of 2012 witnessed a sharp and substantial increase of BI. Unexpectedly, the spreadsheet turns out to be the one developed and welcomed most, instead of the SAP BusinessObjects, IBM Cognos, QlikTech Qlikview, MicroStrateg, or TIBCO Spotfire. In fact, whether it is in the aspect of total sales, customer base, or the increment, the spreadsheet is the top one.

Why is the spreadsheet still ruling the BI world?

One of the key factors is its low technical requirement. The spreadsheet does not require a complex installation and deployment procedure or expertise in SQL/MDX/Java script/.Net, let alone a great many of advisory agents and technical experts to give you command. The spreadsheet is so simple and easy to learn that even the “100 Compulsory Things to Do for U.S. Pupils in Summer Holiday” includes the homework of presenting data in Excel to their parents. These are just the drawbacks of the non-spreadsheet BI tools – their technical requirements are usually too high.

Being intuitive, free, and flexible are also factors.  Simple actions like query, filtering, grouping, sorting, formula composing, and judging are the routine work common and understandable to everyone. The free combination of these operations can bring about numerous algorithms. However, the non-spreadsheet BI tools are all hard to understand, and restrictive to your innovative ideas. Just to name a few, you can only calculate in the model of the respective BI tool and must have an idea of the rotation of dimensions.

Most importantly, the spreadsheet is business-personnel-oriented. What is the purpose of BI? BI is aimed to enhance enterprise competiveness through business computing. This objective requires the business personnel to carry out the analysis from the business perspective when confronting to the business opportunities and risks. However, the non-spreadsheet BI tools are designed for IT experts. They may know the SQL and linear regression, and are able to solve 20% of BI problems, but they may not necessarily know the business.

It is the low technical requirement, intuitive and flexible calculation capability, and business-expert-oriented easy solution to the other 80% of BI problems that makes the spreadsheet still rule the BI world.

(image: spreadsheets and BI / shutterstock)

You may be interested

The Race for 5G Is the Race for Data Dominance
Big Data
80 shares710 views
Big Data
80 shares710 views

The Race for 5G Is the Race for Data Dominance

Daniel Matthews - June 22, 2017

Have you noticed how often the phrase “by the year 2020” comes up? In the tech sphere, many are heralding…

The Direst Security Breaches of 2017 and How Data Centers Are Responding
Best Practices
108 shares1,391 views
Best Practices
108 shares1,391 views

The Direst Security Breaches of 2017 and How Data Centers Are Responding

Diana Hope - June 20, 2017

Cybersecurity is becoming a tremendous concern. By 2021, security breach cost will exceed $6 trillion a year. A number of…

Why Smart Data is the Key to Future Lending
Best Practices
55 shares1,158 views
Best Practices
55 shares1,158 views

Why Smart Data is the Key to Future Lending

Patrick Köck - June 20, 2017

Last month, big data and investment trading collided on the front page of The Wall Street Journal. The article titled…