Business Intelligence

Question 1

BI

Answer 1

Business Intelligence
Comprehensive tools and processes to capture, collect, integrate, store, and analyze data with the purpose of supporting business decision making.

Question 2

ETL

Answer 2

Extraction, Transformation, and Loading

Question 3

Data Store

Answer 3

Data stored in structures that are optimized for data analysis and query speed
aka Data Warehouse, Data Mart

Question 4

DW

Answer 4

Data Warehouse

Question 5

MDM

Answer 5

Master Data Management
Collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

Question 6

Governance

Answer 6

Method of controlling and monitoring business health and consistent decision making

Question 7

KPI

Answer 7

Key Performance Indicators
Quantifiable numeric or scale-baesd measurements that assess the company’s effectiveness in reaching strategic and operational goals

Question 8

ELT

Answer 8

Extract, Load, and Transform

A cost-effective alternative to ETL. Data is loaded quickly into data warehouse and then transformation occurs.

Question 9

DSS

Answer 9

Decision Support System

Precursor of modern BI environment

Question 10

OLAP

Answer 10

Online Analytical Processing
BI style with three characteristics: 1. multidimensional data analysis techniques, 2. advanced database support, 3. easy-to-use end-user interface

Question 11

ROLAP

Answer 11

Relational Online Analytical Processing

Provides OLAP functionality by using relational databases for multidimensional data

Question 12

MOLAP

Answer 12

Multidimensional Online Analytical Processing

Extends OLAP to Multidimensional DBMSs