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: Designing the Ultimate Business Intelligence Tool
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Best Practices > Designing the Ultimate Business Intelligence Tool
Best PracticesBusiness Intelligence

Designing the Ultimate Business Intelligence Tool

iPerceptions
iPerceptions
9 Min Read
Designing the Ultimate Business Intelligence Tool
Photo by Gustavo Fring on Pexels (https://www.pexels.com/photo/men-sitting-at-office-and-working-6285066/)
SHARE

A short time ago I was contacted regarding a blog by Jaime Brugueras, discussing what he feels is lacking in the current crop of Business Intelligence (BI) tools. I was asked to provide my feedback via blog post and hopefully start up a discussion.

Everything which Brugueras describes in his blog would comprise the ultimate BI tool. He clearly highlights key pain points felt by all levels of user and creates the framework by which these could be addressed. In spite of his observations, I feel that the nature of the market and current BI tool landscape prevents these recommendations from being realized.

The core argument of Brugueras’ blog can be summed up as follows: Business Intelligence tools need to be easier to use, more comprehensive in nature, predictive of future outcomes and cheap enough that even the smallest businesses can afford it. He goes on to advocate for tools that are more sophisticated than a team of IT professionals could program, but simple enough for a lay person to configure.

He notes that “tools available today are relatively complex and require some level of programming”, yet a few lines later declares that “an effective BI tool allows for seamless integration of data across… CRM, accounting and point-of-sale software”. He laments, however, that current BI tools are “unable to integrate data from all sources”.

More Read

The Life Saved By a Database May Be Your Own! Dot-Connecting Is Serious Business
The Life Saved By a Database May Be Your Own! Dot-Connecting Is Serious Business
How BI and Data Analytics Professionals Used Twitter in July
The Data Lake: A More Balanced Perspective
After the Cyberattack, Can You Trust the Machine?
How to Transform Customer Retention with Analytics

While multiple tools may output into similarly-formatted CSV files, the database from where these exports originate don’t all have the same schema. There exists no universal key to link multiple data sources, and few companies are willing turn themselves into information providers by facilitating others usage of their data.

Many would rebut my previous statement by calling my attention to APIs; how companies like Google, foursquare and Twitter make their data available to the outside world. They would be correct, save for one key point: the user accommodates, as opposed to dictates, the format of the API. If you don’t like how Twitter has named a particular variable, then too bad for you. A company like Google isn’t going to change their data structure simply because you ask nicely.

When you consider that every company out there has their own special flavor of API, the dream of “an effective BI tool (that) allows for seamless integration of data” simply goes up in smoke. Every time a provider comes along, you will either need to adapt your BI tool to accept their data, or ask them to conform to your standard. The former is far more likely than the latter, but doing the former requires programmers and programmers cost money.

It is not difficult to see the relationship between cost and compatibility. Being more compatible requires a larger programmer base, which in turn requires more capital. The resulting tool would have to be heavily ad-supported, or sell at a price point sufficient to cover ongoing development costs. Very quickly you enter into the realm of enterprise-level solutions, where even the traditionally free Google Analytics has started charging $150,000/year for a Premium service level. This price point is clearly far outside the realm of affordability for the majority of small businesses.

The author advocates for an all encompassing, low-cost solution aimed at the SMB market. He wants a tool that is user friendly, inexpensive and easy to use, featuring automatic integration with multiple data sources that is predictive of future outcomes. He acknowledges that end-users “are not likely to be able to program their needs”, yet advocates the development of modular software in anticipation of every possible need. These BI tools must be action oriented, distilling complicated tasks like customer retention, inventory management and social media communication down to the simple click of a button. While wonderful in concept, I don’t believe that all will ever be within a single tool.

Apple products, be it the iPhone, iPad or iPod, are famous for working well together. Apple accomplishes this by controlling every step of the process, and knowing exactly what goes into every piece of hardware. They can then perfectly tailor their software to work within the hardware’s specifications, producing a very attractive product offering. However, a Mac falls flat when trying to run software originally written for a PC. With Apple reticent to license out their iOS to third party developers, don’t expect to see this product-line unity augmented or replicated anytime soon.

There are only two ways that Brugueras’ ideal BI tool could come to pass: A unifying open-source project of unprecedented scope or one single (for profit) company willing to take users cradle-to-grave for all their business software needs.

While I don’t think that a massive open-source project could appear, I make a point to never say never. The cynic in me just doesn’t see it, though. A single company creating a full-feature, A-to-Z Business Intelligence tool isn’t very likely, either. The barrier to entry isn’t so high that somebody wouldn’t try and come up with a “me too” product offering.

I’m not here to preach about what my ideal Business Intelligence tool would be, because I don’t believe that there can ever be a one-size-fits-all tool. You’ll never get enterprise-level features in a cheap/free product, either because of the associated development costs or due to the simple inability for small businesses to devote the required time to such a far reaching tool.

Take your prototypical small business as an example, where employees generally wear more than one hat. It’s likely that your “web guy” will not only be responsible for website design and SEO, but also for PPC and SEM and possibly copy writing for both the online channel and traditional corporate communications. Ask yourself, will this overworked individual be able to devote the time required to use a highly-sophisticated BI tool?

Much like clothing, creating something that is one-size-fits-all typically results in a garment which is a poor fit for 99% of the population. When you buy a suit, most people require that the pants be hemmed or the jacket taken in. Few people are truly “off the rack”, so why do we expect the same from our BI tools?

There exist tools that work very well for small business, which scale well and can accommodate the business as it grows. They don’t have the features of an enterprise-level tool, but small businesses don’t have the bandwidth to use all those features anyway. Rather than devote time to chasing the dream of the perfect tool, end-users should focus on better expressing their BI tool needs. The corporate world has been quite successful at recognizing needs and designing products to meet them. I have every confidence that several different vendors will step up and provide targeted solutions, provided the requirements are clear and properly documented by the eventual end-users.

Orignally posted on Digital Soapbox – Christopher Pam’s personal blog.

TAGGED:APIBI Issuesbi 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

Recognizing Vulnerabilities and Risky Behavior Through Business Intelligence
Business Intelligence

Recognizing Vulnerabilities and Risky Behavior Through Business Intelligence

8 Min Read
Big Data, Intelligence and Multi-Faceted Innovation
Business Intelligence

Big Data, Intelligence and Multi-Faceted Innovation

12 Min Read
Every User an Analyst - Bah, Humbug!
AnalyticsBusiness IntelligenceCulture/Leadership

Every User an Analyst – Bah, Humbug!

4 Min Read
Big Data Vs. Traditional Business Intelligence
AnalyticsBig DataBusiness Intelligence

Big Data Vs. Traditional Business Intelligence

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
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

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?