Chapter 3 - Business Intelligence Systems

made by hannah w

Business intelligence (BI) systems

information systems that process operational, social, and other data to identify patterns, relationships, and trends for use by business professionals and other knowledge workers.

Business intelligence

patterns, relationships, trends, and predictions

BI application

software component of a BI system (business intelligence system)

decision making BI system

Informing, Deciding, Problem solving, Project management

Data acquisition

the process of obtaining, cleaning, organizing, relating, and cataloging source data

Master data management

data acquired from different sources made uniform and consistent

data aggregator

company that gathers and sells information from multiple sources

BI analysis

process of creating business intelligence (reporting, data mining, big data)

Publish results

the process of delivering business intelligence to the knowledge workers who need it

Push publishing

delivers business intelligence to users without any request from the users

Pull publishing

requires the user to request BI results

data warehouse

a facility for managing an organizations BI data (functions: obtain data, cleanse data, organize & relate data, catalog data)

granularity

refers to the level of detail represented by the data (can be too fine or too coarse)

data mart

a data collection (smaller than a data warehouse) addresses the needs of a particular department or functional area of business

data lake

a central repository for large amounts of raw unstructured data

data swamp

stores large amounts of data the may never be used

reporting analysis

the process of sorting, grouping, summing, filtering, and formatting structured data

structured data

data in the form of rows and columns (like excel)

reporting application

a BI application that inputs data from one or more sources and applies reporting processes to data to produce BI

exception reports

produced when something out of predefined bounds occurs

RFM analysis

a technique readily implemented with basic reporting operations, used to analyze and rank customers according to their purchasing patterns

online analytical processing (OLAP)

a second type of reporting application

measure

the data item of interest (is to be summed or averaged, otherwise processed in the OLAP report)

dimension

a characteristic of a measure (purchase date, customer type, location, etc)

OLAP cube

same as OLAP report, a presentation of data

data mining

the application of statistical techniques to find patterns and relationships among data for classification and prediction

data discovery

finding patterns & relationships amongst data to be more user-friendly, process developed to allow users to visually analyze and explore data

data visualization

the graphical representation of data, allows users to quickly understand complex data