Business Intelligence Overview

Business Intelligence is an umbrella term that combines architectures, tools, databases, applications and methodologies in order to enable interactive access to data, to enable manipulation of data and to give business managers the ability to make more informed and better business decisions

The ______ is a special database or repository of data that had been prepared to support decision making applications ranging from simple reporting to complex optimization

Business analytics are the software tools that allow users to create on-demand reports, queries and conduct analysis of data: Originally they appear under the name online analytical processing

A class of information analysis based on databases that looks for hidden patterns in a collection of data which can be used to predict future behavior

Business performance management (BPM) based on balanced scorecard methodology (BSC) – is a strategy performance management tool that can be used by managers to keep track of the execution of activities by the staff within their control and to monitor the consequences arising from these actions

The objective is to optimize overall performance of an organization. A real-time system that alert managers to potential opportunities, impending problems, and threats, and then empowers them to react based on these knowledge. BPM- Balance Scorecards The architecture of Business Intelligence

User interface allows access and easy manipulation of BI components Tools used to broadcast information Data visualization provides graphical, animation, or video presentation of data and the results of data analysis

The ability to quickly identify important trends in corporate and market data can provide competitive advantage

The methodologies of assessing BI values are complex – difficult to measure success due to many intangible benefits One way to present the business value of BI is to pose business questions and show how they are answered with the support of BI

BI is not transaction processing, hence ______ OLAP OLTP ______

Systems that handle a company’s routine ongoing business. Online transaction processing is the use of information systems to handle a company’s routine, on-going business activities through recording data about events that take place in the course of business operations as they occur and using that data in other business operations

An information system that enables the user, while at a PC, to query the system, conduct an analysis, and so on. Online analytical processing is the use of information systems to analyze, with human guidance, historical data obtained through ongoing business activities and other sources to use as a basis for decision making

There are three major types of BI users: 1. IT staff -the developers and administrators of the tools to be used by the others. 2. Power users - people such as business analysts who have advanced skills in the use of BI tools and use them regularly. 3. Executives top managers of any organization. Their needs are typically met by tools such as dashboards, which display measurements of critical success factors and let users “drill down” into areas that catch their interest.