We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: BI’s Dirty Secrets – Why Business People are Addicted to Spreadsheets
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > BI’s Dirty Secrets – Why Business People are Addicted to Spreadsheets
Business Intelligence

BI’s Dirty Secrets – Why Business People are Addicted to Spreadsheets

RickSherman
RickSherman
3 Min Read
BI’s Dirty Secrets – Why Business People are Addicted to Spreadsheets
Photo by This_is_Engineering on Pixabay (https://pixabay.com/photos/woman-work-office-whiteboard-4702060/)
SHARE

Microsoft Excel spreadsheets are the top BI tool of choice. That choking sound you hear is vendors and IT people reacting viscerally when they confront this fact. Their responses include:

  • Business people are averse to change; they don’t want to invest time in learning a new tool
  • Business people don’t understand that BI tools such as dashboards are more powerful than spreadsheets; they’re foolish not to use them
  • Spreadsheets are filled with errors
  • Spreadsheets are from hell

 IDC estimated that the worldwide spend on business analytics in 2011 was $90 billion. Studies have found that many firms have more than one BI tool in use, and often more than six BI tools. Yet a recent study found that enterprises have been “stuck” at about a 25% adoption rate of BI tools by business people for a few years.

So why have adoption rates flatlined in enterprises that have had these tools for a while? Are the pundits correct in saying that business people are averse to change, lazy or just ignorant of how wonderful BI tools are?

The answers are very different if you put yourself in the business person’s position.

More Read

The Iceland Volcano Ash – A Great Way to Validate Business Analytics
The Iceland Volcano Ash – A Great Way to Validate Business Analytics
Is the Data in Your CRM a Ticking Time Bomb?
Designed to be used
Dealing with Disruptive Data: Advancing BI Connectors and Integrating SQL and NoSQL Databases
#4: Here’s a thought…

First, business people are likely working many hours and multi-tasking. Demands on their time are ever increasing regardless of the state of the economy. Without any spare time, they need a compelling return on investment before learning a new tool. Spreadsheets have been the bedrock of reporting and analysis for quite a while, so if it ain’t broke don’t fix it.

With spreadsheets business people can slice and dice data, pivot it, calculate new metrics and display in compelling visuals. What they need more than a new slick presentation tool is comprehensive, clean, current and consistent data.

Second, moving to BI tools mean that business people have to depend on their IT staff to create the dashboards, cubes, visualizations and reports. Since many business people feel that there is a significant IT bottleneck resulting in a long waits before they get their reports, they keep turning to spreadsheets. After all, neither their competition nor their boss is going to wait for IT to generate the report they needed yesterday.

There are certainly many compelling reasons to convince a business person to use a BI tool, but the usual slick demo and “it will practically do your job for you” pitch is not going to change a business person’s mind.

Next: What are the real problems and how do we entice business people to use BI tools?

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article connects downstream report failures, data-quality gaps, and conflicting metric definitio
Signs Your Data Architecture Needs an Outside Review
Big Data Exclusive
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Big Data Exclusive
Flat editorial illustration: The article contrasts tools for gathering fresh interviews with tools for analyzing existing qualita
10 AI Market Research Tools That Turn Qualitative Data into Insights
Artificial Intelligence Big Data Exclusive
Flat editorial illustration: The article compares proxy MCP servers by what an AI agent can do through them: manage proxy account
Proxy MCP Servers: 7 Options and What Each Lets an AI Agent Do
Artificial Intelligence Big Data Data Collection

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Situational Intelligence: Not Just Another Fancy Term
AnalyticsBusiness IntelligenceData Visualization

Situational Intelligence: Not Just Another Fancy Term

7 Min Read
Government IT Savings Success - Time to Open the Piggy Bank…Carefully
Business IntelligenceData MiningData WarehousingPredictive Analytics

Government IT Savings Success – Time to Open the Piggy Bank…Carefully

7 Min Read
Update on the 6 March 2012 Government Big Data Forum
AnalyticsBest PracticesCulture/LeadershipData MiningKnowledge ManagementPolicy and GovernancePredictive AnalyticsSecurity

Update on the 6 March 2012 Government Big Data Forum

4 Min Read
Data Automation Has Become an Invaluable Part of Boosting Your Business
Big Data

Data Automation Has Become an Invaluable Part of Boosting Your Business

5 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 chatbot
How AI Website Chatbots Improve Customer Support and Lead Generation
Chatbots Exclusive
5 Great Tips for Using Data Analytics for Website UX
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?