Business Intelligence (BI) is the process of collecting, analyzing, and presenting business data to help organizations make better decisions. It transforms data into meaningful insights enabling companies to understand their performance, market trends, and competitive position. In this blog post I will explain how you can use BI together with a Business Process Management System.
Most BI tools follow the approach to transform raw data from a database centric business application into aggregated data for analysis. Typically those tools are built on SQL based databases which makes it easy to group data or compute totals across different queries. Of course, this approach requires a well-designed data structure and a deep understanding of the technical relationships between different information domains. Thus, it is usually a collaboration between business analysts and developers to collect this kind of data.
But what if you have a business process management system instead of a ERP software? In such a software system, there are floating and volatile workflows that generate the data to be analyzed. For example, a “complaint management” business process is more likely to look at timings, processing periods, and costs over time. The analysis of such processes in a BI tool is often very difficult to realize with conventional SQL queries. So the question is: what could be the right architecture to process this type of data in a BI platform?
Continue reading “Business Intelligence Built on Metrics – Part I.”