Archives des IT Concepts

Enterprise Performance Management (EPM)

9 August 2022

EPM is a field of Business Performance Management (BPM) that considers the visibility of operations in a closed-loop model across all facets of the enterprise. Several emerging areas in the EPM domain are driven by corporate or organisational initiatives, academic and technology research and commercial approaches such as EPM solution vendors (SAP BPC, Oracle Hyperion Essbase, IBM Cognos TM1, etc.). Enterprise Performance Management (EPM) …

OLTP and database transactions

2 August 2022

Definition of OLTP, that stands for On Line Transactional Processing and database transactions. The abbreviation OLTP refers to all databases designed to manage data processing in a transactional and reliable manner. This is for general operational management purposes. Examples include accounting data, supermarket sales data such as receipts and bank transactions. Definition of transactional databases or OLTP: On Line Transactional Processing First of all, …

Corporate Performance Management (CPM)

11 July 2022

Corporate Performance Management or CPM guides companies in today’s information-saturated business world. Like information systems management or agile project management methods, it is a widespread concept. But it is more important than ever to have reliable information. Information that gives you confidence in the numbers at any given time. Definition of Corporate Performance Management (CPM) CPM and its software simplify and accelerate the process …

Ralph Kimball Data Warehouse Model

4 July 2022

Presentation of the bottom-up Data Warehouse Model by Ralph Kimball. He is a well-known author and expert in the field of data warehouses. He is a proponent of a bottom-up approach to data warehouse design. This method is called Bottom-Up Design. As in other methods, the bottom-up approach creates data shops (Datamarts). To provide dedicated reporting and analysis capability for specific business processes. Thus, …

Dimension table in Data Warehousing

29 June 2022

What is the definition of a dimension table in data warehousing models? In business intelligence, dimensions are axes of analysis. The same dimensions often come up in the same areas. A dimension is a tree, the objective is to join facts to a leaf. With this join, analysts can calculate an aggregate with a node, a branch or the whole tree. A dimension in …

Business Process Management (BPM)

6 May 2022

Business Process Management (BPM) is a global management approach. It aims to harmonise all aspects of an organisation and to improve the capture of its customers’ needs. BPM is highly customer oriented. It promotes business efficiency by focusing on innovation. But also, on flexibility and the integration of technology into business processes. BPM improves processes continuously; it is called an optimisation process. BPM enables …

Definition of Big Data and its concepts

1 April 2022

Definition of Big Data and its concepts, marketing among others. Big Data Analytics is data that is larger than the capacity of commonly used software tools. These tools are used to capture, manage and process data in an acceptable timeframe, i.e. quantities of data that traditional BI tools cannot handle. This data is constantly growing, from a few terabytes to several petabytes. MIKE 2.0 …

XMLA stands for XML for Analysis

23 March 2022

XMLA stands for XML for Analysis or Extensible Mark-up Language for Analysis. It’s a protocol built on top of XML language. It allows data access from standard multidimensional data sources. Client applications accesses Microsoft cubes and tabular models using the XMLA language and the HTTP protocol. Firstly, what is XMLA or XML for Analysis? Microsoft Analysis Services OLAP cubes and Tabular models both uses …

MDX stands for Multidimensional Expressions

22 March 2022

First, what does MDX stands for? MDX stands for Multidimensional Expressions. It’s a database programming language to query and create calculations and measures in Microsoft cubes. It’s a language used by databases dedicated to analysis. To go further, let’s consider the two types of Microsoft databases, multidimensional and transactional ones. In this article we are dealing with the first type of database: the multi …

DAX stands for Data Analysis Expressions

21 March 2022

DAX stands for Data Analysis Expression, it is the Microsoft language to manipulates data in Microsoft SSAS Tabular cubes as well as in Power BI, and in Excel PowerPivot. The DAX library is a Powerful and user-friendly Microsoft library of different type of functions addressing different purposes. The DAX functions can be time intelligence functions or filter functions for example. What DAX abbreviation stands …