Qlikview

QlikView Review
Advanced information applications can be built, not only simple ones.


Valuable Features

As a BI professional sometimes you have to tackle projects with poor or no documentation at all, just the datasources and some vague requirements. In QlikView it is quite easy build up a first data model (dimensional or not) and use the first stage to understand the entities and relations between it and the business. From there you can explore the business, understand the users real requirements and needs and improve the model with a few changes, without much effort. This is because Qlikview has a very flexible and short cycle of development in each iteration.

For the user QlikView is a wonderful tool of data discovery, providing powerful tools to navigate easily between a sea of data in an intuitive, easy, and clear way, allowing them to go from facts to KPI and vice versa.

Improvements to My Organization

Qlikview can be used both as an advanced reporting tool as well as an BI KPI tool, becoming the base for continuous process improvements. In general the benefits of the tool become clear at the early development stage when the user is challenged to input clearly his ideas, problems and needs and that will affect the process in which he participates. Typically in a second iteration the key user will ask for a new release more oriented to advanced KPIs rather than just reports. This is a direct consequence of the process making things clearer and evolving. So the main value supplied by Qlikview is to reduce uncertainty, make the participants question, discover, interact with each other, and eventually improve the process. Properly used should function as an improvement catalyst for the processes involved.

Room for Improvement

It is well know that the ETL is quite far away from leading products like Data Stagem Informatica and others. Currently Qliktech is working on this problem with Expressor, a powerful graphic dataflow tool. Another area is the licensing scheme, which leaves out many SMO. To remedy this and try to stop the eruption of third parties (e.g: Tableau), QlikTech launched Qlik Sense, although the future is unclear and there may be a possible merge of the two branches (Qlik Sense + QlikView). Finally QlikTech, since release 10/11, leaves the development of new graphic charts to the community with mixed results.

Use of Solution

I have using it for the last five years, since 2010 at least.

Deployment Issues

The deployment of the dashbords, in the simplest scenario, is so easy you just drop a unique file (qvw extension) in the published folder and the solution appears into the main web page that works like an index of all solutions: the access point.

Stability Issues

The product has great stability although in some circumstances, especially if it is low in resources or the reload process encounters some kind of dead lock while extracting the data from the DB, it could/will result in the shutdown of the service. The good news is the automatic behavior: I never saw corrupted data or unstable behavior, just restart the service / reload and all works well again.

Scalability Issues

The product is designed to scale both horizontally and vertically. Some organizatations which have servers and dashboards that handle until 30 Tb of data have had some issues that finally have been addressed by the support service of QlikTech.

Customer Service and Technical Support

Customer Service:

The customer service is provided by the local reseller and is fine. We have mainly used it to get the new releases and some support during the installation.

Technical Support:

The technical support in my country is provided by the master reseller and it looks good even when they have to pass the case to Qliktech to figure-out the problem and find a solution. In this last case it can be somewhat delayed because these cases needed to reach the top levels of the service.

Previous Solutions

I have used (and still use) Microsoft BI: SSISm SSAS and SSRS. The productivity level of QlikView is quite superior, whilst Microsoft licensing scheme is really better, specially when there are large number of users and a lot of SQL licences deployed making it (MS) much cheaper.

Initial Setup

The initial setup was absolutely seamless and the only requirement for a successful deploy is a little training to the users, not only about how to use QlikView, but what can be done with QlikView, giving them the initial spark.

Implementation Team

In general the vendors which I have worked with were very well qualified, although not very inclined to share information easily.

ROI

This question is hard to answer because except for a few cases its impossible to measure how the project (not the tool) improves the results of the organization. Such measures are available at the organizational level, but it is difficult to quantify the proportion of the contribution from one tool to a whole process.

Pricing, Setup Cost and Licensing

The start cost is around of US $25.000 and the annual royalties are around 20% that includes customer and technical support and upgrades.

Other Solutions Considered

I have evaluated Tableau and Microstrategy. The first one is too basic (wonderful if you are a final user). The second one: extremely complex, just for very large organizations and large IT teams.

Other Advice

Think seriously about the possible population of users, how it will grow-up, and check the licensing cost and its limitations.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
11 visitors found this review helpful
Principa167133 li?1417484325Alopman li?1414330513Thomas k cheriyan mba li?14218922444763d768 8ae2 4ae9 86b0 d57faf4dd186 avatarKevin feit li?1427472345Nagendrababu tiruveedula li?1414683892Anonymous avatar x30Anonymous avatar x30Anonymous avatar x30Anonymous avatar x30

3 Comments

Anonymous avatar x30

As a quiet novice developer I found that ETL can be done quite easily in QV as long as you have basic scripting knowledge by splitting each model you have into 3 consecutive models you can create an Extract model which will create the first QVD's extracted from your databases, followed by a Transform model to process this QVD's and then a UI model which will load the processed data.

Like (1)01 December 14
046ee1af 3c33 49f4 a625 f3b4791f2cce avatar

Great review

Like (0)15 December 15
Anita luthra li?1426356963

Qliksense is replacing Qlikview and ease of use and increased functionality is available with Qliksense. The company and support engineers are very helpful and the development community is strong for both products - Qlikview and Qliksense. For heavy Excel and .net developers and users, this is the better tool. We tried tableau also and Tableau was more complex.

Like (0)04 January 17
Anonymous avatar x30
Guest

Have A Question About QlikView?

Our experts can help. 239,056 professionals have used our research on 5,957 solutions.
Why do you like it?

Sign Up with Email