Designing The Ultimate Business Intelligence Tool


A short time in the past, I changed into contact concerning a blog with Jaime Brugueras(1), discussing what he feels is lacking inside the current crop of Business Intelligence (BI) tools. I changed into requested to offer my feedback via weblog submit and start up a discussion with any luck.

Everything which Brugueras describes in his weblog might comprise the final BI tool. He truly highlights key ache points felt through all degrees of person and creates the framework through which those may be addressed. Despite his observations, I think the nature of the marketplace and the current BI device landscape prevent these suggestions from being found out.

Brugueras’ blog’s core argument is summed up as follows: Business Intelligence tools need to be less complicated to apply, extra comprehensive, predictive of destiny outcomes, and cheap enough that even the most minor corporations can have the funds for it. He suggests that gear that can be moresophisticated than a group of IT specialists should application, however easy sufficient for a lay individual to configure.

He notes that “equipment to be had nowadays are particularly complicated and require some level of programming”, yet a few strains later publicizes that “an effective BI tool permits for seamless integration of facts throughout… CRM, accounting and factor-of-sale software”. He laments, however, that current BI tools are “unable to integrate statistics from all assets”.

While multiple types of equipment may also output into similarly-formatted CSV documents, the database where these exports originate doesn’t have an equal schema. There is no standard key to hyperlink a couple of information assets, and few organizations are willing to turn themselves into facts providers by facilitating others’ utilization of their statistics.

Many would dispute my previous declaration via calling my interest to APIs; how agencies like Google, Foursquare, and Twitter make their information to be had to the outdoor international. They could be accurate. Shop for one key factor: the user contains, rather than dictates, the layout of the API. Suppose you do not like how Twitter has named a specific variable, then too terrible for you. An enterprise like Google is not going to change its information shape sincerely because you ask nicely.