OLAP is a technology that allows users to analyze multidimensional data interactively from different perspectives for business intelligence and decision-making.

Explanation:

• Used for trend analysis, forecasting, and decision support.
• Works with large aggregated datasets.
• Uses data cubes to analyze different dimensions (e.g., time, location, product).

Example OLAP Query (Aggregate Sales by Region and Year):

SELECT region, year, SUM(sales) FROM SalesData GROUP BY region, year;