Process / pipelineBusiness Intelligence & Analytics
OLAP Cube Design
OLAP (Online Analytical Processing) cube design is the practice of structuring multidimensional data for interactive analysis. Formalized by Codd and colleagues in 1993, OLAP cubes organize facts (measurements) along multiple dimensions (attributes) enabling rapid pivoting, drilling, and aggregation for business analysis.
Open in MethodMindSoonVideoSoon
Read the full method
Members only
Sign inSign in with a free account to read this section.
Sources
- Codd, E. F., Codd, S. B., & Salley, C. T. (1993). Providing OLAP to user-analysts: An IT mandate. Arbor Software. link ↗
- Pedersen, T. B., Jensen, C. S., & Dyreson, C. E. (1999). A foundation for capturing the semantics of temporal multidimensional databases. Proceedings of the 5th ACM SIGMOD Workshop on Research Issues in Data Mining and Knowledge Discovery. DOI: 10.1145/1517904.1517912 ↗
- Kimball, R. (1996). The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. New York: John Wiley & Sons. link ↗