IT Concepts

Enterprise Performance Management (EPM)

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)

IT Concepts

OLTP and database transactions

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,

IT Concepts

Corporate Performance Management (CPM)

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

IT Concepts

Ralph Kimball Data Warehouse Model

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,

IT Concepts

Dimension table in Data Warehousing

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

IT Concepts

Business Process Management (BPM)

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

IT Concepts

Definition of Big Data and its concepts

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

IT Concepts

XMLA stands for XML for Analysis

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

IT Concepts

MDX stands for Multidimensional Expressions

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

IT Concepts

DAX stands for Data Analysis Expressions

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