Before advent of Business Intelligence (BI) tools such as Cognos, and Business Objects , the regular operational and analytical reports were developed using combination of tools. For example, getting summarized data using Oracle SQL and then producing reports in Microsoft Excel. Many organizations are still pursuing this approach for variety of reasons.
The Business Intelligence (BI) tools have helped some of the organizations by
- Shifting focus from developing the reports to analyzing the reports
- Improving efficiency of report development process
- Providing flexibility in slicing and dicing the data
Some of the challenges associated with the Business Intelligence (BI) tool adoption approach for Management & Business reporting are:
- Lift and Shift approach: Typically, the reporting end users are from the business and they decide the layouts and formats of the reports. Since, they already had reports available, they demanded the almost same report be generated, leading to complicated data model and longer development cycle. If an existing report was coming of Base SAS, multiple aggregation and steps would have used to develop the final report. When the same report is required to come off a BI tool, the complications were manifold. The reason, BI tool is meant to generate all the reports with limited data duplication and standard data model.
- Known and Static Requirements: I am a critic of the Business Intelligence tools. The reason, an underlying assumption with BI tool is that the reporting requirements are static and known. This is not an appropriate or valid assumption in most of the scenarios. For example, due to customer migrating to direct channels quite a few reports may not be relevant. Also, there will be additional reporting requirements which may not be directly available out of the BI tools. And the typical BI tool deployment cycle– requirement understanding to go live- is around a year. So, the business has its own concerns on initiating one more development cycle to incorporate the new or changes in the requirements. The outcome, BI tool and the reports remains unused.
- New Trends remain buried in obsolete groups: Typically, the variable groups are defined once at the time of BI tool deployment and remain static. The changes in customer behavior may be buried under the groups defined. For example, initial age bucket was 25-35 years, and due to economic and technological changes customers aged between 25-30 years may behave differently. But, the new trend and insight remained buried in the group due to averaging or aggregation.