OLAP

What is OLAP?

Online analytical processing, or OLAP, is the analysis of database information from multiple databases to answer multi-dimensional analytical queries fast. OLAP includes relational databases, report writing and data mining for business intelligence (BI) and decision support applications so users can ‘slice’ and dice data in multiple dimensions. An example of OLAP is to help a user to answer questions like “how many cars have been sold in Los Angeles in 2020? And how many of those have been sold to people over 60 years old?