By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Spreadsheets: Still the King of Business Intelligence Tools
Share
Notification Show More
Latest News
ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing
become a data scientist
Boosting Your Chances for Landing a Job as a Data Scientist
Jobs
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Software > SQL > Spreadsheets: Still the King of Business Intelligence Tools
AnalyticsBig DataBusiness IntelligenceData ManagementITSoftwareSQLStatistics

Spreadsheets: Still the King of Business Intelligence Tools

raqsoft
Last updated: 2013/04/09 at 2:33 PM
raqsoft
4 Min Read
spreadsheet business intelligence tool
SHARE

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.

More Read

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

Why Budgeting Is “Mission Critical” in Higher Education
Don’t Gloat Over Excel Model Failures
Big Data Is More Valuable with Kapow
Zombie Spreadsheets

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)

TAGGED: spreadsheets
raqsoft April 9, 2013
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

Sign Up for Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

[mc4wp_form id=”1616″]

You Might also Like

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

8 Min Read

Why Budgeting Is “Mission Critical” in Higher Education

5 Min Read
excel model failure
AnalyticsCommentaryCulture/LeadershipNewsStatistics

Don’t Gloat Over Excel Model Failures

6 Min Read

Big Data Is More Valuable with Kapow

6 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?