A big advantage of a BI solution is the existence of a cube. Data and aggregations are stored in a optimized format to offer very fast query performance. Sometimes, a big disadvantage of storing data and aggregations in a cube is the latency that it implies.
Read More...