Chapter 6: Data Business Intelligence

These flashcards cover key vocabulary related to Chapter 6 on Data Business Intelligence, focusing on important concepts, definitions, and processes fundamental to understanding data management and business intelligence.

High-Quality Information

Information that is accurate, complete, consistent, unique, and timely, essential for effective decision-making.

Relational Database Management System (RDBMS)

A system that allows users to create, read, update, and delete data in a relational database.

Data Warehouse

A logical collection of information gathered from multiple operational databases that supports business analysis activities and decision-making tasks.

Data Mart

A subset of a data warehouse containing specific data focused on a particular area of business.

ETL

Extraction, Transformation, and Loading; the process of extracting data, transforming it into a common format, and loading it into a data warehouse.

Data Mining

The process of analyzing data to discover patterns and extract useful information not readily apparent in raw data.

Information Cleansing (Scrubbing)

A process of correcting and removing inconsistent, inaccurate, or incomplete data within a data warehouse.

Transactional Information

Information that is used to support daily operational tasks and contains all details of a single business process.

Analytical Information

Comprehensive information used to support managerial analysis and decision-making.

Information Redundancy

Duplication of data or storing the same information in multiple places, leading to issues of inconsistency.

Primary Key

A field or group of fields that uniquely identifies a record in a table.

Foreign Key

A primary key from one table that appears in another table and provides a logical relationship between the two.

Data Visualization

Techniques for presenting data in graphical formats to help users understand patterns, trends, and insights.

Business Intelligence (BI)

Technologies and practices for the collection, integration, analysis, and presentation of business information to support better decision making.

Information Governance

The overall management of the availability, usability, integrity, and security of the data employed in an organization.