PROE-6-L-1

Data

Raw facts that are important to produce information, such as name, age, location, etc.

Warehouse

A building that can store products, equipment, materials, or anything that a business needs to store and maintain.

Data Warehouse

A database designed to enable business intelligence activities to help users understand and enhance their organization's performance.

OLTP (Online Transaction Processing Systems)

A class of software programs that support transaction-oriented applications on the Internet, used for order entry and financial transactions.

OLAP (Online Analytical Processing)

A technology that performs multidimensional analysis of business data, enabling complex calculations and trend analysis.

ETL (Extract, Transform, Load)

A process combining three database functions to pull data from one database and place it into another.

ODS (Operational Data Store)

A type of database used as an interim logical area for a data warehouse, allowing for data scrubbing and compliance checking.

Data Mart

A repository of data designed to serve a particular community of knowledge workers.

Transformation

The process of converting extracted data from its original form into a required format for the target database.

Extraction

The process of reading data from a database, often from multiple and different types of sources.

Load

The process of writing the data into the target database.

Historical Data

Data that has been collected from past events or sequences, which is often included in a data warehouse.

Data Mining

The process of discovering patterns and knowledge from large amounts of data.

Business Intelligence

Technologies and strategies for analyzing business data to support better decision-making.

Master Data

The critical data that is essential to the operation of a business.

Client Analysis Tools

Applications used to manage the process of gathering data, transforming it, and delivering actionable information to users.

Transaction Processing

A method that collects, stores, modifies, and retrieves the transactions of an organization.