Online analytical processing (OLAP)

Concept and definition

Online analytical processing (OLAP)

What is Online analytical processing (OLAP)?

Online analytical processing (OLAP) is a data processing technique used to analyse large multidimensional data sets. OLAP is a form of data analytics that focuses on the interactive analysis of data from different perspectives and levels of aggregation.

Unlike online transactional processing (OLTP), which is used to process real-time transactions in a database, OLAP focuses on analysing large amounts of historical data and allows users to perform complex queries and generate reports. OLAP uses multidimensional data cubes to store and analyse data, where each dimension of the cube represents a variable or attribute and each cell contains a measure that can be analysed.

OLAP systems are commonly used in businesses to analyse sales, finance and marketing data, among others, and allow users to perform real-time analysis and make informed decisions based on the data. OLAP is also a useful technique in business intelligence data analysis and can be used in conjunction with machine learning techniques to gain valuable insights from data.

« Back to glossary

Do you want to get in touch?

CDRs contain data that a telecommunications company collects about phone calls, such as time and length of call. This data can be used in analytical applications.
Fill the form
Share:
Basic concepts for building commercial software with artificial intelligence

The first thing you need to know is the limits of AI and after mastering the basic concepts you will be able to build a large commercial software with intelligent [...]

Read More »
The future of lending thanks to artificial intelligence

The financial sector is constantly implementing new technologies to modernize and digitize its functions. One of the reasons for this is the processing of [...]

Read More »
Non-performing loans to individuals to increase by at least 10% in 2022

GAMCO's forecasts point to an increase of at least 10% in the percentage of "non-performing loans" to individuals over the next five years.

Read More »
How to get more customers and less delinquency with Artificial Intelligence and Big Data

Fernando Pavón, CEO of Gamco and expert in Artificial Intelligence applied to business explains to us in the AceleraPYMES cycle how small companies can [...]

Read More »
See more entries
© Gamco 2021, All Rights Reserved - Legal notice - Privacy - Cookies