Failure Of Traditional Business Intelligence

March 2019

Read Time: 4 minutes

The goal of Business Intelligence is to provide right-time information to management and function as a decision support mechanism. Below are few challenges in using Traditional Business Intelligence techniques.

• IT spends months or even years building out dashboards and reports based on user requirements. Users get their hands on the dashboards and reports and immediately request changes based on what they see. IT then spends more weeks or months implementing those changes. Users spend time with the new dashboards and reports, and then come up with more requirements as new questions come to mind. It’s a long, painful cycle.

• The extracted and filtered data need to be transformed into operational data warehouses by ETL(Extract, Transform and Load) processes. Then, techniques such as OLAP cubes are used to enhance the data storage to deliver better analytical performance. BUT as long as they are query-and cube-based solution, maintaining associations in the data requires hand coding —and therefore lots of time and money which results as higher cost solution.

• If business user wants to get deeper insight into an aspect of the business which required to add a new data source, then developer would have to go back and re-code the associations by hand all over again. Business users failed to explore data, make discoveries, and uncover insights that can be used to help them solve their problems in new ways.

• The performance gains are overshadowed by the enormous complexity and additional delays imposed by an ETL process.

• Traditional BI required Specialized consultants to perform ETL tasks and set up the Data Warehouses that few decision-makers will use.

So what is the solution way out of this.In future Article(s) , I plan to talk about that in detail.

Just to give some glimpse on which I would touch base in more details :

Current focus of BI and analytics platform market's is shifting from IT-led reporting to business-led self-service analytics. There are number of tools are available for providing solutions around this: Power BI, Tableau, QlikView/Qlik Sense etc

Author: Amit Singh: Executive Director, Co-head, Enterprise Technology and Services, Avendus Capital