OLAP

---

OLAP (Online Analytical Processing) is a tool used to analyze data from different angles and help make better decisions. It works with data stored in a data warehouse.

OLAP Operations

---

• Roll-Up: Summarize data, like changing daily sales data to monthly sales data.
• Drill-Down: Go into detailed data, like looking from monthly sales data to daily sales data.
• Slice: Take a specific part of the data, like viewing sales only for a particular product.
• Dice: Take a more specific part, like viewing sales for a particular product and region.
• Pivot: Rotate the data to view it from different perspectives, like switching rows and columns in a table.