Posts

Primary Components of Business Intelligence Systems

Business Intelligence (BI) systems are software applications that enable better understanding of organizational data and provide the information organizations need to make enlightened decisions. Moreover, business intelligence systems are primarily focused on reporting, querying, and analysis of data residing in an enterprise data warehouse (EDW), and both dependent and independent data marts.

Primary Components of Business Intelligence (BI)

Primary Components of Business Intelligence (BI)

Fundamentally, there are five categories of business intelligence applications…

•  Operational Reports:  Displays data with rich presentation and within a structured layout (i.e. rows and columns).
•  Query and Analysis:  Interactive methods to query data, present data in an ad-hoc manner, and to find information on an as-needed basis.
•  Dashboard Management:  Graphical interfaces and real-time methods to provide guided analysis and to intuitively monitor organizational metrics.
•  On-line Analytical Processing (OLAP):  The capability of manipulating and analyzing data from multiple perspectives in a rapid fashion.
•  Data Mining & Predictive Analytics:  Utilizing statistics, algorithms, and sophisticated data search capabilities to discover hidden patterns and relationships in data and project future results.

Read more

Share
Business Intelligence (BI) Maturity Model - Level 1

BI Maturity Model Level 1 – Operational Reports

Overview of Operational Reports

Operational reports are pre-designed business reports that focus on listings of data at the detailed level with data presented within a highly-structured format.  Also known as “canned reports”, operational reports enable organizations to present data in a logical format and are designed to support the day-to-day activities of an organization at the transaction level. They are typically developed by information technology (IT) departments and/or advanced report users that have a good understanding of reporting tools, business rules, and database concepts.  In addition, operational reports can be scheduled, refreshed, and distributed on a regular basis.  Fundamentally operational reports are used by people with the responsibility for improving their organization’s operations.

Sample Operational Report

Sample Operational Report

The tools provide task-oriented line-item information on individual transactions at the granular level of detail.  Operational reports are ideal for printing and displaying lists of detailed records or transactions in richly-formatted manner.

Characteristics of Operational Reports

•  Presents data in a logical format
•  Data is distributed in a highly-formatted manner
•  Reports can be published on a regular schedule
•  Distribution of organized listings of data
•  Enables users to understand transactional and/or detail level data
•  Typically developed by information technology (IT) personnel and/or knowledgeable power users

Read more

Share