INSIGHTCLOPEDIA

Contributions welcome!

E

Enterprise Portals

Enterprise portals provide centralized, direct access to relevant information and business applications via intra- or secure extranets and enterprise portals ensure that new or changed information – or a reference to it – is sent to users on a periodic basis (alerting & notification).

Enterprise Application Integration

In the user experience, this is the company-wide merging of applications.

Enterprise Application Integration 9EAI)

In the user experience, this is the company-wide merging of applications.

Enterprise data model

A logical model that contains all important aspects of an enterprise data architecture.

Enterprise data model (EDM)

A logical model that contains all important aspects of an enterprise data architecture.

Enterprise information integration

Term used to describe the process, procedures and systems by which organization-wide information flows are aligned and merged. The focus of the associated tools is on the real-time presentation of transactional data and not on historical information.

Enterprise information integration (EII)

Term used to describe the process, procedures and systems by which organization-wide information flows are aligned and merged. The focus of the associated tools is on the real-time presentation of transactional data and not on historical information.

Enterprise resource planning

Company-wide software applications in which all main processes, such as sales, production, finance, HRM, etc. come together. Large amounts of data are collected and stored within this type of large software environment. However, it often lacks advanced analysis and reporting capabilities. For this purpose (generic) BI solutions are often used.

Enterprise resource planning (ERP)

Company-wide software applications in which all main processes, such as sales, production, finance, HRM, etc. come together. Large amounts of data are collected and stored within this type of large software environment. However, it often lacks advanced analysis and reporting capabilities. For this purpose (generic) BI solutions are often used.

Entity relationship

The relationship between two or more entities in a data model

Entity relationship (ER)

The relationship between two or more entities in a data model

Entity relationship diagram

A logical diagram describing the relationships between data elements

Entity relationship diagram (ERD)

A logical diagram describing the relationships between data elements

Excel

Probably still the most used ‘BI tool’ in the world

Extendibility

The ability to add new functionality to systems without large-scale new application builds or changes to the underlying architecture and infrastructure.

Extract date

The date and time when a particular data element was retrieved

Extract frequency

The frequency with which data is retrieved. For example daily, weekly, monthly, etc.

Extract program

Program used to retrieve data from a source system

Extract specification

The specification of the conditions under which and the way in which data is retrieved.

Extract type

The way in which data is retrieved. For example: refresh, append, update, etc.

Extract, Transform, Load

The ETL (Extraction, Transformation and Loading) software provides access to source files and correct loading of the data warehouse. It is a general description of the process that leads to the filling of a data warehouse. In short: data is retrieved from a source system (extract), checked and adjusted to meet the data warehouse standards (transform), and loaded into the …

Extract, Transform, Load (ETL)

The ETL (Extraction, Transformation and Loading) software provides access to source files and correct loading of the data warehouse. It is a general description of the process that leads to the filling of a data warehouse. In short: data is retrieved from a source system (extract), checked and adjusted to meet the data warehouse standards (transform), and loaded into the …

Extraction

The process of retrieving data