When companies sell Visual Analysis tools, they use standard excel or csv data (in many cases) to show case the ability of the tool. Once the tool comes into IT infrastructure, team assumes that tool fits in the existing environment with ease.

But things go wrong in first few months if existing data is not stored in a way the visual tool consumes. We may have data in the format which is not suitable to consume by the visual analytics tool (if you are having more reports based on stored procedures, its true in most cases).

Any Visual Analysis tool in the market today is designed by keeping the current issues in OALP tools.

What are the current issues in the current OLAP tools?

It cannot perform very well on huge amount of data pull (slow response time) in some cases. Even if we refresh the data once in a day in OLAP tools, the file size becomes very big as there is no compression happens in the data layer of the report.

Read More