Definition: OLAP = Online Analytical Processing, designed for analyzing large amounts of data through aggregations, filtering, grouping, and reporting.
Unlike OLTP, OLAP focuses on questions such as “What happened?” rather than frequent individual transactions.
Examples:
- “What were our total sales for each month?”
- “Which product category generated the most revenue?”
- “How many users from each country purchased products this year?”