Business Intelligence Systems

The problem with Business Intelligence (BI) Systems

BI systems have changed dramatically over the last few years and there are now two types. The old fashioned system that uses an OLAP database that extracts data from the transactional database using an ETL tool. Then the newer, modern systems that run in-memory and use a column store index that can run directly off the transactional database and run consolidations across dimensions very quickly.

Pros and cons of using them for operational reporting.

Strengths of BI Systems:

Problems with BI Systems:

Due to the innate complexity of BI systems, a new reporting requirement will typically require 2-3 man-days to design and implement.  Depending on the level of resource available, it can take many more days or weeks to schedule in this time. This then forces operational management to take things into their own hands and start to build data shadow systems in Excel.If we now look to the new in-memory BI systems you have similar problems to traditional BI systems, but the key issues are;