BUSINESS INTELLIGENCE (Class 1-2)

Vocabulary flashcards covering key terms from the Business Intelligence lecture notes.

Data

Raw facts and figures collected from multiple sources; the starting point for information processing.

Information

Processed data organized to answer questions and support decision making.

Infographics

Visual representations of information used to present knowledge.

Data Cleaning

Removing noise and inconsistencies from data to improve quality.

Data Integration

Combining data from multiple heterogeneous sources into a unified view.

Data Selection

Choosing only the data relevant for analysis.

Data Transformation

Consolidating information into a consistent format suitable for analysis.

Data Mining

Application of human intellect and computer technology to transform raw data into usable information.

Pattern Evaluation

Identifying interesting and usable sections of data for further analysis.

Knowledge Presentation

Using visual interface tools to present findings to decision makers.

Data Sources

Origins of data from multiple locations or systems (e.g., London, New York, Vancouver, Chicago).

Data Warehouse

Centralized repository storing data from many sources to support BI; high storage and maintenance needs.

Data Mart

Localized, smaller subset of a data warehouse tailored to a specific unit; easier to maintain.

ETL

Extraction, Transformation, and Loading of data into a data store or warehouse.

OLTP

Online Transaction Processing; handles day-to-day operations; optimized for writes.

OLAP

Online Analytical Processing; optimized for reads; supports drill-down, roll-up, slice-and-dice, pivot, etc.

Metadata

Data about data; describes structure, meaning, and usage of data.

Master Data Management (MDM)

Approaches to ensure consistent, single version of core business entities across the organization.

BI (Business Intelligence)

Processes and tools for turning data into actionable insights for decision making.

Decision Support Systems (DSS)

Systems that assist decision makers by providing information, models, and analyses.

Information Presentation

Visual presentation of information to aid understanding and decision making.

BI Tools

Software packages (e.g., Weka, SQL, R, Analysis Services, Excel, Tableau, Microsoft BI) used for data analysis and information presentation.

Aggregated Data

Generalized data in the form of totals and aggregations