INSIGHTCLOPEDIA

Contributions welcome!

C

Cardinality

This is the structural relationship between two entities. It is used in data models to represent how many occurrences of one entity can be related to occurrences of the other entity.

CASE-tool

CASE stands for Computer Aided Software Engineering. CASE tools are used as a tool for the analysis and design of static and dynamic business process models for the purpose of software development. Examples of use in BI are reading or generating database schemas and data flow diagrams.

Catalog

A part of a data dictionary that contains an indexed list of the objects and attributes of each object, within a database system. See also: ‘data dictionary’. Also used by some suppliers as a name for the layer between the reporting and the data model. It contains, for example, semantics, lists of values, etc. In the latter sense, it is …

Causal dimension

A causal dimension is a dimension that answers why something is! It does not record information that says something descriptive about the fact, but information that says something about the circumstances under which the fact takes place. This is done for the purpose of explaining why the fact occurs. A sales fact can occur under a promotion. The promotion is …

Centralized data warehouse

A single, central Data Warehouse in which all data is stored. Single and central in the sense of architecture. It is quite possible that the central Data Warehouse runs on multiple physical systems and / or at different locations. It is the only central source for the users of the data from the Data Warehouse.

Change data capture (CDC)

Het proces dat uitsluitend de in een bepaalde periode gewijzigde data van een bronsysteem identificeert en voor verdere verwerking beschikbaar maakt.

Chart

A graph that visualizes generated information. Experience shows that one picture says more than 1000 words (or numbers).

Chief Data Officer

A chief data officer is a corporate officer responsible for enterprise-wide governance and utilization of information as an asset, via data processing, analysis, data mining, information trading and other means

Child

In the hierarchical sense, subordinate to a parent entity. Used in hierarchical systems and databases.

Class

A class or kind with certain characteristics and / or rights.

Cleansing

Process of cleaning up that makes raw data from production systems or external sources suitable for inclusion in the data warehouse.

Cockpit

The organizational cockpit is a metaphor for a dashboard that allows managers to make decisions within the lines of the organizational hierarchy. These decisions are always based on the information presented in the cockpit and on personal observations.

Collaborative Business Intelligence

Strategy in which companies share knowledge about their own organization and processes with others in their supply chain, potentially resulting in greater efficiency and effectiveness. Also called BI Networks.

Collection

Used to name the process of collecting data, for example, and the final collection itself. For example, the collection process can be performed by a SQL query. The result of such a query is the collection itself.

Common warehouse metamodel

A commonly used specification method for modeling metadata (e.g. relating to object-oriented class schemes, relational, non-relational and / or dimensional databases in the data warehousing environment) and describing the exchange of metadata between e.g. Data Warehouses, business intelligence, knowledge management and portal technologies.

Competitive intelligence

A form of business intelligence in which knowledge and prior knowledge of the external environment plays an important role. This will usually be data relating to competitors and market developments.

Compliance

Compliance is the term used to indicate that an organization operates in accordance with applicable laws and regulations. An example of this is International Accounting Standards.

Conceptual scheme

A logical scheme. For example, the description of a database structure that matches human logic.

Condition

Een voorwaarde die bepaalt welke instructie moet worden uitgevoerd afhankelijk van de toestand waarin het proces zich bevindt.

Connector

Link between two (or more) data structures. Also used in the sense of linking two applications.

Corporate data

The data of a large company. Although large is a relative concept, it is often assumed that there is a complex organization with several branches. Business data in the most general sense of the word, ie all kinds of internal and external data that are relevant to the company or that are generated during the business operations.

Corporate data model

A logical model that contains all important aspects of a corporate data architecture.

Corporate information factory

collected data from all business processes within an organization. This data is then used by BI applications.

Corporate performance management

CPM is the continuous process in which the achievement of goals, or the delivery of performance, is controlled with the ultimate goal of realizing the strategy. This not only focuses on financial goals, but also on the internal process, on the customer and on innovation and growth of the organization: the four perspectives of the balanced scorecard. A term used …

Critical Result Indicators (KRIs)

Indicators that show the score in a broad result area that is the result of several actions (profitability, customer satisfaction, etc.)

Critical Success Factors

The critical success factors indicate what actually makes (or should make) an organization unique and describe those processes that are decisive for the success or failure of an organization. A CSF is a characteristic of the organization or of the environment that is essential to the viability and success of that organization. That can be both positive and negative. The …

Cube

A cube, or data cube is a multi-dimensional structure that contains data. Data cubes are used for OLAP.

Customer intelligence

A form of BI in which customer data and transaction data are used to gain insight into, for example, acquisition, cross and up selling and retention processes. Often based on composite customer profiles. Basically a system that provides useful customer information

Customer relationship management

The idea of setting up an effective and efficient, customer-oriented approach based on individual relationships with customers. All this to make it possible to arrive at an individual value proposition per customer or customer group. In IT and business intelligence terms, it concerns all methods, strategies, software and systems that an organization needs to make the relationships with its clients …