Cube
A cube is mainly used for multi-dimensional analysis. The below questions can be answered if we have collected considerable amount of data
- What are the total sales for each product by location wise?
- Who is the most visited customer over period of time?
- Which products are selling best over time?
A cube contains different faces, each face represents dimension, facts and measures(group of facts)
Region, Products are the dimension in the above picture. Measure are aggregated based on Region and Products.

