QlikView from a MicroStrategy Consultant’s Perspective

An interesting article has been posted on Aellement.com.

The author, a 7 years MicroStrategy consultant, hits on the differences between QV and MSTR. Not knowing MSTR it’s hard to judge, but overall the author is impressed with QlikView. In the author’s words here’s the conclusion:

1. QV has really good presentation layer. I hate to say it, but much better than MSTR
2. I think its not very scalable.
3. Good for Data marts and Departmental BI that need fast deployment. Of course effort is needed in building a robust ETL layer (that leads to a good Associative DB)

I have read in other articles the argument about QlikView not being scalable.

Certainly QlikView at this stage has some limitations in terms of scalability, but version 9 promises to take away some of those.

I would be very interested to hear in what cases people hit the 2 billion records limit and how they overcome it.

So far, I have been analysing sales details (i.e. line level) for a multi-billion dollar blue-chip company at EMEA (Europe Middle-East Africa) level and I have only hit a few million records for a couple of years data.

I will be integrating more information in my QV applications soon, but I can’t see myself hitting that limit.

The only type of applications where I can see that happening is in case of very detailed activity recording (e.g. warehouse operators activity details, logs, etc), but, even then, I think that the benefit brought by QlikView compared to traditional solutions largely overcome the drawbacks.

The Spark

Tagged as: microstrategy, news, qlikview