For BI users, real-time BI enables moment by moment business analysis. It involves using incoming transactional data to analyze the whole picture, detect unusual patterns, and take immediate action. Real time BI is also known as “right time” BI, since the degree of data latency is informed by business need.
For example: A computer manufacturer may run multiple assembly lines using identical components on each line, but from different suppliers. One supplier may have provided a bad component lot. While each assembly line builds the product, no errors are detected. But, as products come off the assembly lines, they are tested and yield a major spike in failures. With real-time BI, the component lot for that one supplier can be isolated out of all the work in progress to prevent potential failures in future products.
In another example: Credit card issuers continuously monitor card usage to detect unusual purchasing patterns across cities. Fraud usually occurs in a short period of time across many merchants in multiple cities. By analyzing real-time purchasing patterns as they occur, credit card companies can identify fraudulent use and greatly reduce losses.
For BI developers, real-time BI changes the data loading process. Traditional BI development involves loading data at a specific point in time, usually overnight. While this approach simplifies the development and operations processes, it becomes inflexible to support real-time data needs. The real-time approach of loading data becomes more of a trickle feed, allowing transactions to be inserted into the data warehouse immediately as they occur. Because this is transaction based loading, it’s important to ensure that the DBMS locking capabilities don’t impede on-line reporting access.
|