Opening book details…
Can I read Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP - DOLAP '11 - Interactive exploration and visualization of OLAP cubes on EtoBox?
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP - DOLAP '11 - Interactive exploration and visualization of OLAP cubes by Ordonez, Carlos; Chen, Zhibo; García-García, Javier is a scholarly article available to read on EtoBox.
What is Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP - DOLAP '11 - Interactive exploration and visualization of OLAP cubes about?
An OLAP cube is typically explored with multiple aggregations selecting different subsets of cube dimensions to analyze trends or to discover unexpected results. Unfortunately, such analytic process is generally manual and fails to statistically explain results. In this work, we propose to combine dimension lattice traversal and parametric statistical tests to identify significant metric differences between cube cells. We present a 2D interactive visualization of the OLAP cube based on a checkerboard that enables isolating and interpreting significant measure differences between two similar cuboids, which differ in one dimension and have the same values on the remaining dimensions. Cube exploration and visualization is performed by automatically generated SQL queries. An experimental evaluation with a medical data set presents statistically significant results and interactive visualizations, which link risk factors and degree of disease.
- Author
- Ordonez, Carlos; Chen, Zhibo; García-García, Javier
- Publisher
- ACM Press
- Published
- 2011
- Language
- EN
More by Ordonez, Carlos; Chen, Zhibo; García-García, Javier
Browse all works by Ordonez, Carlos; Chen, Zhibo; García-García, Javier