We just raised a $30M Series A: Read our story

QlikView OverviewUNIXBusinessApplication

QlikView is the #2 ranked solution in our list of top Embedded BI Tools. It is most often compared to Tableau: QlikView vs Tableau

What is QlikView?

QlikView is a Business Intelligence tool that allows you to keep tabs on all of your business-related information in a clean, clear, and easy to access database that is intuitive to build and simple to navigate. It is ideal for business owners who wish to improve overall output by creating the most productive system possible.

QlikView Buyer's Guide

Download the QlikView Buyer's Guide including reviews and more. Updated: October 2021

QlikView Customers

Canon, Gatorade, Amcor, Panasonic, Fila, Cambridge University Hospitals, Global Retail Bank, North Yorkshire Police department, Lanoo Group Publishers, and AonGroep Nederland.

QlikView Video

Archived QlikView Reviews (more than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
reviewer1185771
User at a retailer with 1,001-5,000 employees
Real User
Excellent dashboards for reporting and analytics

Pros and Cons

  • "This is a very cool application with endless options of creativity and visuals."
  • "I really wish the application was easier to use in the development phase."

What is our primary use case?

My company uses this application mainly for reporting and analytics through customized dashboards that meet corporate identity needs. The reports were created using existing SQL scripts that powered legacy dashboard and reports (i.e. SAP Crystal Reports).

How has it helped my organization?

This is a very cool application with endless options for creativity and visuals. 

While this application was loved by the end-users, the development required to build these dashboards proved to be more difficult vs. other solutions such as Tableau

What is most valuable?

My company is big on dashboards and this application excels in this space. Endless customization is key to meet everyone's needs. I also like how the application can use existing SQL statements to use as your root data/tables/information. Compared to other competitors, this solution can do more.

What needs improvement?

I really wish the application was easier to use in the development phase.

Our business model relies on the business to build their own reports and many departments did not have the associates they need with this type of skill set (i.e. SQL experience). In a business model where a centralized department (i.e. IT) is in control of the reports for the entire company, this would not be a problem.

The development was the ultimate reason this application did not take off in my organization vs. a competitor's application (Tableau). This is a shame as the finished dashboard appeared to be more polished.

For how long have I used the solution?

We have been using this solution for about one year, on and off.

What do I think about the stability of the solution?

My experience is limited but from what I experienced, stability is very good.

What do I think about the scalability of the solution?

The scalability of this solution is very good.

How are customer service and technical support?

Very reactive, quick and supportive.

I have been 110% satisfied every time I have reached out with a question.

Which solution did I use previously and why did I switch?

We started form SAP Crystal Reports and originally moved to Qlik as a replacement, but this application proved to be more difficult for development as the business owns their own report vs. IT.

How was the initial setup?

Application install was simple and straightforward.

What about the implementation team?

We implemented this solution with our in-house IT staff.

What was our ROI?

No ROI as we have moved on.

Which other solutions did I evaluate?

The biggest comparison was made with Tableau, which ultimately won.

What other advice do I have?

Their training and services have been top-notch and very reactive.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Director of IS at Bennington Marine
Real User
ETL, Integration, and Automation are made simple and help us to better understand our data

Pros and Cons

  • "This solution has simplified getting to and understanding our data, no matter where it is housed."
  • "This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help."

What is our primary use case?

We use this solution for ETL, Analytics, Reporting, Automation, Integration between data sources (cloud, local, spreadsheets, etc), Data Scrub for Migration to new software, and automation of sending files to banks instead of using EDI, Positive Pay, etc.

How has it helped my organization?

This solution has simplified getting to and understanding our data, no matter where it is housed.

What is most valuable?

The most valuable features are the ETL, automation, and ease of use by the user population.

What needs improvement?

This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help. I keep them all in OneNote now and copy and paste them in, then change the field names. This addition would really save time.

examples:

Convert date-time stamp to just a normal date in the Load script - so we can match to the company calendar for Model Year / month etc , Fiscal Year /month / week of year/ week in year

date(floor(DTTMSTAMP),'MM/DD/YYYY') as TransactionDate,

Storing QVD's: (this is the path needed from a Data Loader)

STORE SummarySalesAggregate INTO [..\QVDData\SummarySalesUnitsAndDollars.qvd];


Sorted and Count for creating Arrays:


SortedAndCounted:

Left join (SummarizeSales2)

LOAD

Option_Inv,

Line_No,

if(peek('Option_Inv',-1)<> Option_Inv,1, Peek('counter',-1)+1) as counter

Resident SummarizeSales2

Order by Option_Inv asc, Line_No asc;





For how long have I used the solution?

Since May 2013.

What do I think about the stability of the solution?

excellent

What do I think about the scalability of the solution?

excellent

How are customer service and technical support?

I have never worked with Qlik Customer Service directly.

Which solution did I use previously and why did I switch?

no

How was the initial setup?

it wasn't bad. We did need some consulting advise on the set up in the server...but designing the organization and naming conventions should be up to you.  We took the consultants advise and ended up renaming, changing almost everything as far as naming conventions

What about the implementation team?

started with a consultant, didn't use them long.

What's my experience with pricing, setup cost, and licensing?

keep working with the Company to get the pricing you need.  

Which other solutions did I evaluate?

yes - many

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
541,708 professionals have used our research since 2012.
Washington De Andrade
User at Toccato Tecnologia em Sistemas
Reseller
For the first time, they were able to analyze consistent data

What is our primary use case?

I developed an application for a hospital to improve the potential of analysis of that company. I used Windows Server 2008, 8Gb RAM, two processors.

How has it helped my organization?

The hospital improved the quality of the data analysis and increased its profits, because, for the first time, they were able to analyze consistent data.

What is most valuable?

Speed of development Ease of learning Low ROI Fast deliveries Scalability Multiplatform, and speed in queries.

What needs improvement?

Improvement in the graphical user interface Introducing HTML 5 Context sensitive Drag and drop visualization Responsive design.

For how long have I used the solution?

More than five years.

What is our primary use case?

I developed an application for a hospital to improve the potential of analysis of that company. I used Windows Server 2008, 8Gb RAM, two processors.

How has it helped my organization?

The hospital improved the quality of the data analysis and increased its profits, because, for the first time, they were able to analyze consistent data.

What is most valuable?

  • Speed of development
  • Ease of learning
  • Low ROI
  • Fast deliveries
  • Scalability
  • Multiplatform, and speed in queries.

What needs improvement?

  • Improvement in the graphical user interface
  • Introducing HTML 5
  • Context sensitive
  • Drag and drop visualization
  • Responsive design.

For how long have I used the solution?

More than five years.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
CM
Manager, Financial Systems Deployment, EPSI at a healthcare company with 1,001-5,000 employees
Real User
It is pretty easy to deploy. It would be nice if users could create their own dashboards and add fields.

What is our primary use case?

Our primary use case is an application that our users use to get the profitability on a monthly basis.

What is most valuable?

It's pretty easy to deploy.

What needs improvement?

I would want them to have more options as a user. It would be nice for them to create their own dashboards and add fields.

What do I think about the stability of the solution?

I did not encounter any issues with stability of the product. 

What do I think about the scalability of the solution?

I did not encounter any issues with scalability of the product. 

How is customer service and technical support?

We usually use a partner for technical support, so I cannot really rate the service. 

How was the initial setup?

We had the partner help us set up the product…

What is our primary use case?

Our primary use case is an application that our users use to get the profitability on a monthly basis.

What is most valuable?

It's pretty easy to deploy.

What needs improvement?

I would want them to have more options as a user. It would be nice for them to create their own dashboards and add fields.

What do I think about the stability of the solution?

I did not encounter any issues with stability of the product. 

What do I think about the scalability of the solution?

I did not encounter any issues with scalability of the product. 

How is customer service and technical support?

We usually use a partner for technical support, so I cannot really rate the service. 

How was the initial setup?

We had the partner help us set up the product for us. So, I do not remember any difficulty with the setup process. 

What's my experience with pricing, setup cost, and licensing?

It is not very expensive. I think it it is on par with other similar products on the market.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user928116
Technical Lead at a tech services company with 1,001-5,000 employees
Real User
The initial setup is not very complex. You can do a lot in the back end which is not possible in the other solutions.

Pros and Cons

  • "The initial setup is not very complex."
  • "You can do a lot of things on the back end which are not possible in the other solutions on the market."
  • "The pricing is high."
  • "It needs work with visualization."
  • "Needs improvement with UI transparency."

What is our primary use case?

So the primary use case of QlikView, I have worked with financial maintenence.

What is most valuable?

You can do a lot of things at the back end which are not possible in the other solutions in the market.

What needs improvement?

Tools that can be improved are:

  • Visualization charts
  • Pricing
  • UI transparency

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

The Qlikview is quite stable in comparison to other solutions.

What do I think about the scalability of the solution?

It is a very good scalable solution. 

How are customer service and technical support?

The tech support is strong. The logs of the documents are helpful. 

Which solution did I use previously and why did I switch?

I have some prior experience with Power BI and Qlik Sense.

How was the initial setup?

The initial setup is not very complex, it is on a moderate level. If others compare it to other BI tools, they may find it complex. But it was not a problem for us.

What's my experience with pricing, setup cost, and licensing?

The pricing is too high compared to the other solutions on the market.

Which other solutions did I evaluate?

There are features of QlikView that are not available with Power BI or Tableau. There are activities on the back end that work better in QlikView.

What other advice do I have?

You can do a lot of things at the back end that you cannot do with other competitive solutions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Archana Jha
Assistant Manager at KPMG Global Services (KGS)
Real User
I had the option to prepare data myself instead of always having to depend on the data team

What is our primary use case?

I have used QlikView to create powerful and compelling data visualisations. QlikView is a well-rounded tool with good visualisation component and data preparation features.

How has it helped my organization?

Using QlikView, we have been able to derive the value out of our data much faster than with other tools because of its easy to understand/use components and features.

What is most valuable?

As a developer, I liked that using QlikView, I had the option to prepare data myself instead of always depending on the data team.

What needs improvement?

More/newer visualisation components need to be added. QlikView's ability to embed custom visualisation is not a great experience.

For how long have I used the solution?

More than five years.

What is our primary use case?

I have used QlikView to create powerful and compelling data visualisations. QlikView is a well-rounded tool with good visualisation component and data preparation features.

How has it helped my organization?

Using QlikView, we have been able to derive the value out of our data much faster than with other tools because of its easy to understand/use components and features.

What is most valuable?

As a developer, I liked that using QlikView, I had the option to prepare data myself instead of always depending on the data team.

What needs improvement?

More/newer visualisation components need to be added. QlikView's ability to embed custom visualisation is not a great experience.

For how long have I used the solution?

More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Assistant Manager at a tech vendor with 10,001+ employees
Vendor
Provides scripting as per a customer's need

Pros and Cons

  • "Scripting as per a customer's need, which is a pretty cool feature and not available in other tools."
  • "Installation and deployment could be made easier and quicker."

What is our primary use case?

Our sales reps use dashboards for reporting latest inventory quantities on a real-time basis, which is critical for the business.

How has it helped my organization?

Time and effort are reduced using QlikView by saving a lot of money providing the same information before an implementation.

What is most valuable?

  • Datamining
  • Fast data loading of million of rows
  • Incremental load
  • Scripting as per a customer's need, which is a pretty cool feature and not available in other tools.

What needs improvement?

  • Bookmarking
  • Data load window and more information to be used while loading huge data.
  • Installation and deployment could be made easier and quicker.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

No issues.

How are customer service and technical support?

Support is very good.

Which solution did I use previously and why did I switch?

It is better in all aspects than our previous solution.

What was our ROI?

Not sure.

What's my experience with pricing, setup cost, and licensing?

Qlik is fairly high in terms of pricing.

Which other solutions did I evaluate?

We evaluated MS Excel.

What other advice do I have?

Overall, it is an excellent product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user858876
Enterprise Architecture & Business Analyst - Analytics at a paper AND forest products with 1,001-5,000 employees
Real User
In-memory feature gives us better insights, and drill-down is easy

Pros and Cons

  • "The in-memory feature gives us better insight. It's also easy to drill down into the information and select information."
  • "For me, it is important to have a mix, what is the "view" and what is the "sense", Qlik Sense. They have two tools, but for me it is important to have only one tool, which combines the functions that we have from one side and the other side."

What is our primary use case?

We use it for analytics and for insight as well, what we call our standard reports, tabular reports. But mainly, to create a dashboard and analytic views.

What is most valuable?

The in-memory feature gives us better insight. It's also easy to drill down into the information and select information. Of course, it has the typical functionalities. For example, when I select something I can know its opposite.

What needs improvement?

For me, it is important to have a mix, what is the "view" and what is the "sense", Qlik Sense. They have two tools, but for me it is important to have only one tool that combines the functions we have from one side and the other side. One application.

Also, they have not come out with new functions for QlikView. Qlik Sense has evolved but not QlikView.

Another problem is the printing. It is not a solution that comes with QlikView. I believe we had to buy it. It is not integrated. It is not the easiest to manage. It is not as easy as it could be.

For how long have I used the solution?

Three to five years.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

Right now, we are facing a challenge concerning the capacity, or balancing the use of the servers. In the end, we expect to have a good resolution.

Which solution did I use previously and why did I switch?

We were using a different solution and we still use a part of that solution, SAP. SAP Business Warehouse and SAP BusinessObjects. We faced a lot of problems in the migration between BusinessObjects and BW. In the past, BusinessObjects was a separate company that was bought by SAP, so we had a lot of problems in terms of integration. It was not possible to pursue these solutions with so many problems. We could not deliver solutions with that platform, so we went to the market to see which other solutions there were for creating the output: the reporting, the analytic views, the dashboard creation. 

The most important criteria when it comes to selecting a vendor are the vendor's position in the market, and the solution itself. If we are going to change from one supplier to another supplier, we must have confidence in that new supplier. Other factors are the functionality of the solution and the cost of implementing the solution.

How was the initial setup?

It's not complex.

Which other solutions did I evaluate?

We did a comparison between Microsoft Power BI and QlikView, and we decided on Qlik. That was five years ago.

What other advice do I have?

I rate QlikView at eight out of 10. Compared with the SAP portfolio, in terms of administration, I think it lacks features.

My advice, today, is you must look at the others, like Tableau or Microsoft, to compare. Everyone has their own objectives, what they want to get from a tool, so compare and see which ones respond to the requirements.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Partner with 51-200 employees
Reseller
QlikView has changed the face of BI, Qlik Sense has taken Qlik to the premier league

Pros and Cons

  • "Associative model - no more cubes."
  • "Although Qliktech's road map clearly states that QlikView has a long way to go, most of the R&D effort seems to be benefiting Qlik Sense."

What is most valuable?

Speed of in-memory processing
Associative model - no more cubes
Speed of development

How has it helped my organization?

We create BI solutions so our customers benefit from solutions that are delivered in weeks rather than months and we look good by providing timely value-for-money solutions

What needs improvement?

Although Qliktech's road map clearly states that QlikView has a long way to go, most of the R&D effort seems to be benefiting Qlik Sense which is getting stronger and sexier with every release 5 a year from now - June 2017).
Qlik Sense makes selling "Qlik" easier - the only "negative" aspect is that the "self-service" capability of Qlik Sense means less consultancy for our company but more customers!

For how long have I used the solution?

8 years

What was my experience with deployment of the solution?

Rarely

What do I think about the stability of the solution?

Almost never

What do I think about the scalability of the solution?

No

How are customer service and technical support?

Customer Service:

Excellent

Technical Support:

Excellent

Which solution did I use previously and why did I switch?

How was the initial setup?

Setup is straightforward especially with later editions of QlikView

What about the implementation team?

In-house

What's my experience with pricing, setup cost, and licensing?

N/A - we are resellers

Which other solutions did I evaluate?

What other advice do I have?

Gartner and others have a good reason to rate it so high. Amazing product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user752142
Board of Management with 501-1,000 employees
Real User
Enables us to build complex models very quickly and helps with data visualization

Pros and Cons

  • "Its ability to build, very quickly, very complicated models."
  • "Improvement in collaboration, between that and publishing of reports and publishing of models."

What is most valuable?

Its ability to build, very quickly, very complicated models. In our case, we use for this modeling for the calculation of cost allocation and transfer price and the like. It is very helpful. It's a really powerful tool in modeling creation.

How has it helped my organization?

It has helped us to implement the accounting management system and provide a very comprehensive solution for this. Also, I already mentioned cost allocation system, transfer pricing.

It's also very helpful in visualization of the data from our operation systems. Because we are a bank, data creation is very important for us, so it's another model.

It covers many things, including current exposure, the coverage of loans, etc. In these areas, it's the most comprehensive and most helpful of the tools we're using, based on this platform.

What needs improvement?

I would say it's not negative, but it's an issue because we also use other tools, like SAP BusinessObjects, for a long period of time, which is another product in the business intelligence area.

Improvement in collaboration, between that and publishing of reports and publishing of models. Probably that could be more comprehensive, from my point of view.

For how long have I used the solution?

Four or five years, already.

What do I think about the stability of the solution?

Yes it's stable. Not 100% but, really, compared to other products, it's a stable product. It's controllable. And the maintenance received from local partners is very good, at a very high level.

What do I think about the scalability of the solution?

No problems.

How are customer service and technical support?

We have both technical support and support in the development model from the local partner of QlikView. I would rate it at a very high level.

Which solution did I use previously and why did I switch?

Because the majority of BI tools are focusing on processing a significant mass of data, we were looking for a more analytical tool with the possibility to quickly build models, and we found it. On the other hand, QlikView has some constraints due to the architecture, so it may not be applicable for millions and millions and millions of data records because it requires significant expenses for the hardware. But, as an analytical tool, it's very interesting.

How was the initial setup?

It was very easy because we started by using the free version of QlikView. After that, we bought everything, including a server license. So, we had no problems with this.

Which other solutions did I evaluate?

At that time, we already had BusinessObjects as a BI tool in our bank, with SAP Crystal Reports, for example, as a part of BusinessObjects. At that time, in the market, there were no alternatives in this respect, so our choice was very precise because already we used this tool and we decided to buy it.

What other advice do I have?

I would recommend this product. We have a lot of reference meetings because we were the first bank in the country to implement it, this platform. So we're meeting our colleagues who are working not only in the banking industry but from telecom, from the pharmaceutical industry, etc. We recommend it.

It's one of the best products in this segment, for BI, for the automation of analytical activity within the bank or within the company. It doesn't 100% cover everything, but in the area, it works very well.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user93783
Master Data at a hospitality company with 10,001+ employees
Vendor
The tool is easy to implement with easy user adoption

What is most valuable?

Easy to implement.

How has it helped my organization?

Easy user adoption.

What needs improvement?

Data Science.

For how long have I used the solution?

For eight years.

What do I think about the stability of the solution?

Not often.

What do I think about the scalability of the solution?

I don’t think scalability is applicable to QlikView.

How was the initial setup?

Yes, it was straightforward.

What other advice do I have?

Use QlikView for business, and Qlik Sense for BI developers.

What is most valuable?

Easy to implement.

How has it helped my organization?

Easy user adoption.

What needs improvement?

Data Science.

For how long have I used the solution?

For eight years.

What do I think about the stability of the solution?

Not often.

What do I think about the scalability of the solution?

I don’t think scalability is applicable to QlikView.

How was the initial setup?

Yes, it was straightforward.

What other advice do I have?

Use QlikView for business, and Qlik Sense for BI developers.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user78468
Senior IT Business Partner at a manufacturing company with 501-1,000 employees
Vendor
Able to get information when we need it without running reports or it taking a huge amount of time

What is most valuable?

The dynamic way in which you can analyse data.

How has it helped my organization?

We are now able to get information when we need it without running reports or it taking a huge amount of time.

What needs improvement?

Cost: The licenses are expensive.

For how long have I used the solution?

Eight years.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

Only due to the costs.

How is customer service and technical support?

An eight out of 10.

How was the initial setup?

Straightforward.

What other advice do I have?

The system needs some technical expertise to set up and can be expensive, but once set up, it works well.

What is most valuable?

The dynamic way in which you can analyse data.

How has it helped my organization?

We are now able to get information when we need it without running reports or it taking a huge amount of time.

What needs improvement?

Cost: The licenses are expensive.

For how long have I used the solution?

Eight years.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

Only due to the costs.

How is customer service and technical support?

An eight out of 10.

How was the initial setup?

Straightforward.

What other advice do I have?

The system needs some technical expertise to set up and can be expensive, but once set up, it works well.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Data Manager at a wellness & fitness company with 10,001+ employees
Vendor
Transformative. Lightning fast, flexible and a breath of fresh air

Pros and Cons

  • "A well designed app brings freedom of inquiry to meetings, allowing me to answer questions in real time and this has transformed progress and outputs of our monthly group meeting."
  • "Syntax editor needs some work, it's frustrating to have valid syntax being flagged as incorrect."

What is most valuable?

Ability to connect and transform data from a variety of sources into the same application. From an analytical development perspective, there is a wide scope to create complex calculations within chart expressions, (including recursive expressions), which, combined with the trellis functionality, means more output with less setup effort.

A well designed app brings freedom of inquiry to meetings, allowing me to answer questions in real time and this has transformed progress and outputs of our monthly group meeting.

Finally, it really is a case of data instantly updating upon selection. No more watching an egg timer as a server churns away.




How has it helped my organization?

Meetings are now proactive rather than reactive with analysis conducted straight away. We're making better informed decisions - and more of them!

I have automate a complex set of analysis within a matter of days (as a relatively novice user), that had taken weeks, with less useful outputs, in other software.

What needs improvement?

Syntax editor needs some work, it's frustrating to have valid syntax being flagged as incorrect. It would save time troubleshooting errors that don't exist when the script runs or charts render.

For how long have I used the solution?

1 year, but not a heavy user - though this will change!

Disclosure: I am a real user, and this review is based on my own experience and opinions.
AyodeleMakun
Qlik Technical Consultant at a tech services company with 11-50 employees
Consultant
It is a highly sophisticated self-service business intelligence tool for developers and analysts.

Pros and Cons

  • "E-T-L, The Extract, Transform, and Loading capabilities of QlikView make it a highly sophisticated self-service business intelligence tool for developers and analysts."
  • "The user interface and ease of use takes a bit of a learning curve to pick up."

What is most valuable?

E-T-L, The Extract, Transform, and Loading capabilities of QlikView make it a highly sophisticated self-service business intelligence tool for developers and analysts who desire much more advanced handling of dirty or unconsolidated data. QlikView scripting language has numerous transformation functions.

How has it helped my organization?

As a consultant for my organization using Qlik to design management dashboards, analysis and ad-hoc reports, I have seen the way it has helped many of our clients get the desired reports and analysis for their stakeholders and top directors which would normally take time and more effort to get.

What needs improvement?

The user interface and ease of use takes a bit of a learning curve to pick up. There is no drag and drop functionality at the development stage unlike its competitors. Maybe QlikSense could handle that area.

For how long have I used the solution?

We have been using the solution for five years.

What do I think about the stability of the solution?

We haven't yet encountered any issues with stability.

What do I think about the scalability of the solution?

QlikView is a memory intensive application and does sometimes start to weigh on your PC resources. Also you would need to learn some development tricks to manage unnecessary time wasting when loading large database sources, like the use of QVD – QlikView proprietary data format - for faster and efficient loading times.

How are customer service and technical support?

The Qlik community is very vibrant and you find or get answers to most issues started or any other areas.

Which solution did I use previously and why did I switch?

We did not use a solution previously.

How was the initial setup?

The initial setup is pretty straightforward for personal use, except when you are looking at deploying the QlikView server which will entail some configuration instructed during the installation process.

What's my experience with pricing, setup cost, and licensing?

QlikView pricing and licensing is on the high side for a small sized company, but it's competitive among its peers.

Which other solutions did I evaluate?

As a consultant in the area of business intelligence and data analytics I have had to personally evaluate QlikView with other self-service BI tools such as Tableau, Power BI and MicroStrategy.

What other advice do I have?

Invest in the memory and RAM of your PC or server you intend to use for QlikView. Ensure you have all the necessary resources and connectors installed for proprietary databases.

Disclosure: My company has a business relationship with this vendor other than being a customer: My organization is a Qlik Partner.
it_user667746
Beslutstödsutvecklare
Vendor
Data transforming with scripting and the associative model are valuable features.

What is most valuable?

Data transforming with scripting, and the associative model that lets users browse data in an easy way, are the most valuable features.

How has it helped my organization?

Linking different sources of data in a way we could not do before has really helped decision-making regarding our production and focus.

What needs improvement?

Error handling

For how long have I used the solution?

I have been using it 10+ years.

What was my experience with deployment of the solution?

We have not really encountered any deployment issues.

What do I think about the stability of the solution?

Sometimes when developing QV applications, I encounter almost unexplainable errors that causes QV to crash.

How is customer service and technical support?

Customer Service:…

What is most valuable?

Data transforming with scripting, and the associative model that lets users browse data in an easy way, are the most valuable features.

How has it helped my organization?

Linking different sources of data in a way we could not do before has really helped decision-making regarding our production and focus.

What needs improvement?

  • Error handling

For how long have I used the solution?

I have been using it 10+ years.

What was my experience with deployment of the solution?

We have not really encountered any deployment issues.

What do I think about the stability of the solution?

Sometimes when developing QV applications, I encounter almost unexplainable errors that causes QV to crash.

How is customer service and technical support?

Customer Service:

Customer service is very good.

Technical Support:

Customer service is excellent.

What about the implementation team?

An in-house team implemented it.

What was our ROI?

  • Better business

What's my experience with pricing, setup cost, and licensing?

To take a good look at needs and the alternatives.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Analyst - Business Applications at a pharma/biotech company with 10,001+ employees
Vendor
​The search feature provides the ability to see related data.

What is most valuable?

The search feature: ability to see the related data

How has it helped my organization?

We were able to see tremendous insight in our sales dashboard at deployment.

What needs improvement?

Data cleansing Better source data connectors

For how long have I used the solution?

I have used it for 2 1/2 years.

What was my experience with deployment of the solution?

We have not encountered any deployment issues; we had an experienced deployment partner.

What do I think about the stability of the solution?

We encountered a memory issue.

What do I think about the scalability of the solution?

We have not encountered any scalability issues.

How are customer service and technical support?

Customer Service: Customer service is outstanding. Technical…

What is most valuable?

  • The search feature: ability to see the related data

How has it helped my organization?

We were able to see tremendous insight in our sales dashboard at deployment.

What needs improvement?

  • Data cleansing
  • Better source data connectors

For how long have I used the solution?

I have used it for 2 1/2 years.

What was my experience with deployment of the solution?

We have not encountered any deployment issues; we had an experienced deployment partner.

What do I think about the stability of the solution?

We encountered a memory issue.

What do I think about the scalability of the solution?

We have not encountered any scalability issues.

How are customer service and technical support?

Customer Service:

Customer service is outstanding.

Technical Support:

Technical support is great.

Which solution did I use previously and why did I switch?

We previously used Tableau. We switched because the business requested Qlik.

How was the initial setup?

Initial setup was pretty easy because our implementation partner understood our current data source (SAP).

What about the implementation team?

A vendor team implemented it.

What was our ROI?

The time gained from reviewing massive data can be used elsewhere.


What's my experience with pricing, setup cost, and licensing?

Pricing is a bit too high and I think licenses should be unlimited.

Which other solutions did I evaluate?

Some of our users were on Tableau.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Project Manager, Global Business Intelligence & Analytics at a media company with 1,001-5,000 employees
Vendor
Drag & drop storytelling provides value. I’m hoping to see mobile and smart device delivery.

What is most valuable?

The most valuable features of this product are: its data modeling capabilities, the associated search function, various charting, the flexibility of doing sales in object, section access, and drag & drop storytelling.

How has it helped my organization?

We have been using Qlik for most of our front-end solution since adoption; people like it a lot.

What needs improvement?

I would like to see: Mobile and smart device delivery Set analysis simplification

For how long have I used the solution?

I have used it for 3-5 years.

What do I think about the stability of the solution?

Performance sometimes is a concern. Occasionally, it hangs while running a script and it bounces out.

How are customer service and technical support?

Technical support is OK.…

What is most valuable?

The most valuable features of this product are: its data modeling capabilities, the associated search function, various charting, the flexibility of doing sales in object, section access, and drag & drop storytelling.

How has it helped my organization?

We have been using Qlik for most of our front-end solution since adoption; people like it a lot.

What needs improvement?

I would like to see:

  • Mobile and smart device delivery
  • Set analysis simplification

For how long have I used the solution?

I have used it for 3-5 years.

What do I think about the stability of the solution?

Performance sometimes is a concern.

Occasionally, it hangs while running a script and it bounces out.

How are customer service and technical support?

Technical support is OK. We work with a vendor partner. We have no direct interaction with Qlik.

Which solution did I use previously and why did I switch?

We used IBM Cognos BI, in which charting and dashboarding are painful.

How was the initial setup?

Initial setup was very easy.

What about the implementation team?

A vendor partner implemented it.

I advise your team to dive in and learn how to build the most-efficient data model, and learn how to design your web pages.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user422718
Business Intelligence Consultant at a tech services company with 501-1,000 employees
Consultant
You can use it to look at large data volumes without straining the database or waiting a long time for data discovery.

What is most valuable?

  • Integration capabilities
  • Speed
  • Amount of data that can be accessed within in a few clicks

Working in the IT environment gets challenging especially when you have multiple sources of data that you need to combine. QlikView makes this really easy and simple to do, because QlikView has its own ETL modeler built into it. Having an all-in-one tool is quite an advantage.

How has it helped my organization?

QlikView has made it possible to look at large data volumes without having the drawback of strain on the database and waiting long periods for data discovery. QlikView has also helped people switch over from reporting to do more analysis and data discovery. QlikView has also helped serve as an alternative to Excel reports.

What needs improvement?

This is really an awesome product, but there is room for improvement regarding the visual aspect (this has been sorted out in their new product – Qlik Sense). Some features are a bit tedious to achieve results, especially for new users and people who have not had training or experience in using the product.

For how long have I used the solution?

I have used it for four years.

What was my experience with deployment of the solution?

I have not encountered any deployment, stability or scalability issues.

How is customer service and technical support?

I rate the level of customer service and technical support 9/10.

How was the initial setup?

Initial setup was straightforward. I would recommend getting someone from Qlik to advise or do the initial setup to eliminate any issues.

What about the implementation team?

Get Qlik to do the initial setup.

Which other solutions did I evaluate?

I also looked at Tableau, Sisense, and SAP BusinessObjects. Tableau is a good tool, but has a few drawbacks when your data source is not in the correct format. BusinessObjects is a bit old school (reporting) and SAP HANA is costly to implement. BusinessObjects is also costly and requires a lot of work in the data and business layer.

What other advice do I have?

Determine what you require and get the tool that suits your need the best. Compare products and if you decide to go with Qlik, I personally prefer Qlik Sense. Again, this depends on your business need.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user225189
BI Project Leader with 1,001-5,000 employees
Vendor
Data Discovery has allowed us to enrich the analysis of data and discover new ways to generate new KPIs.

What is most valuable?

Data Discovery has allowed us to enrich the analysis of data and discover new ways to generate new KPIs. It has also helped us to discover some critical points in our processes.

How has it helped my organization?

Using QlikView models, we've improved after-sales service in several of the products we offer, and we have managed to measure the profitability of our customers.

What needs improvement?

There’s room for improvement with the licensing, as well as memory consumption for certain objects and technical support.

For how long have I used the solution?

I have used this solution for three years.

What do I think about the scalability of the solution?

I have encountered issues with scalability. We have generated models with large amounts of data and have found that the processor and memory of our server has been declining. We do not have something to help us to size the equipment requirements when a big data model is developed in QlikView.

How are customer service and technical support?

Technical support is good, but needs to be better for our local service.

Which solution did I use previously and why did I switch?

We are evaluating Power BI suite and Datazen. We found that these products offer a good level of analysis, but the licensing offer was the deciding factor.

What about the implementation team?

A vendor team did the implementation.

What was our ROI?

We still do not see a significant ROI.

What other advice do I have?

Make an accurate sizing analysis of information, with a view to growth.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
IT Manager / Specialist at a insurance company with 501-1,000 employees
Vendor
We use it to track information on service desk tickets and SLAs.

What is most valuable?

The most valuable feature is its flexibility to develop dynamic analysis, gathering information from different sources, such as spreadsheet, database and internet.

How has it helped my organization?

With QlikView, my organization is able to track information related to service desk tickets and SLAs. This information helps us find the bottlenecks and fix them.

What needs improvement?

Reports module should be improved to make it user-friendly and easy to develop reports.

For how long have I used the solution?

I have used it for eight years.

What was my experience with deployment of the solution?

I did not encounter any issues with deployment, stability or scalability.

How are customer service and technical support?

I rate technical support 8/10.

Which solution did I use previously and why did I switch?

We used to have IBM Cognos, but we decided to go for QlikView because of the flexibility and the short time to develop and delivery analysis.

How was the initial setup?

Initial setup had medium complexity due to different data sources and integrations.

What about the implementation team?

We developed it in-house. The advice I would give is to get the business user (internal client) as close as possible and in parallel for any doubts and questions about the tool. Visit QlikView forums We have a lot of useful information on it.

What's my experience with pricing, setup cost, and licensing?

Proper planning is the key for choosing the right license for the right user. Know your internal clients and their ability to do/create analysis.

What other advice do I have?

It's s one of the best solutions for short-time deliveries.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user170457
Assistant Manager - Solution Consulting at a consultancy with 1,001-5,000 employees
MSP
Real-time reporting is this product’s most valuable feature to me. The forecasting accuracy should be improved.

What is most valuable?

Real-time reporting is this product’s most valuable feature to me.

How has it helped my organization?

The decision-making process has been streamlined.

What needs improvement?

The forecasting accuracy should be improved.

For how long have I used the solution?

I have used QlikView for one year.

What was my experience with deployment of the solution?

I did not encounter any issues with deployment, stability or scalability.

How is customer service and technical support?

I rate Qlik’s technical support on the high side.

How was the initial setup?

Initial setup was straightforward.

What about the implementation team?

We did it in-house, which I prefer.

What other advice do I have?

It’s about each and every individual and organization.

What is most valuable?

Real-time reporting is this product’s most valuable feature to me.

How has it helped my organization?

The decision-making process has been streamlined.

What needs improvement?

The forecasting accuracy should be improved.

For how long have I used the solution?

I have used QlikView for one year.

What was my experience with deployment of the solution?

I did not encounter any issues with deployment, stability or scalability.

How is customer service and technical support?

I rate Qlik’s technical support on the high side.

How was the initial setup?

Initial setup was straightforward.

What about the implementation team?

We did it in-house, which I prefer.

What other advice do I have?

It’s about each and every individual and organization.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user3426
Project Manager at a local government with 1,001-5,000 employees
Vendor
Review of QlikView
After seven years with this product, our number of new reports each year is still trending up, and the number of users is trending up. QlikView is helping us to uncover and address report/analysis needs that we never knew existed before. QlikView was a great solution for us based on our requirements: small business size (1200 users, mostly blue collar); no requirement for data warehouse, ability to do ETL within the load script (that's what eliminated Tableau for us); ability to to share interactive reports readily between users; and most important: optimized user experience, including easy to learn/use and short development cycles. We also needed integration with ESRI GIS which is (finally!) coming this year with a functional extension. As other departments come on (we are one…

After seven years with this product, our number of new reports each year is still trending up, and the number of users is trending up. QlikView is helping us to uncover and address report/analysis needs that we never knew existed before.
QlikView was a great solution for us based on our requirements: small business size (1200 users, mostly blue collar); no requirement for data warehouse, ability to do ETL within the load script (that's what eliminated Tableau for us); ability to to share interactive reports readily between users; and most important: optimized user experience, including easy to learn/use and short development cycles. We also needed integration with ESRI GIS which is (finally!) coming this year with a functional extension. As other departments come on (we are one department in a large-ish City) I think we will be able to manage the enterprise deployment through expression repositories, change management tools, and following other best practices. Our business users love it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Shabaz Shaikh
Software Developer at a construction company with 10,001+ employees
Real User
We implemented applications that combine CRM data and sales data from two completely different data sources. It's the first step towards big data.

What is most valuable?

Extraction from almost all data sources provides a lot of value to me. Ease of operation, data modelling and creating dashboards with simple objects and the abundance of visualizations are also valuable.

We extract our data from SAP BW as well as Update 7 data source. Extracting and associating these data to form Main Data Model is quite simple. The objects that QlikView provides can be used to make complex KPIs for visualization. Apart from these for visualization, we also implemented many extension objects of Maps with our QlikView applications.

How has it helped my organization?

We managed to implement applications combining CRM (Customer Relationship Management) data and sales data from two completely different data sources. It's the first (small) step towards big data. CRM data comes from Update 7 and sales data comes from SAP BW, which made it tricky to combine them and make common navigation possible.

What needs improvement?

I would like to see JavaScript or jQuery features added to it.

Dynamic changes with respect to page scrolling, responsiveness and actions related to it are what I am expecting in the next version.

Other than these, while adding named CALs in QMC, it would be really great if we could load all of the names from a single file (for example, an Excel sheet) together all at once.

The iPad application lacks some features. For example, container box object functionality does not work properly in iPads.

For how long have I used the solution?

I have been using this solution for more than 13 onths.

What was my experience with deployment of the solution?

We had issues. After deployment, while extracting data from SAP BW, a timeout error occurred many times. We haven’t found any solution for it. So, we have to keep reloading the job on QMC until it gets successfully reloaded for the day.

How are customer service and technical support?

Franky speaking, I have never contacted technical support.

Which solution did I use previously and why did I switch?

I did not use a different solution before Tableau. This is the first tool I have used for BI.

How was the initial setup?

I was not involved in the complete setup. However, its installation using multiple transports and connectors is quite straightforward.

What about the implementation team?

We implemented it with the help of a vendor team. (QlikTech)

What other advice do I have?

Deployment and configuration of this tool is very simple. The tutorials that come with the installation of the product are very helpful with creating dashboards and learning about the product in short time.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user297504
Data Architect at a comms service provider with 1,001-5,000 employees
Vendor
Its associative model helped us identify customer purchase behavior and we could define combos according to this information.

What is most valuable?

QlikView’s associative model is a fantastic design that enabled the Green/White/Grey feature. This feature greatly helped us highlight the relationship between different kinds of data.

To further explain the Green/White/Grey feature, let’s take a sales report of an electronics shop as an example. In this report, it may have dimensions (Product Category, Salesman) and expressions (Sales Qty, Sales Amount).

Green means the values of dimension that you have selected. Under the Product Category dimension, it will have different values e.g. Smartphone, Laptop, Desktop. If we want to see the sales performance of Smartphone, we can click on Smartphone, then it will become green. We can also select multiple values e.g. Smartphone and Laptop in the dimension.

White – shows the values of dimension which are related to the another dimension values that you have selected.

Grey - shows the values of dimension which are NOT related to the another dimension values that you have selected. By following the previous example, we have selected Smartphone in Product Category dimension. In the Salesman dimension, Salesman e.g. Jeremy or Janice who have have sold Smartphone will be shown in white color. Another Salesman, e.g. Roy, who didn’t sell Smartphone will be shown as Grey. This is very useful for us to identify relationship between dimensions

Its “Search Object” function is also very useful for us to search for the information we needed.

“Section Access” is another great feature as we can identify user authority on accessing data in an easy way.

Another feature "Set Analysis" which enabled us to configure different behavior for each dashboard. So that some dashboards (e.g. YTD) can be freezed and not affected by some of the filter selections.

How has it helped my organization?

My experience using QlikView was in a F&B chain store with outlets around the world. In such a F&B chain store, there are a lot of dishes and they are changing frequently with a high transaction volume.

In such an environment, a search function is very helpful for us when we want to find out the sales performance and trend of a specific dish.

Qlik’s associative model greatly helped us identify customer purchase behavior and we can define combos according to this information.

What needs improvement?

By comparing with the latest data discovery tools like Tableau, Qlik Sense and Sisense, the layout and colors are not eye catching enough. It looks like a very powerful excel with a lot of powerful features for analysis. But it may not be good for presentation.

For how long have I used the solution?

I used it for two years.

What was my experience with deployment of the solution?

Qlik is able to import data directly from a transactional database and create joins between the tables in there. However, I encountered a performance issue with high volumes of data.

Therefore, I suggest designing a data warehouse and use it instead as Qlik’s data source. The performance will be much better.

How are customer service and technical support?

Actually, I can’t remember any issue that I was required to check with customer service or technical support. For nearly all of my questions, I can get answers in the Qlik community.

Which solution did I use previously and why did I switch?

I have previous experience with IBM Cognos. It was a very comprehensive solution that can be used for pixel-perfect reports, email schedules and also data analysis. However, there are many more development and implementation steps than with Qlik.

Also, Cognos requires a steep learning curve even for a user with a technical background.

As we wanted an easy and user-friendly self-service BI solution, QlikView is more suitable from this perspective.

How was the initial setup?

On the server side, it is quite straightforward and we didn’t encounter any problem.

On the client side, the user can access it by browser or a desktop application. For the desktop installation, it can be downloaded from internet. And the configuration to connect the server is very easy; even end-users are able to do it. We prepared just one slide and end-users are able to follow it.

What about the implementation team?

We implement it through a collaboration with the vendor. The vendor team is responsible for installation and configuration. And the in-house team is responsible for development.

My advice is to use a data warehouse as the data source, which can greatly reduce Qlik implementation time, as creating too many joins in Qlik is not a best practice.

What's my experience with pricing, setup cost, and licensing?

My advice is to start small with the named license scheme as the price is much cheaper and it will be much easier to gain management approval.

What other advice do I have?

People who have interest on QlikView should also take a look on Qlik’s another product Qlik Sense. They have similar features (e.g. Section Access, Search function, Associative model).

QlikView relies more on the IT side. IT builds the base and a majority of end-users make use of it. Some power users can build dashboards, share with others and create formulas in there.

Qlik Sense is a self-service BI tool. It is easier to use and stronger in visualization. But some advance formulas might not be available.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user156729
Business Intelligence Data Architect at a construction company with 1,001-5,000 employees
Vendor
The fact that QlikView provides its own QVD structure, removes all dependency on having a DBMS in place before implementing.

What is most valuable?

The ability to provide drill down functionality quickly and easily into large data sets. Anyone working with a large amount of data in Microsoft Excel and then waiting ages for it to subtotal all that information, will certainly appreciate the speed and efficiency with which QlikView handles data. Users can get a lot more done, and a lot more data can be analysed in a shorter period of time.

The fact that QlikView provides its own QVD structure, as well, removes all dependency on having a DBMS in place before implementing QlikView – so it is cost effective.

The fact that QlikView can literally plug in to so many different types of data sources, as well, is a definite benefit.

The facility to auto-reload at scheduled times is great too!

How has it helped my organization?

My company was recently bought out by a competitor, now forming one group. The organisations are on different versions of a particular ERP solution, and the need immediately arose, from a regional and management executive level, for a dashboard to measure the sales performance of the group as a whole. Using QlikView, we managed to pull information from two different servers - one running off a QVD file structure, the other using a Microsoft SQL Server - and provide a consolidated sales performance model. This allows our executives to be able to examine the performance of their companies from a central point.

What needs improvement?

Some improvement to the user interface (for the developers). It could certainly use a re-vamp. The existing tab structure can be confusing sometimes and the controls that you would expect to find on one particular tab are actually on another.

I'm referring to the properties of the various charts that you can create within Qlikview – this brings up a dialogue box with a number of different tabs along the top;

In my opinion, for example, the tabs “Visual Cues” and “Style” could be combined into one. “Caption” for another example could be renamed to “Title Bar config” or “Chart Config” or something like that. Some aspects of the “Layout” tab could be added to “Presentation”.

The dialogue box itself isn’t quite wide enough, so if you end up going all the way to the right you have to click on an arrow a couple of times to see the tabs all the way to the left again, and you can’t resize it either – Why???. The box itself should be wide enough to encompass the number of tabs in a single view. Either that, or have a maximise / minimise buttons on it to give the users the choice.

There are no doubt a few others I can point out if I give more though to it, just my feeling of the product is that it can be a little unwieldy, especially to people initially learning the program.

For how long have I used the solution?

The company has had the solution for the last five years, I have been involved for the last two.

What do I think about the stability of the solution?

No issues encountered, the solution is stable, and the users are happy with the solutions provided.

How are customer service and technical support?

Customer service and support from QlikView South Africa is first rate. They respond quickly, and are always friendly, professional and very efficient.

Which solution did I use previously and why did I switch?

QlikView was this company’s first foray into making use of an external business intelligence tool.

How was the initial setup?

The setup is fairly simple, but you do have to have a decent level of technical knowledge if you are going to set up a Qlikview Server yourself. Otherwise, I’d suggest the use of a consultant. The client software is very simple to set up.

What about the implementation team?

We implemented through a vendor. The advice I would have is to ensure that you attend all necessary QlikView courses (i.e. designer / developer), to get a very clear idea for yourself exactly how QlikView works. Sometimes sales consultants will over-sell you on the bells and whistles of a product, and when you actually want to make use of it in a particular way, you might not be able to. This has not been the case during our QlikView implementation, but I have experienced other implementations that have been like this.

So you do need to be very clear on:

  • What exactly do you want to get out of a business intelligence solution, what data do you want to manipulate and analyse, etc.
  • For your own sanity, be very clear on how QlikView works and that you will get the solutions out of it that you want.

What was our ROI?

One cannot really place a monetary value on the depth of very valuable information that QlikView can help you extract. My advice also would be to be very clear on the licensing model you want to go for. The QlikView licensing model is complicated, so be sure that whoever is selling QlikView to you explains it thoroughly.

What other advice do I have?

I would suggest having someone in-house doing the development of your models for you, be it dedicated to that role or in addition to another duty. Nobody understands your business quite like you or the people working for you, and that is always advantageous when building solutions for the business. Not to put down external consultants, but doing it this way can save you a bundle into the bargain.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Business Analyst at a manufacturing company with 5,001-10,000 employees
Vendor
There's no need for any other tools, as ETL/scripting and visualisation are built right into one tool.

Valuable Features:

Strong visual capabilities, drill down function and data browsing. No need for any other tools, ETL/ scripting and visualisation built right into one tool.

Improvements to My Organization:

  • Ability to monitor progression towards certain deadlines and preset thresholds.
  • Ability to browse through the data by selections to quickly answer questions.
  • Easily export to excel or print for external use.

Room for Improvement:

While Qlik and their products are very intuitive and a pleasure to use as a developer of the dashboards and poweruser, many of my colleagues and stakeholders of information are used to static (paper) reports. This often leads to producing tables and graphs that are 'pinned down' (set analysis) to reduce the flexibility of the representations and the dashboards as a whole. (Qlik presents this as a core strength of their products.) 

Often this makes the formulas for these expressions and dimensions very complex. Of course you could argue that the users would have to 'mature' to use this new, more flexible, way of information. But it would be a great improvement for the Qlik products if it were able to easily 'lock' graphs without extensive coding.

Use of Solution:

Over 5 years

Scalability Issues:

Due to in memory technology, when datasets get really huge, rendering of graphs can take some time or even return out of memory.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Business Intelligence Director at a tech services company with 51-200 employees
Consultant
In-memory analysis and the associative database queries are valuable features.

What is most valuable?

  • In-memory analysis
  • Associative database query
  • Easy to use
  • Easy to install
  • Easy to maintain

How has it helped my organization?

Amazing fast response to complex business questions due to flexibility and easy to use.

We have increased our revenues by 30% because the rapid and effective insights provided with the analytics we built with Qlik.

What needs improvement?

I would like to see embedded predictive analytics models or more integration, connectors with advanced analytics platforms.
Qlikview is extremely good with descriptive analitycs. But when you need to predict using advanced predictive models like Logistic Regression or CART or decision trees, R and SAS institute for example are good at it, so if Qlikview would have this capabilities embedded or connectors to integrate with them will be a killer product.

For how long have I used the solution?

I have used it for nine years.

What do I think about the stability of the solution?

I have not encountered any stability issues.

What do I think about the scalability of the solution?

I have not encountered any scalability issues.

How are customer service and technical support?

Technical support is outstanding.

Which solution did I use previously and why did I switch?

I did not previously use a different solution.

What's my experience with pricing, setup cost, and licensing?

For the value you can add to your business, the TCO is low. There is a high price perception in the market, but this is relative.

If you do not take advantage of the solution, it definitely will look expensive but if you do, you will be happy.

Which other solutions did I evaluate?

For three months, we evaluated several solutions with installations provided by vendors such as Oracle BI, IBM Cognos, and SAP BusinessObjects.

The main challenge to prove during that phase was the ease of use without professional services support at that stage!!!

What other advice do I have?

I highly recommend this solution.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an OEM partner for business solutions.
ITCS user
Business Intelligence Consultant at a tech services company with 501-1,000 employees
Consultant
Dashboards are easy to build. It needs built-in monitoring of ETLs.

What is most valuable?

  • Ease of use for end user
  • Analytical reporting
  • Easy-to-build dashboards
  • Self-service reporting
  • Speedy deployment

How has it helped my organization?

The PoC for a new business area was not covered by the management reporting platform (controlling of IT processes).

  • Built-in monitoring of ETLs (there was no advanced tool for monitoring, planning and evaluation ETLs), I work with SAP BW (i.e. RSMO, RSPCM, ST13 transactions), of course there was an option to have additional expert tool but for a lot of additional money
  • Formatted reporting (PDF and export to Excel) - if necessary compile aggregate export to PDF document was not allowed to draw and do parameterized output compile or schedule it as a job with an appropriate distribution to the responsible user group, custom printing to PDF or Excel did not correspond to reality/original

What needs improvement?

  • Built-in monitoring of ETLs
  • Formatted reporting
  • Print to PDF
  • Export to Excel

For how long have I used the solution?

I have used it for half a year.

What was my experience with deployment of the solution?

I had integration issues with SAP BW.

How are customer service and technical support?

Technical support is very good.

Which solution did I use previously and why did I switch?

IBM Cognos was the original MIS platform. Within QV, there are better analytical reporting features.

What about the implementation team?

We implemented it in-house with some external support.

What was our ROI?

ROI is very long, > 5 year estimation.

What other advice do I have?

Assess the possibilities, advantages and disadvantages of the product as a whole with regard to the general characteristics of MIS systems and considering plans to use a management reporting platform across the enterprise.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultant at a tech services company
Consultant
It provides data discovery along with BI solution design, which is a distinct advantage for data analysts. Its visualization feature could be enhanced by adding more types of chart designs.

What is most valuable?

Because it provides data discovery along with BI solution design, it has a distinct advantage for data analysts. Associative Experience is also valuable.

How has it helped my organization?

The solution can be implemented quickly (normally within three months) with a low implementation cost.

For how long have I used the solution?

I have been using QlikView for the last four years & am currently working on version 11.2 SR14.

What was my experience with deployment of the solution?

Deployment of the QlikView solution is more or less smooth & simple compared to other BI solutions.

What do I think about the scalability of the solution?

Scalability is directly proportional to RAM size & the number of concurrent users accessing the solutions. We didn't see…

What is most valuable?

Because it provides data discovery along with BI solution design, it has a distinct advantage for data analysts.

Associative Experience is also valuable.

How has it helped my organization?

The solution can be implemented quickly (normally within three months) with a low implementation cost.

For how long have I used the solution?

I have been using QlikView for the last four years & am currently working on version 11.2 SR14.

What was my experience with deployment of the solution?

Deployment of the QlikView solution is more or less smooth & simple compared to other BI solutions.

What do I think about the scalability of the solution?

Scalability is directly proportional to RAM size & the number of concurrent users accessing the solutions. We didn't see major stability-related issues post-deployment.

How are customer service and technical support?

The Qlik support team is very active & responsive. Issues are mostly resolved on time.

Which solution did I use previously and why did I switch?

I hadn’t used any other BI tool, but our organization migrated to QlikView from SAP BO because of its associative experience & quick deployment time.

How was the initial setup?

Initial setup was complex with respect to building the same project environment for a different business domain.

What about the implementation team?

Implementation was done directly by Qlik, which made sure the best design methodologies were kept in place.

What was our ROI?

ROI is much better compared to BO because deployment time & cost are both reduced.

What's my experience with pricing, setup cost, and licensing?

Qlik’s pricing / licensing policy is fair enough.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Business Analyst ( Marketing BI Analytics) at a tech vendor with 10,001+ employees
Vendor
You can use bookmarks for filters, rather than entering inputs every single time.

Valuable Features

The server load, the QVD load, ease of variable declaration, and the different dynamic charts are very valuable to me.

Improvements to My Organization

Our complete BI transformation and production was done through QlikView instead of basic Excel reporting and analysis, reducing manual input, ease of automation and more reliability in numbers, thanks to fewer human input errors.

Room for Improvement

Currently we are building a pane to use filters and select options. For a dashboard, if they would add a "Column value" filter option like what you see in Amazon on the left hand side, that would be useful.

It could also have an autosave feature, which it direly lacks.

A direct feature to export views to PowerPoint, instead of external plugins, could be useful.

Sometimes large files are difficult to read and QlikView crashes midway. So you need to start from scratch. Instead, if it could support reading and processing large files with a lot of records (4 million +), that would be useful. This was one such issue we faced while doing a BI transformation as the data generated was huge.

Use of Solution

I have used QlikView for 3-4 years now.

Customer Service and Technical Support

We did not seek technical support. I simply researched answers in forums and through Google searches, blogs etc.

Implementation Team

With the help of IT teams, the QlikView online servers were set up (one for production, one for testing). So, implementation was done completely in-house.

ROI

ROI can't be measured directly, but the power of BI can be visualized through QlikView.

Pricing, Setup Cost and Licensing

I personally feel the QlikView server license is extremely expensive and might not be affordable for most organizations. However, all clients felt QlikView was so easy to operate, see results live and visualize in great charts, easily copied to PowerPoint. They were able to easily log in, select their regions, time period and view the results in a single shot instead of viewing multiple Excel reports and looking up, etc.
They used bookmarks for their filters and that made it even easier, rather than entering the inputs every single time.

Other Solutions Considered

We evaluated Spotfire, Tableau and finally chose QlikView to be deployed for all dashboards in the organizations.

Other Advice

QlikView can be a powerful tool in your organization if you are serious about a complete BI transformation and moving away from standard Excel reporting.

Given standard training and experience, migrating to QlikView is a very good choice.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Vice President, Business Continuity Manager / Information Security Officer / Project Manager at a financial services firm with 10,001+ employees
Vendor
Comparing it to Microsoft Access, it feels about 10 times quicker.

What is most valuable?

The ability to capture data from multiple sources, quickly link by key fields and quickly analyse in a dashboard proved to be such powerful features that we reduced the use of Microsoft Excel and Microsoft Access almost entirely for any kind of reconciliations.

I worked in a financial institution having most data in mainframes but also having extracts and datasets put into various places from highest quality Oracle and MS SQL server objects right down to MS Access/Excel and continuing to Text File output.

Sometimes for either quality control purposes daily or some other kind of reconciliation or verification, QlikView was great for a basic end user with minimal skill to bring that data in and map it as necessary to achieve the desired result. (Often the datasets easily map via a couple of primary fields that the business users understand and outside developers may not understand without a business analyst specification)

Most times making that ad hoc effort a template of some sort and making mundane roles like daily recons be easily achievable.

Doing this same work in MS Excel or MS Access can be tricky and dangerous and not be as intuitive for non-technical people. Doing it other ways can end up being too much effort with hiring developers and building systems and paying for a lot of developer man-hours when a quick QV dashboard does the trick by the business end user.

How has it helped my organization?

This product improved how my organization conducted repeatable analyses, such as a user access internal audit review for 500 users over 100,000 user ID and system access across 50-100 systems. My first project before we had QlikView took about a month, but after we rewrote the procedure using QlikView, it was much better and took about a week. We pretty much used the same raw data, but the report and analysis was so much quicker.

The process of gathering the data and using Microsoft Access used to take a month or so. Certainly, using QlikView as an ad-hoc tool is very powerful, yet easy. Comparing it to development on Microsoft Access, it feels about 10 times quicker. You go from raw data almost directly to reporting. (Skipping the hassle of lots of queries, forms, and slow report creation.)

As they say, "Seeing is Believing”.

What needs improvement?

While it used to be extremely easy to work with for me, at least the basics, some other folks used to have a bit more trouble using it. I think that it might be useful if the first-time user wizard was a bit better. It might help people get the “Eureka “ moment on their own. I always felt that the wizard was not really worth using, and I started people off with making their own import scripts with my help. Others also seemed to believe that as well.

I think the wizard could take a bit more time and provide training along the way. For example, show the data to be imported, and go over some of the best practices. And maybe continue on with going over the Edit Script and hit some of the basics there as well and so on.

I think all things are covered in the tutorial, but I had very little success having people use the tutorials.

Some aspects are so common, and used so much:

  1. Basic import of data, load, review the field names that come in, set your fields as “what you want”
  2. Import a different table, review as in step 1, but check for synthetic links, do your “AS” statements to clean up, and get the linkages you want, etc.
  3. Then have some wizard to make tables and charts in the same way, etc.

I do these things with new users inside of a couple of hours, including usually helping tham make their first solution.

For how long have I used the solution?

I used QlikView for five years.

What was my experience with deployment of the solution?

Never has this been a problem, but mostly in our company, we focused on using QlikView standalone.

We had tons of core and server architectures, and QlikView was used to improve reconciliation and quality control.

Ultimately, there is great power in using QlikView to be an enterprise solution (in the right context). But the user base was able to get so much productivity out of our approach.

And to get an enterprise solution in place required a budget and resources, which we did not have.

How are customer service and technical support?

Technical support is excellent, the user groups are really good, and outside of that, there are excellent web resources via YouTube (e.g. AnswerSharks) that have evolved.

In reference to user training, I sent people to these sources even more than to QlikTech themselves.

I left my firm just before QlikTech was finally given the go-ahead to design some product solutions for us. (Having ad-hoc users design things worked, but it was time to get more polished internal- and customer-facing solutions to take us to the next level.)

Which solution did I use previously and why did I switch?

As a global firm, we actually looked at many products, even signing a multi-year contract with a QV competitor (Tibco Spotfire, but the enemy of efficiency for analysis is MS Excel).

For SpotFire, it was always my opinion that that deal was done on a golf course, because QlikView over the years was the better product by far (certainly, all users loved it) versus the other product, which very few users understood, and certainly users did not show anywhere near as much affection for it.

How was the initial setup?

We went for standalone licenses in the beginning of about six, and over several years the license count grew to 60. When I left the company in late 2015, we were looking finally getting a server.

I do not know the status now, but the company should have been given serious thought to getting a server, and perhaps converting some of the licenses to QlikSense.

What about the implementation team?

A vendor team implemented it, but it was more like a sales team. We just asked for more licenses and put the server deployment on hold for way too long.

Although users were very happy, the cross-division expansion that I felt was possible never happened.

The biggest problem out there is that most people keep thinking, If it ain’t broke, don’t fix it. I believe that people use MS Excel way too much, and that is a symptom that something is broken.

Also, I used QV to pull data out of core systems often whenever reconciliations were questioned. (Analyzing the source directly is better than another Excel spreadsheet.)

What was our ROI?

We pretty much measured our success in man-hours saved or efficiency gains:

  • We did not aim high, but certainly, I put together a number of solutions that worked flawlessly, and could save between 1-3 hours every day.
  • More importantly, we applied this analysis tool, were able to benefit from very high quality analysis and recon, improving employer quality of life.

What other advice do I have?

QlikView requires a little bit of “handholding”, which was provided via a small expert group at my last employer. (Originally, we got to a “Yeah, I get it”, Eureka moment after one or two two-hour, on-site visits from the sales support team. Add a phone call or two.)

I would suggest that while returns on efficiency would be quick, it is worth it to consider expanding the user group sooner, and having a strategy to grow the user bases very early on. I compared this tool to the over-use of MS Excel and MS Access to attempt to do similar things in my organization.

And while we saved lots of time and effort in the areas that QlikView was used, the real target I had was to take PowerPoint off its pedestal for management reporting.

We never quite got there, but I envisioned that dynamic usable reports was a much loftier goal than death by PowerPoint. (But it must be said that lots of executives love their PowerPoint, which has continued to mystify me.)

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user231753
Profesional Management Database and Server, Networking, Virtualization Server. at a manufacturing company with 51-200 employees
Vendor
Easy to install and connect to MS SQL Server, and provides sales analysis with attractive graphics.

What is most valuable?

It is very simple to use. When I use QlikView, I just install it and then connect it to MS SQL Server. After I make a successful connection, I can, for example:

  1. Create a simple procedure in MS SQL Server.
  2. Execute the procedure to get the information I need in a column.
  3. Design a QlikView report that includes the column from the procedure to preview it in QlikView.

How has it helped my organization?

It provides sales and other analysis with good visual graphics.

What needs improvement?

I would like to see the possibility to change the program if the new program is better than last program.

For how long have I used the solution?

I have used this solution for just three months, because we don’t have enough employees to manage it.

What was my experience with deployment of the solution?

It requires a lot of RAM on the PC.

Which solution did I use previously and why did I switch?

We will possibly continue using the product.

How was the initial setup?

It is very easy to install.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user72435
Solution Architect at a healthcare company with 1,001-5,000 employees
Real User
It is excellent for number crunching with basic visualizations and known questions.

What is most valuable?

The associative/relationship engine and fast performance are the most valuable features of the product for me. It is excellent for number crunching with basic visualizations and known questions.

How has it helped my organization?

QlikView is used internally for financially-focused groups. It has moved folks out of Excel land into interactive/shared analytics.

What needs improvement?

I would like to see improved performance/scalability at high data volumes + high user concurrency. Having only in-memory capability for hosting source data is a constraint.

For how long have I used the solution?

I have been using QlikView for 2.5 years.

What was my experience with deployment of the solution?

No issues with deployments/stability. Departmental-scope in use has it well-positioned here.

How are customer service and technical support?

Technical support is very good.

Which solution did I use previously and why did I switch?

Nothing else was reviewed, given the business area lead had previous experience with QlikView and wanted that for his department.

How was the initial setup?

Initial setup is straightforward. It is not a complex system to install.

What about the implementation team?

We used a regional vendor that had experts in the platform to help us install/configure/jumpstart our use, working directly with the business department in need.

What was our ROI?

ROI is unknown. However, licensing costs continue to increase in QlikView and in Tableau, which we also use, forcing us at some point to consider consolidating to one and/or turning some existing/owned MicroStrategy licensing inward to replace if the the upward pricing trend continues.

What other advice do I have?

Pick the right tool for the job/consumers of the products. There is not a single product that can cover all personas/use cases well or there would be only one product out there commanding the world – and there’s simply not just one. QlikView is great for numbers-focused users who live in Excel today and want a better way to create common metadata and analytics that can be easily distributed/consumed by target users.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Business Information Expert Performance Measurement at a manufacturing company with 10,001+ employees
Real User
It combines ETL with powerful scripting options and a fast, flexible front end.

What is most valuable?

  • Combination of ETL with powerful scripting options and a fast, flexible front end makes it like a Swiss army knife
  • Powerful front end, which allows us to make very user-friendly interfaces
  • The associative model, which allows for truly integral reporting

How has it helped my organization?

The combination of quick, agile delivery combined with a front end that allows you to easily drill through from high-level dashboards to low level details means that we can deliver according to the business case. Compared to our other tools (e.g. SAP BO), business users are using this tool a lot more.

What needs improvement?

  • Chart types; some look a bit outdated, would love to see Qlik Sense- or Tableau-like visuals
  • Central formula/measure repository, can now only be done with variables

For how long have I used the solution?

I have used this solution for eight years.

What was my experience with deployment of the solution?

Deployment is very easy and quite stable. Only drawback is that the server can stop functioning if not enough memory is available, so that needs active monitoring once you are close to the limit.

How are customer service and technical support?

Good, quick responses and mostly the support team is very knowledgeable. You don't have to go through multiple layers that delay the resolution, like with some other products we have experience with.

Which solution did I use previously and why did I switch?

We have everything, but the combination of functions in one tool as well as the good support and quick implementation times make QuickView our preferred tool for most use cases.

How was the initial setup?

Straightforward, easy installation (next-->next-->next). Single sign on was a bit more complex, but way easier than with SAP BO, for example.

What about the implementation team?

We have implemented it with vendor teams and in-house ones (multiple installations). For a simple scenario with one server, just do the training and you can do it yourself. For a more complex scenario (we have a cluster of six servers in the cloud), it is better to let the vendor do it; they have the best connections for the complexities of clustering.

What's my experience with pricing, setup cost, and licensing?

License prices are quite high; it makes the roll-out slow as you first have to convince people of the benefits. When growing, session licenses are the best; we achieve a ratio of 1:30 for the average user.

What other advice do I have?

Perhaps if you start from scratch, it is better to start with Qlik Sense, as it seems that most development effort goes into that product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Reporting Analyst at a insurance company with 1,001-5,000 employees
Vendor
Non-technical stakeholders can quickly engage with and navigate through their data as business information.

Valuable Features

QlikView enables fast visualisation, analysis and navigation through data. It is very flexible, and offers easy-to-develop, quick-value tools for navigating and understanding data.

Improvements to My Organization

QlikView allows non-technical stakeholders to quickly engage with and navigate through their data as business information.

Room for Improvement

Data modelling is often a protracted process, with no toolset available apart from scripting. The consequent data models are not very portable at all.

Use of Solution

I have used this solution for five years, sometimes more intensively than others.

Stability Issues

One of QlikView's greatest strengths is its in-memory handling of large amounts of data. The flipside to this is some ongoing leakage, which makes it sensible to reboot once a week.

Customer Service and Technical Support

Qlik's support model for everyone except large enterprises is through consultant partners, so it depends on the quality of the partner. On the whole, they seem to be good.

Implementation Team

It was implemented via a consultant partner. They were technically very good, but one should ensure the consultant delivers comprehensive documentation. A solution is only as good as the ability to navigate through it and enhance it as the business changes.

Other Advice

Although normal advice would be to mandate that the implementation deliver to business-specific requirements, it is strongly recommended to understand the product's great capabilities, and to exploit the competitive advantages of the product. Otherwise, it becomes just another business intelligence tool blindly shoehorned into a business that doesn't gain the best value and ROI from it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user342081
Information Systems Development Manager(Senior) – Divisional Manager at a financial services firm with 1,001-5,000 employees
Vendor
With its associative data capability, one click causes a whole ripple effect though the whole dashboard.

What is most valuable?

QlikView’s associative ability. The AQL that QlikView uses to associate and ‘bring together’ similar data types (based on name) is extremely powerful and useful. One click causes a whole ripple effect though the whole dashboard, because everything is associated to one another.

How has it helped my organization?

We have used code to create a calendar effect. We then loop through that calendar, executing SQL at the end of each month. This is not easy to mimic in normal SQL, and would require an SQL package to perform such a thing.

QlikView allows us to perform these feats with ease.

What needs improvement?

QlikView does not work very well with very large data sets. I would like to see that improved.

For how long have I used the solution?

I have used this product since Jan 2013.

What do I think about the stability of the solution?

Besides the stability issue with large data sets, I have not encountered any other deployment, stability or scalability issues.

How are customer service and technical support?

Technical support is 3/10.

Which solution did I use previously and why did I switch?

I have not evaluated any solution similar to QlikView (e.g. Tableau).

We did not previously use a similar solution.

How was the initial setup?

Initial setup was straightforward.

What about the implementation team?

A vendor team implemented it. They knew the tool best and we could get it up & running a lot quicker. Part of the implementation included training.

What was our ROI?

Not easy to answer. What we use it for, internal to the company, is to track internal costs as we manage quite a number of cost centers. We've successfully managed our budgets and have recovered quite a substantial amount of money for our CC as QV has allowed us to track incorrect CC billing.

What other advice do I have?

QlikView really works well. We have had no complaints from users about its functionality. There has never (or hardly) been a time where a user makes a comment like “Oh, pity that QlikView can't do this…”

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user373044
Partner at a tech company with 51-200 employees
Vendor
It improves development productivity and allows self-help BI.

What is most valuable?

The ability to build models that allow business users to do their own what-if analysis on the correct data.

How has it helped my organization?

The business was previously using Crystal running on top of hardcoded SQL stored procedures and Qlikview. Qlikview improves development productivity and allows self-help BI.

What needs improvement?

I would like to see more ‘drag and drop’ functionality as, in my opinion, there is still too much coding required to join tables correctly.

For how long have I used the solution?

I have been using this solution for 18 months.

Which solution did I use previously and why did I switch?

As mentioned, we previously used Crystal as well as Oracle OBIEE and both are inflexible and time-consuming.

How was the initial setup?

Initial setup was very straightforward, plus the team had set up Qlikview previously.

What about the implementation team?

We used a vendor team for implementation and that’s probably the way to go first time around, but there must be a skills transfer.

What's my experience with pricing, setup cost, and licensing?

Qlikview are always willing to negotiate pricing, especially if you mention that you are evaluating Tableau as well.

What other advice do I have?

Don’t believe the sales talk that you don’t need a datamart or data warehouse to run Qlikview on top of. It can run against ERP data but then the queries get very complicated and cumbersome.

Disclosure: My company has a business relationship with this vendor other than being a customer: We have done joint BI and EIM projects together in the past.
it_user198027
Director, Business Analytics at a recruiting/HR firm with 51-200 employees
Vendor
You can use its scripting capabilities to perform complex calculations and provide the required information much easier than other BI software.

Valuable Features

It allows you to establish business data models on an associative basis, and to do on-the-fly analysis on associated data for deep understanding / insight.

For complex analysis, its scripting capabilities enable one to do complex calculation to present required information much easier than traditional / other BI software.

Improvements to My Organization

I have implemented both QlikView and Qlik Sense solutions for our customers/organizations in multiple industries.

The immediate improvements allow organisations:

  • To analyse data more comprehensively (e.g. in the areas of risk management and customer profiling/segmentation) to provide greater insight / understanding
  • To make data available more quickly to facilitate decision making, especially for exceptional cases (e.g. when not meeting KPIs)

Other side benefits derived from implementing such projects are:

  • Data gaps: It can identify insufficient or unavailable data for making better decisions.
  • Process gaps: It can identify business processes that need to be improved, e.g. manual processes that need to be fine-tuned or automated.
  • System gaps: It can identify areas where the system needs to be improved e.g. improvement to existing system functions, or a new system needs to be put in place.

With such gaps and their relationship to the values of decisions, an organisation is able to prioritized resources to address those gaps over time.

Room for Improvement

Improve its table/data editor to allow easier ways to pull multiple data from multiple sources and associate them to establish a complete business data model.

Consider providing more features that allow the decision-making process of analysing different data at different levels to be captured. Maybe a decision-making flow/process editor for Qlik sheets and objects at the presentation layer.

Use of Solution

I have used QlikView for approximately five years.

Deployment Issues

You can encounter deployment issues if you do not follow good / recommended “best practices”. Such issues can always be resolved through better design of the implemented solution.

By adhering to good practices, deployment, stability and scalability should not be an issue.

Customer Service and Technical Support

Technical support is average.

Initial Setup

Initial setup is straightforward and much easier than other traditional BI software.

Implementation Team

We are a Qlik implementation partner. We implement Qlik solutions for customers.

ROI

Our customers’ ROI is typically within 1-3 years, depending on the size and complexity of implementations.

Pricing, Setup Cost and Licensing

Initial pricing/licensing of QlikView and Qlik Sense are competitive to the market. However, as the number of users grows, it could be costly.

Other Advice

You need to understand well the users’ decision-making process, the data requirements and the actions users want to take. It is OK to start a Qlik project without complete data available.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior Manager at a consultancy with 10,001+ employees
Consultant
The associative engine and feature-rich expression scripts are the most valuable features of this product.

What is most valuable?

The associative engine and feature-rich expression scripts are the most valuable features of this product.

How has it helped my organization?

Easy, low-TCO solution to consolidate and visualise data for analysis and reporting purposes. It provides better visibility of the company's position and its operations.

What needs improvement?

I would like to see more visualisation objects features.

For how long have I used the solution?

I have used QlikView for more than a year.

What was my experience with deployment of the solution?

I encountered minimal deployment issues.

How are customer service and technical support?

Technical support is excellent.

Which solution did I use previously and why did I switch?

I have experience with other similar…

What is most valuable?

The associative engine and feature-rich expression scripts are the most valuable features of this product.

How has it helped my organization?

Easy, low-TCO solution to consolidate and visualise data for analysis and reporting purposes.

It provides better visibility of the company's position and its operations.

What needs improvement?

I would like to see more visualisation objects features.

For how long have I used the solution?

I have used QlikView for more than a year.

What was my experience with deployment of the solution?

I encountered minimal deployment issues.

How are customer service and technical support?

Technical support is excellent.

Which solution did I use previously and why did I switch?

I have experience with other similar visualizers, but QV offers a better experience in terms of ETL development.

How was the initial setup?

Initial setup was straightforward, with a simple, easy interface. We had a simple setup anyway, not much complexity. We were able to get QV up and running in a very short turnaround time.

What about the implementation team?

It was implemented in-house assisted by a lean vendor advisory team.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are also an SI partner.
ITCS user
Service Delivery Manager - EABL at a consumer goods company with 501-1,000 employees
Vendor
Data mining and consolidation are the products most valuable features to me.

What is most valuable?

Data mining and consolidation are the products most valuable features to me.

How has it helped my organization?

I was using this to track KPI’s on my outsourced end user support (ticketing, resolution & time it takes to resolve). This forced my contractor to deliver because QlikView provides an analysis of the issues as they appeared.

What needs improvement?

I would like to see improvements to scheduled reporting and the capability to email the user.

For how long have I used the solution?

I have used this solution for over four years.

What was my experience with deployment of the solution?

I was using the cloud-based solution, so I didn’t have any issues.

How are customer service and technical support?

Technical support was super, can't…

What is most valuable?

Data mining and consolidation are the products most valuable features to me.

How has it helped my organization?

I was using this to track KPI’s on my outsourced end user support (ticketing, resolution & time it takes to resolve). This forced my contractor to deliver because QlikView provides an analysis of the issues as they appeared.

What needs improvement?

I would like to see improvements to scheduled reporting and the capability to email the user.

For how long have I used the solution?

I have used this solution for over four years.

What was my experience with deployment of the solution?

I was using the cloud-based solution, so I didn’t have any issues.

How are customer service and technical support?

Technical support was super, can't complain.

Which solution did I use previously and why did I switch?

I had used other solutions, but they didn’t give me the kind of reporting & analysis I got from QlikView.

How was the initial setup?

Set up was easy. Being technical, I found it easy and straightforward.

What about the implementation team?

For our installation, we used the vendor. However, for my peace of mind and understanding, I was involved throughout the process.

What was our ROI?

ROI was not a consideration for me, though I would would say it was a great tool I would have equally gone for, even if it involved doing the ROI.

My use was more about service measurement & improvement.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Technical Associate at a real estate/law firm with 10,001+ employees
Vendor
The dynamic interactive dashboard is the most valuable feature of the product to me.

What is most valuable?

The dynamic interactive dashboard is the most valuable feature of the product to me.

How has it helped my organization?

Lots of scripting used to be required to build high quality dashboards.

What needs improvement?

This cannot be considered a self-service product. It requires IT support.

For how long have I used the solution?

I have used QlikView for one year.

What do I think about the stability of the solution?

This is quite a stable product, but very huge data loads must be complemented by good hardware. Otherwise, there could be performance issues.

How are customer service and technical support?

Technical support is OK.

Which solution did I use previously and why did I switch?

The only reason we chose this product is its dynamic interactive dashboard. It works well on iPad. We liked the product, as compared to MS BI.

How was the initial setup?

Initial setup is quite straightforward, but it requires good hardware for high data loads.

What about the implementation team?

An in-house team and a vendor team collaborated on the implementation.

What's my experience with pricing, setup cost, and licensing?

It is quite expensive. There are two types of licenses: Named User licenses and Doc CAL licenses.

What other advice do I have?

You need to have good scripting skills.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Data Analyst at a financial services firm with 501-1,000 employees
Real User
I like the connectivity integration options and load script engine.

What is most valuable?

  • Load script engine (or "ETL" ability)
  • Connectivity integration options
  • Data visualizations / dashboarding

How has it helped my organization?

As a start-up, projects need to move fast and this product has enabled us to have data solutions ready when the business needs it.

What needs improvement?

  • Better compatibility with Qlik Sense
  • Better support for non-Microsoft platforms
  • SFTP support in the load script
  • More built-in connectors

For how long have I used the solution?

I have used it for three years.

What was my experience with deployment of the solution?

We wanted to upgrade to version 12 but had two models that were not reloading as expected and had to revert.

How are customer service and technical support?

Technical support is good.

Which solution did I use previously and why did I switch?

We chose this product because we needed to connect to the source system and report directly from it.

It was already established when I started.

How was the initial setup?

Initial setup was straight forward. The only challenge is maintaining a custom user directory by hand, because of a lack of Active Directory in the organization.

What about the implementation team?

Now we do everything in house. At the very beginning, before I started, we had vendor support.

What was our ROI?

ROI is tricky to measure but I'll give some examples:

  • Finance can now do month-end statements in one day instead of seven.
  • We can determine if a new product in a new market will be profitable within weeks of launching a pilot.
  • Engineering is free from having to run database queries to answer business questions.

What other advice do I have?

You need at least as much RAM on your server as the largest database table you will read, and it can't be a virtual installation.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Solutions Manager Business Intelligence at a marketing services firm with 51-200 employees
Vendor
With in-memory calculations at the UI, it is possible to build charts, tables, etc. directly on the user interface.

Valuable Features

  • The in-memory engine is really powerful, making it possible to deal with huge data records on the fly (more than 400 million in a table). I have built data models with over 1 billion records and the performance is good.
  • With in-memory calculations at the UI (on the fly), it is possible to build charts, tables, etc. directly on the user interface (UI).
  • Cubes are built on the UI. No need to pre-aggregate data, but it is of course possible to do that in the script (which I would not recommend) or better deliver data as SQL-View.
  • Scripting possibilities to build complex applications and functionality.
  • Web integration capabilities, for ex. you can include JScript Objects or R for better visualization.

Improvements to My Organization

We are service providers and built applications for our customers, not for us. Our customers are able to evaluate their marketing campaigns at the aggregated and customer levels. They can use micro-segmentation to select the leads.

Room for Improvement

We actually use QlikView, which does not allow easy-to-use framework management. There is a deployment framework, which I do not find easy to use and somehow not stable. I hope QlikView can improve this.

Use of Solution

I have been using this solution for 3.5 years now.

Deployment Issues

There is no general rule, but we use the deployment framework, which allows us to produce a QV application user with four different levels of deployment:

  • One level for the extraction of the data (1 to 1)
  • In the second level, we get the original tables and based on the user requirements, build the data model and make the necessary transformations.
  • In the third level, we get an intermediary state of the data model to be loaded in the end-user application.
  • The fourth level contains the end-user application. We do a “binary” load, which is a command line in the QlikView script that allows us to copy 1-1 to the application we are copying from, in this case, from the third level. We have separate development from production and testing in a highly reachable environment (cluster environment).

Stability Issues

It is stable, but of course stability depends on your IT infrastructure and deployment chosen.

Scalability Issues

Data model, data size, RAM size, hardware CPUs and UI expressions / charts, are strongly related. It is possible to scale QV without problems, but the issue is more complex than not having enough RAM. Complex expressions at the UI level, single threaded object calculations, complex data models, huge data size, etc., can alter the performance of the QV application and thus we might think we need to scale. There are many tools to measure QV performance and to try keep them at an optimal level. Otherwise, if everything else is fine, we need to increase RAM. Actually, we have 1 TB RAM on our production server.

Customer Service and Technical Support

Technical support is good, but could be improved.

Initial Setup

Initial setup was straightforward. You need a server, install QlikView with its web server option and then you can start doing applications.

For more complex architectures (clustered, with two or more servers), you will probably need Qlik Tech support.

Implementation Team

We contacted Qlik Tech directly for a cluster implementation (at my current company).

Pricing, Setup Cost and Licensing

Pricing/licensing depends on your company size, the uses of QV, # of users, among others. Named CALs, at approx. 1.200 EUR (see the Qlik website), would be required if you have permanent users with write access to different applications, while Document CALs are good if you have users that will only see a document to perform their jobs. There is good and simple documentation explaining your best pricing / licensing model.

Other Solutions Considered

For my previous company I compared Tibco, QlikView, Tablaeu, and other tools, as indicated in the Gartner Quadrant. We did workshops with them, and were happy with QV because you can build something immediately. In the case of Tablaeu, you need a really well-established ETL and / or views. Otherwise, it is complicated for a normal user to build correct charts. Users have normally very little understanding of the data structure. Other tools need pre-aggregation and a long development process. With QV, it is possible to use views, pre-aggregated or raw data and you can still manipulate the data in the script, i.e. do ETL (see Deployment Framework).

Other Advice

  1. Check your user and business requirements first and check if QV can help you solve your user / business needs.
  2. If yes, check what are the potential uses of QV and describe the environment, company or unit size, # of users, # of applications, # of KPIs, and data volume. After this first check, you may be able to determine how big would your applications be, and thus estimate current and future RAM, necessary IT Infrastructure, # of servers, etc. I would talk to IT to see how to integrate QV into your IT environment. Many people start with an isolated QV implementation in their unit, which is fast, but then you have no single point of truth (this may discourage adoption because the user does not trust the data). But it depends on your goals.
  3. Start working and promote user adoption, showing good functionality, fast implementation, and reliable data. QV can then become the main BI tool in the company.
  4. Looking forward, QV can be extended in the use of mash-ups, Jscript extensions and analytics with R, so that you can build up in the future. Qlik Sense is a new Qlik Tech product, which offers many new possibilities.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Managing Director at a tech services company with 501-1,000 employees
Consultant
It eliminates left, right, inner joins, and takes care of creating links between different tables.

Valuable Features

QlikView's associative data model is the key feature of this application, which makes it superior amongst other competitors. It eliminates left, right, inner joins, and takes care of creating links between different tables.

Other valuable features are the Power of Gray, on-the-fly data cloud creation, and its ease of use and deployment.

Improvements to My Organization

With the Power of Gray, QlikView shows you what you are doing and what you are not doing.

Room for Improvement

New graph / chart objects need to be added.

Use of Solution

I have used QlikView for the last four years.

Deployment Issues

Deployment with a big data cloud is a challenge so far.

Customer Service and Technical Support

Technical support is very good.

Initial Setup

Initial setup was straightforward.

Implementation Team

Before you start implementing it right on your computer, you have to design the data model on paper. Once you have an error-free data model on paper, you can finish the project earlier than planned.

Pricing, Setup Cost and Licensing

Pricing and licensing depends upon the offer made by the vendor. However, QlikView ROI is extensively very high. We have seen it when we receive upsell requests from clients.

Other Advice

There are different tools in market, we have to differentiate between visualization and analytical tools , QlikView is analytical and descriptive tool.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a partner and reseller.
it_user374679
IT Admin at a insurance company with 501-1,000 employees
Vendor
Qlik takes less time to set up data sources and enables us to integrate multiple tables.

What is most valuable?

Data visualization and the data modeler are the most valuable features of this product to me. I noticed that Qlik takes less time to set up data sources and enables us to integrate multiple tables. It is easier to manage variables with Qlik's data management.

How has it helped my organization?

As an insurer, we foresee that Qlik will improve reporting processes.

What needs improvement?

I predictive analysis is an area with room for improvement.

For how long have I used the solution?

We will be starting implementation in August 2016.

How are customer service and technical support?

Technical support is best in class.

Which solution did I use previously and why did I switch?

We evaluated three other products. We chose this product because of its cost effectiveness, quality of services and advice.

How was the initial setup?

Initial setup is straightforward. The vendor gave us a better understanding of the Qlik environment, data and dashboard development before moving to full training.

What about the implementation team?

A vendor team implemented it and provided clear advice in writing.

What was our ROI?

We were provided useful advice with competitive pricing that supported our decision to purchase five licenses in the first phase of the project.

What other advice do I have?

IT from some other companies have asked me, and I recommended that they use Qlik.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Database Expert at a university with 501-1,000 employees
Vendor
The most valuable feature of this product is quick and easy access to data by top management, in an elegant and colorful display that make is easy to visualize numbers.

What is most valuable?

The most valuable feature of this product is quick and easy access to data by top management, in an elegant and colorful display that make is easy to visualize numbers.

How has it helped my organization?

We are able to provide top management with dashboards that connect different applications together, and gives them visibility and decision-making abilities that simple reports don't.

What needs improvement?

The management console is cumbersome to use for managing large numbers of users and documents.

For how long have I used the solution?

I have used this solution for five years.

What was my experience with deployment of the solution?

I did not really encounter any issues with deployment, stability or scalability.

How are customer service and technical support?

Support and customer service are highly rated.

Which solution did I use previously and why did I switch?

We evaluated this product against other BI products such as OBIEE and Cognos. We preferred QV because of its ease of use and fast deployment and development of dashboards.

How was the initial setup?

Initial setup was straightforward. We just installed the Server Edition and configured it in no time.

What about the implementation team?

We implemented it in-house. There are no specific skills needed, except basic knowledge of Windows.

What's my experience with pricing, setup cost, and licensing?

We mainly use QV for providing dashboards to top management, as licensing is very expensive.

What other advice do I have?

QlikView is a great product to get you up and running easily and quickly. However, it does not replace an enterprise reporting solution. It should be used for specific needs and would be too expensive and cumbersome to manage to deploy across the whole institution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user348648
IT Specialist at a local government with 1,001-5,000 employees
Vendor
Our productivity-to-cost ratio is much higher than Oracle BI.

Valuable Features

  • Ease of use
  • High custom development potential
  • Adaptability

Improvements to My Organization

We are now getting coordinated management areas, which were practically delinked until now.

Room for Improvement

  • More support through contextual menus
  • Adapting to the new Qlik Sense (HTML 5) environment

Use of Solution

I have used it for eight months.

Deployment Issues

I encountered difficulties managing computer RAM.

Customer Service and Technical Support

Technical support is 8/10.

Initial Setup

Initial setup was straightforward.

Implementation Team

We implemented QlikView independently without difficulty. We needed support for installing Qlik Server.

ROI

We are at a too-early stage of implementation to evaluate this, but we anticipate difficulties in expanding its use due to the high cost of licenses.

Other Solutions Considered

We use QlikView and Oracle BI, but the productivity-to-cost ratio is much higher with QlikView.

Other Advice

You need to assess carefully the choice between QlikView and Qlik Sense. We do not understand too well the coexistence of two products with the same function.


Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
IT Admin at a logistics company with 501-1,000 employees
Real User
Preparing daily reports without requiring additional manpower was the biggest benefit.

What is most valuable?

We appreciate the different methods how data can be provided to a developer, designer and end users. Develop new reports from production databases to final reports without additional tools and
the high-performance loading data from database without any performance issues on the database environment. The loading performance of QlikView data container.

How has it helped my organization?

With the solutions of QlikTech, we are able to provide management with requested reports with proven data within a short time.

We can scale the user properly for the report environment in different and multiple ways.

Preparing actual daily reports without requiring additional manpower was the biggest benefit for our company.

What needs improvement?

We would like to provide our customers with reports in PDF or other popular formats that are not included in the publisher; additional licenses are required for the print and PDF tool. From my point of view, a reduced functionality for this should be included with Enterprise Server Edition or Publisher.

But so far, every new version includes new benefits for us.

For how long have I used the solution?

We have used QlikView since 2010. That includes one year of testing QlikView Personal Edition for development and comparing the functions with our previous BI solution. We started using QlikView in production at the end of 2011.

What was my experience with deployment of the solution?

We implemented different versions of QlikView within a few years, starting with version 8, Small Business Edition to Enterprise. We also moved to new hardware environment, but never had any issues. All versions we had in production were always stable. At the same time, we never used the first release of a new version for the server environment; the QlikView application has always been tested. Developing and deploying new reports are always tested in test environment before we publish. Scalability of reports should be considered separately.

How are customer service and technical support?

Issues with the software itself are really rare; we just needed help implementing license keys after installation because direct internet access on the server was not available one time during setup. We always get help within a short / acceptable time. Normally, we just use the big user community for further help or information.

Which solution did I use previously and why did I switch?

Before 2012, we used SAS and Crystal Reports for reporting and BI. When we started looking for other solution, we evaluated the new version of Crystal Reports, but there was no comparable alternative to QlikView.

How was the initial setup?

A comprehensive concept for the initial setup is very important; there are various ways to implement the server infrastructure. If the concept was done properly, implementation might be complex but not difficult. We never had to contact QlikTech for additional support.

The documentation itself, user forum and several tech days was always helpful to start.

What about the implementation team?

We implemented the whole environment without any additional support. Before we start working with the product, we organized in-house training from a vendor partner for developers and report designers based on our requirements.

My advice for implementation is to create a team made up of developers and IT department staff to set up the concept for test and production environments.

Training for IT and developers is available from the vendor, or if you organize in-house training from the vendor partner. Provisioning of data should be the responsibility of the IT department. You can also plan to have the vendor or vendor partner implement the product.

What was our ROI?

The vendor offers multiple possibilities for getting started with QlikView. It also depends upon how many reports you need for initial go-live. Starting with the Small Business Edition or Enterprise depends on the company size and the number of users who will work with QlikView.

What other advice do I have?

The only important advice is to take enough time for the concept of the future environment.

That will make it easy to implement all needed add-ons with future changes.

Follow the vendor’s suggestions for scale responsibilities (IT, developer, designer and end user).

The Qlik user forum will be always helpful to find a solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Information Publishing Portfolio Manager at a comms service provider
Vendor
My most valuable asset in QlikView is the ease with which any datasource can be integrated into the QlikView model for reporting.

What is most valuable?

The traditional BI tools are extremely limiting in the fact that they require very strict controls on the sources of data. This is understandable in very large corporates, but in a small- to medium-size business, where most supporting data sources are nothing more than an Excel spreadsheet, this is a pain. Therefore, my most valuable asset in QlikView is the ease with which any datasource can be integrated into the QlikView model for reporting.

How has it helped my organization?

The models created by QlikView have put critical information at the fingertips of management for decision-making processes. Our warehouse and distribution managers now have a view of the movement of stock, fulfilment of orders and can plan for demand more proactively. We produce our management sales dashboards daily and use the tool to integrate proof of delivery documents with sales orders.

What needs improvement?

I have several lower-level users who don’t need full functionality of the tool, but do need to access more than one model. In this regard, the licencing structure is limiting and costly for a user who is not using the analytical aspects of the tool. QlikView only offers full-user CALs (expensive) and document CALs (less expensive), but those licences only allow the user to access one model.

For how long have I used the solution?

The business has been using this product for four years.

What was my experience with deployment of the solution?

I did not encounter any deployment, stability or scalability issues.

How are customer service and technical support?

Our implementation provider is very capable, but it is important to partner with a vendor who has industry, regional and technological capabilities, as this cuts down the time to develop customised requirements. Also, it is not necessary to limit yourself to one vendor and lots of freelancers are cost effective for specific requirements.

Which solution did I use previously and why did I switch?

I looked at IBM Cognos, SAP BusinessObjects, and MicroStrategy. The main draw cards to QlikView was the cost and flexibility.

How was the initial setup?

Initial setup was straightforward.

What about the implementation team?

A team from the implementation provider did the installation and it was simple.

What was our ROI?

Our ROI is the ability to immediately take catalytic interventions with information at hand, implementing immediate savings from lost business and being able to put products to market more effectively.

In-depth analysis on the user roles using the tool should be done prior to implementation as non-managerial staff could probably use a shared licence scenario enabling lower licence count.

What other advice do I have?

If possible, a site visit to other consumers of the tool often sheds a lot of light on work that can be done before implementation to overcome unnecessary problems and delays. For example, properly mapping financial processes, documenting and getting them signed off before a QlikView model is developed will save time and money in rework after the fact. Also forming a network of other users who are not related to the vendor is very valuable in getting unbiased advice.

It is quite versatile and reasonably cost effective.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Developer with 501-1,000 employees
Vendor
The Set Analysis Wizard allows us to create subsets in a smart, fast way. It allows you to control the results, taking into consideration user clicking and selecting data.

What is most valuable?

  • ETL functionality is hugely important, as data rarely are provided smooth and clean, even when the assumption is it has been cleaned beforehand. Plus, usually in BI, we need to create custom groupings, and being able to do that in script ad-hoc is very helpful
  • Scripting for loads, with lots of functions, and insert script possibilities all provide extremely good flexibility for development.- Overall flexibility and ease of development is great for ad-hoc quick fixes, quick workarounds, which happen in BI
  • Set-analysis function, unique for QV, is an awesome way to create subsets, literally under any chart/table/text box needed in a smart, fast way (replaces long expressions such as “if...then...“). It also allows you to control results, taking into consideration user clicking and selecting data.
  • Associative model is super handy to just take an overview of data quality through visual associations (power of grey).
  • Data governance is an extremely usable feature; there is no need for BI to build its own app, and it helps with licence monitoring.

How has it helped my organization?

With QV, literally all departments across the company have started “owning” data in terms of getting hands on data, knowledge about data, how it is built up, and the ability to slice and dice, add, expand, or decrease the size or granularity of their own reports.

This in turn has in general decreased the “fear” of touching applications on computer. With backups maintained by IT, people are given more freedom to try and change applications themselves.

What needs improvement?

Regex. Cleaning out data during script regex could be really handy.

Otherwise, I am having a hard time thinking of any other areas with room for improvement.

For how long have I used the solution?

I have used QlikView 9 for two years, I am trained and certified on
QlikView 11, and I have used QlikView 12 for half a year.

What was my experience with deployment of the solution?

I have not encountered any deployment, stability or scalability issues.

How are customer service and technical support?

I have not had direct contact. Currently (with Qlik Sense), I am working with Qlik local partners, not directly.

Which solution did I use previously and why did I switch?

Before QlikView, Excel was used across the company. At the same time, we had SAS Web Reporting Studio provided by my company’s headquarters, which was very far from even being considered to be used for anything beyond just comparing total sales numbers if the QlikView reports were in line.

How was the initial setup?

I remember it being set up with the first production app running in three days. So, initial setup was straightforward.

What about the implementation team?

Implementation was done in-house.

Which other solutions did I evaluate?

During the selection of the local BI tool, the choice was between IBM Cognos and QlikView. We were naturally showcasing to management how easy it is to use the UI, and the latter one was chosen.

What other advice do I have?

I think it is the best BI product out there, competing only with its own “brother” Qlik Sense. (While the latter is not that mature yet, it is definitely growing in power extremely fast.)

QlikView is a good choice!

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Partner at a consultancy with 51-200 employees
Consultant
We used MS Analysis Server & MS Reporting Services for some years and compared to Qlik products, it was inflexible, old-fashioned and slow.

What is most valuable?

Completeness in functionality and user friendliness are the product’s most valuable features.

How has it helped my organization?

Efficient reporting and analysis saves time and improves business insight.

What needs improvement?

I would like to see a modernised user interface.

For how long have I used the solution?

I have used QlikView for seven years.

What was my experience with deployment of the solution?

I did not encounter any issues with deployment, stability or scalability. It's a well-proven mature product.

How are customer service and technical support?

I rate technical support 10/10.

Which solution did I use previously and why did I switch?

We used MS Analysis Server & MS Reporting Services for some years and compared to Qlik products, it was inflexible, old-fashioned and slow.

How was the initial setup?

Initial setup was straightforward as an all-in-one product, compared to Microsoft’s product stack.

What about the implementation team?

An in-house team implemented it.

What was our ROI?

In the starter pack, you get a lot and the ROI is definitely less than a year.

What other advice do I have?

I would recommend it to anyone who is looking for an online reporting and analysis BI product. Not to use only as a report generator; it's far more useful than that.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik implementation partner.
ITCS user
Owner at a tech services company with 51-200 employees
Consultant
It allows you to set up a dashboard with pinpoint accuracy. The script engine for loading data needs a total overhaul.

Valuable Features:

I do like the richness of details you can set up. It really allows you to set up a dashboard with pinpoint accuracy.

Improvements to My Organization:

It was the first BI tool on the customer's site. It requires quite high skills at the entry level, so it was unused until I helped them with the initial steps.

Room for Improvement:

The script engine for loading data needs a total overhaul. It is hard to use and counter-intuitive. It also blocks less-skilled users at the very beginning.

Use of Solution:

I’ve used it for about a year with one of my customers.

Scalability Issues:

In general, the solution is a little problematic in terms of scalability, as everything is stored in RAM. For more complicated analysis for many users, the memory consumption is very high and requires a lot of investment in hardware.

Implementation Team:

It was already deployed when I start using it. My customer said they relied heavily on vendor.

Other Advice:

Be very careful when scoping the market. It is a good tool, but quite heavy on skills and hardware requirements.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
BI Expert at a tech services company with 201-500 employees
Real User
It instantly loads huge amounts of data and immediately displays the relationship - both correlation and absence of correlation - between the data.

Valuable Features

  • Instant loading of huge amount of data and immediate display of relationship (both correlation and absence of correlation) between data
  • RAD development methodology adoption for QlikView projects
  • Set analysis function for simultaneous display of alternative aggregation sets

Room for Improvement

The backend (scripting) needs improvement to be more like a real ETL BI tool. The script editor is, in my opinion, no more than a basic scripting editor with too-limited debugging features.

Use of Solution

I have been using it for five years (still today).

Deployment Issues

I have not had any issues with deployment, stability or scalability.

Customer Service and Technical Support

Technical support is very good.

Initial Setup

The initial setup was straightforward.

Implementation Team

We usually implement in-house, but we also rely on external resources.

Other Solutions Considered

We are currently using two different BI solutions for our customers: Business Objects and QlikView.

QlikView lets our customers develop data analysis projects independently with a little initial training.

Other Advice

Only a recommendation in order to assure the growth of a project with minimum impact on the previous deployed portion: As much as possible, try to solve data complexity on the backend side (where the logic is easily documentable), rather than in the front-end using only analytic functions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior BI Consultant (Qlikview) at a tech services company with 51-200 employees
Consultant
KPI uniformity across all departments has improved problem-solving efficiency.

What is most valuable?

  • The way data is loaded, transformed and stored in one single file with a high compression rate
  • The development flexibility allowing almost any type of relationship between data from disparate sources

How has it helped my organization?

Uniformization of KPIs across all departments brings efficacy and effectiveness to coworkers in problem solving.

What needs improvement?

Performance at front-end level could improve but usually there is a workaround - by reducing application size, splitting applications or the way the UI is presented - without affecting user experience.

For how long have I used the solution?

I have used it for two years.

What do I think about the stability of the solution?

There can be issues in terms of stability during usage peeks. In these situations, the server can experience short down times. Again, many of these situations can be prevented by using the best development methodologies.

How are customer service and technical support?

Technical support is very good. They are always available on providing guidelines.

Which solution did I use previously and why did I switch?

There are other data visualization tools similar to QlikView. Spotfire, for example, has incredible UI possibilities, but I think QlikView is very ahead in the competition in terms of solution flexibility.

How was the initial setup?

QlikView setup is very straightforward, only requiring server parameterization in terms of ODBC and the QlikView Server. It is not complex when compared to similar products.

What about the implementation team?

It was implemented by an in-house team; some persons on the team had previous experience with QlikView. The learning curve is very quick, but the best practices provided by Qlik must be followed from the beginning of implementing the QlikView architecture.

What other advice do I have?

Due to the quick development of QlikView applications, best practices cannot be disregarded. (For example, load only fields/tables that users need to be available in the application’s layout. When the number of applications starts to increase, this can seriously affect user.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
CJ
Decision Support Manager at a university with 1,001-5,000 employees
Real User
It allows us to create easily accessible what-if scenarios for decision making.

What is most valuable?

I use QlikView to combine data from different sources in the absence of an EDW and build our analytical dashboards.

How has it helped my organization?

It allowed us to improve our analytical abilities, and KPI and data presentation, in addition to creating easily accessible what-if scenarios for decision making.

What needs improvement?

The security features in QlikView are not yet mature: very complex to define permissions in a dashboard (based on data/sheets).

For how long have I used the solution?

We have been using QlikView for the past five years.

What was my experience with deployment of the solution?

QlikView relies heavily on memory. It requires good servers and continuous upgrades and maintenance for sustaining good performance.

How are customer service and technical support?

Technical support is good.

Which solution did I use previously and why did I switch?

Most solutions like SAS, Tableau and others require a fully-fledged data warehouse (EDW), and IT support and intervention at all times for creating dashboards. QlikView is flexible and allows users to create their own reports in a relatively short time.

How was the initial setup?

The initial setup was supported by the company and was not very complex.

What's my experience with pricing, setup cost, and licensing?

Licensing in QlikView is a bit expensive.

What other advice do I have?

I would recommend the QlikView tool for its flexibility and good data visualization and presentation.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user363234
Managing Partner at PBS
Vendor
It has an associative data exploration feature and provides good performance with one hundred million lines of data.

What is most valuable?

Data exploration and in-memory capabilities: It has an associative data exploration feature and can handle one hundred million lines of data and provide good performance.

How has it helped my organization?

N/A. We are consultants.

What needs improvement?

Qlik has launched another product, Qlik Sense to improve ease of use for the end user. The product lacks PDF exporting, mapping – which costs extra - and reporting features. Also, it turns the data into QVD format that is not accessible by other software.

For how long have I used the solution?

We have been using QlikView for five years. We have been a partner for five years as well. We have successfully completed seven QlikView projects.

What was my experience with deployment of the solution?

I did not encounter any issues with deployment, stability or scalability. It is quite easy to install, configure and deploy.

How are customer service and technical support?

QlikView has a very good developer community where you can find support from the other developers.

Which solution did I use previously and why did I switch?

We usually position this product for departmental and fast-win solutions. When you’re an expert in this product, it’s quite easy to develop well-functioning and complex dashboards.

How was the initial setup?

Initial setup was quite easy.

What's my experience with pricing, setup cost, and licensing?

QlikView has CAL and Document CAL licencing. It’s quite cost-effective when lots of end users use several reports like once a month.

What other advice do I have?

If you plan to develop dashboards and want the end users to further develop the dashboards, it requires some IT skills. If the end users should develop their own reports, Qlik Sense should be chosen.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik partner.
ITCS user
Consultant at a tech vendor with 501-1,000 employees
Vendor
The in-memory associative engine is powerful. It provides quick answers when a user is exploring their data.

What is most valuable?

Qlik's data modelling is very powerful and allows for easy integration of data from multiple sources. The in-memory associative engine is very powerful and provides quick answers to questions that arise when a user is exploring their data.

How has it helped my organization?

QlikView provides rapid insight that takes significantly longer to reach when using some other traditional BI tools.

What needs improvement?

I would like to see the desktop user interface updated. Some of the dialogs in the product look quite dated. I would also like to see the responsive UI design features from Qlik Sense make their way into QlikView.

On the analysis side, I would like to see tighter integration with R, or perhaps some built-in machine learning algorithms.

I would also like to see Qlik products made available on other platforms such as Linux and OS X.

For how long have I used the solution?

I have used this solution for 8+ years.

What was my experience with deployment of the solution?

QlikView is an in-memory product, so large dashboards place a significant load on a server's memory. This needs to be carefully considered when sizing your environment.

Which solution did I use previously and why did I switch?

I have used a number of competing products such as Cognos, Tableau, Power BI and SAP BusinessObjects.

QlikView development projects are rapid and the product itself is very flexible and reliable.

How was the initial setup?

Initial setup of QlikView tends to be fairly straightforward, though when setting up additional features such as clustering and publisher features, this can get a little complex.

What about the implementation team?

I have implemented the solution both with vendor teams and in-house. In a previous job, I worked with a vendor team, and have worked for a partner and provided implementation support for clients.

I would advise new Qlik customers to seek out a reliable Qlik partner to help with implementation.

What other advice do I have?

I would advise you to seek out a local Qlik partner. They will be able to support your training and consulting needs and provide guidance regarding best practice for your implementation.

QlikView has some superb, unique features but the desktop edition suffers from having a rather tired user interface. Default chart settings can often result in unattractive dashboards, which require significant adjustment in order to conform to best practice. These UI shortcomings have however been addressed in Qlik Sense.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik partner.
it_user416430
Business Intelligence Consultant at a computer software company with 51-200 employees
Vendor
After deployment, clients are able to explore and maintain it without any further charges for the software itself. It requires experienced users to help with development.

Valuable Features

The data model and the visualization are the most valuable features of the product. The data model helps my organization to recognize and identify the problem of our clients’ data. The visualization helps us to deploy an easy-to-understand solution to the client and they are able to explore the data by themselves.

Improvements to My Organization

We actually help the client to deploy and design the solution. It helps us to understand their problems better and provide a more intuitive solution. Plus, after the deployment, the client is able to explore and maintain the application without any further charges on the software itself.

Room for Improvement

The visualization charts. I believe they are working on that because Qlik Sense has released a few versions in which the charts are a lot better than QlikView.

And the interface. QlikView is mainly defined as a guided analytics tool, which requires experienced users to help with the development. In the future, it should move forward on self-service (the core value of Qlik Sense), which is the trend on the business intelligence development. So I think they will have some big changes coming.

Use of Solution

I have been using for about one year.

Deployment Issues

I haven’t come across any fatal issues with deployment, stability or scalability so far. However, as the data volume increased, the skills of optimizing the tool need to be more advanced.

Customer Service and Technical Support

Technical support are quite helpful. We are a Qlik partner and they are willing to help out with issues. Sometimes, they ask for feedback when a new version is released.

Initial Setup

It’s straightforward and very detailed documentation is available; just follow the instruction prompts when you install the software.

Other Solutions Considered

I also tried Tableau. I believe they are targeting a different market, if you compare Tableau with QlikView. The better comparison will be Tableau to Qlik Sense, which is beyond the scope of this review. The reason we selected QlikView is its relatively comprehensive functionality.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik Partner in Hong Kong.
it_user421155
Solution Engineer - QlikView/Qlik Sense at a consultancy with 10,001+ employees
Consultant
It can connect to multiple sources of data without needing ETL prior to load.

What is most valuable?

  • Connect to multiple sources of data without needing ETL prior to load
  • Ability to create complex data joins within the script
  • ETL features
  • Ability to do complex customization in the design and data representation (set analysis)
  • Associative search capabilities

What needs improvement?

  • Scalability
  • Live connections
  • Responsive design

For how long have I used the solution?

I have been using QlikView for four years.

How are customer service and technical support?

Customer service and technical support are very good.

Which solution did I use previously and why did I switch?

Among Tableau, QlikView, and Qlik Sense, I prefer QlikView, due to its higher customization capabilities, its associative nature, and its ETL features.

How was the initial setup?

Initial setup simplicity or complexity depends on the project and the systems already in place. As for the tool itself, initial setup is straightforward.

What about the implementation team?

I have implemented it in-house and with a vendor team. Business needs need to be fully understood and documented. Most of the issues have always been data related. The development team and the business HAVE to get a full understanding of what the data is, where it is stored, and how it is stored. BUSINESS RULES and a DATA DICTIONARY are a must.

What other advice do I have?

Standardization in design/development is crucial. FULL communication and documentation with EVERYONE is needed. I don’t know how much time has been lost or efforts duplicated because of a lack of all this.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company has an alliance with the vendor.
ITCS user
Senior Business Analyst at a logistics company with 1,001-5,000 employees
Vendor
It runs in-memory so you can increase the speed by increasing RAM, depending on your budget.

What is most valuable?

  • Intuitive data insights and standard reporting.
  • It runs in-memory so you can increase the speed by increasing RAM, depending on your budget.
  • It has its own ETL tool, QlikView Connector.

How has it helped my organization?

It gives intuitive data insights to improve and optimize our global supply chain (help drive and build strategy to improve on-time delivery, reduce quality and damage returns, etc.), with a few simple clicks to drill down to the details (down to the SKU level and call centre conversation details with customers). The dashboard gives management a holistic picture on our important KPIs.

What needs improvement?

  • Enhance predictive analytics and big data; this is the future trend.
  • Simpler, cleaner charts and visualization (easier user acceptance)
  • Formatting and repositioning the menu/charts takes a bit long. It does not have drag-and-drop capability like Tableau does.

For how long have I used the solution?

I have been using QlikView for 2.5 years.

What was my experience with deployment of the solution?

There’s no version control, which means you can't roll back to earlier versions once overwritten/published.

How are customer service and technical support?

I rate technical support 6/10.

Which solution did I use previously and why did I switch?

I also evaluated MS BI and tableau. Compared with MS BI, I find Tableau and QlikView have stronger visualization; intuitive data insights; less development lead time - MS BI requires creating OLAP cubes, which takes more time; clearer and simpler charts; and intuitive data mapping/insights.

How was the initial setup?

Initial setup was straightforward.

What about the implementation team?

We implemented it in-house. QlikView is running in memory, so it depends on your organization to achieve the balance between cost of server RAM and performance. Besides, the data quality and accuracy is very important, no matter what powerful visualization tools are used.

What was our ROI?

Tableau seems to have easier user acceptance than QlikView because of the simpler charts and big data integration, increasing the possibility of helping an organization transform from reactive analysis to predictive analysis.

What's my experience with pricing, setup cost, and licensing?

Server versions are not cheap and pretty similar for both Tableau and QlikView in terms of price. I don't see a big difference; it really depends on your organization's need.

What other advice do I have?

If you have more developers/technical people and want to do more standard reporting without Hadoop, go for QlikView; if you have more business users with some SQL knowledge and would like to do predictive analytics, and integration with big data platform Hadoop, go for Tableau.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user401796
IT Manager at a consumer goods company with 501-1,000 employees
Vendor
It reduced the number of reports users construct manually.

What is most valuable?

It allows our company to view all of our data in a single solution. It is easy to use, even for novice users.

How has it helped my organization?

The product has reduced the number of reports that were previously constructed manually by users. It also allowed us to prepare a single report using a common data source for all users.

What needs improvement?

In QlikView 11, there is a password for the section of code, but there is no user management with a password that allows access to data when opening the file.

I would like the data loading and programming to be made easier.

For how long have I used the solution?

I have been using it for five years. Currently we're using v11.20 and testing v12.

What was my experience with deployment of the solution?

The product installed at the time did not present operational problems or stability issues.

How are customer service and technical support?

The consultant company that sold us the product provides us with follow-up service. At the moment, we are satisfied.

Which solution did I use previously and why did I switch?

I used BOARD at another company. I have found QlikView to be better.

How was the initial setup?

The initial setup was very simple and in a few days, we were able to begin operating with the data available.

What about the implementation team?

We developed the solution partly in-house and partly with the supplier. We took responsibility for the preparation of the database, retrieving information from the management system and preparing it in a suitable format, leaving the supplier responsible for the implementation of the loading from this database and reporting.

What's my experience with pricing, setup cost, and licensing?

We are happy with the product. With regard to the license fee, for a customer, it is always better to pay less.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user167547
COO at a consumer goods company with 1,001-5,000 employees
Vendor
It links different data sources to the same visualization.

Valuable Features:

QlikView Desktop Enterprise allows us to build dashboard visualizations in a fashionable way and allows us to make quick business decisions all over the enterprise.

Improvements to My Organization:

The improvement was much more related to be able to link different data sources to the same visualization. Now users have access to a one-stop shop for their data queries.

Room for Improvement:

I believe that improved analysis prediction capability would be more than welcome in QlikView. If we could simulate scenarios in a more intuitive way that would be a nice-to-have feature.

Besides the fact it’s quite a useful tool for data visualization, the final user interface is not that intuitive. That might be the idea with Qlik Sense, which we haven’t had an opportunity to experience yet.

Implementation Team:

Prepare your data warehouse platform. The more time you spend on DW development, the more your users will be able to take advantage of the data analysis.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Manager Analytics at a financial services firm with 1,001-5,000 employees
Vendor
Our clients can access their business metrics in an interactive form on their smartphones. Interactivity options are limited and modelling options are not available.

Valuable Features:

Data integration and visual drill-downs are excellent.

Improvements to My Organization:

I work for a consultancy and develop projects for clients. Our clients have definitely got benefits with the use of QlikView with accessibility of their business metrics in an interactive form on their smartphones. Also, QlikView can compress and store data in its own format, which makes it faster after data loading.

Room for Improvement:

  • Version changes should be made fully compatible with older versions.
  • Advanced analytic capabilities of model building using regression or time-series analysis should also be added in the product.

Other Advice:

Client requirements should be clearly understood and limitations of the product should be communicated to clients before making any commitments. Often projects are jeopardized due to poor communication and unclear expectations.

There are two reasons for my rating. First, the interactivity options are limited and, second, modelling options are not available. Also, we faced challenges with version changes and in integrating it with geographical information systems.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultor QlikView at a tech services company with 501-1,000 employees
Consultant
Before we started using it, it took four steps to load and clean our data. Now, we just connect the database, clean it and show the information.

Valuable Features

Fast development, support for QVD format files, and business discovery are the most valuable features of this product to me.

Improvements to My Organization

Before we started using QlikView, we needed to put or clean our data in four steps. Now, we just connect the database, clean it and show the information.

Room for Improvement

In the next version/release, I'd like to see mashup possibilities and real-time connections.

Use of Solution

I have used QlikView for five years, and Qlik Sense for two years.

Deployment Issues

I encounter deployment issues but it depends on how you develop it and for what are you using this tool.

Customer Service and Technical Support

Technical support provides high-level service.

Initial Setup

Initial setup is…

Valuable Features

Fast development, support for QVD format files, and business discovery are the most valuable features of this product to me.

Improvements to My Organization

Before we started using QlikView, we needed to put or clean our data in four steps. Now, we just connect the database, clean it and show the information.

Room for Improvement

In the next version/release, I'd like to see mashup possibilities and real-time connections.

Use of Solution

I have used QlikView for five years, and Qlik Sense for two years.

Deployment Issues

I encounter deployment issues but it depends on how you develop it and for what are you using this tool.

Customer Service and Technical Support

Technical support provides high-level service.

Initial Setup

Initial setup is straightforward; you just install and use.

Implementation Team

When implementing through a vendor, be careful with your environment.

ROI

This product pays for itself fast.

Other Advice

Try it. You can use just one tool for most of your connections. It's easy to maintain and you can focus on data and decisions.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a QlikView partner.
it_user213993
Analyst Control and Monitoring at a energy/utilities company with 501-1,000 employees
Vendor
We now have all of the company's important information in one tool, so it's easier to analyze it.

Valuable Features

I think the most valuable feature is the possibility of working with all types of data and sources.

Improvements to My Organization

Now, we have all the company´s important information gathered in one tool, so it´s easier to analyze it.

Room for Improvement

QlikView is really easy to use and it can help you manage different kinds of data, but licenses are expensive.

Use of Solution

I’ve been using QlikView since 2011.

Deployment Issues

We did not really encounter any deployment, stability or scalability issues.

Customer Service and Technical Support

We have a good support here in Ecuador. In fact, we have an SLA with Grupo Novatech with specific times for technical support.

Initial Setup

The initial setup was straightforward. There was a small amount of data with few KPIs.

Implementation Team

We have an in-house team. They implement some dashboards. If there was a complication, we called Novatech.

Pricing, Setup Cost and Licensing

I think licences are expensive. I think QlikTech should work to develop a cheaper licence, only to visualize data through the internet access server.

Other Solutions Considered

I have not evaluated any different solution. I´ve always worked with QlikView since I´ve been at my company.

Other Advice

I think QlikView is a good tool if your company is not big, because of the licence cost. If your company is big, it’s a good idea to have an in-house team for new implementation or for little changes, because technical support could be expensive.

I think QlikTech is working in the right path to improve the usability of QlikView with the new tool Qlik Sense.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user159192
IT Admin at a energy/utilities company with 1,001-5,000 employees
Vendor
It provides an easy way to grant access to all data or just bits of it to specific users.

Valuable Features:

The best features of QlikView are:

  • The fast and easy process of extracting data from multiple sources (DB), although having duplicate data in the source files creates a mess.
  • The intuitive way of creating dashboards for finance, sales, BPM, etc.
  • The display and drill-down access to detailed information, graphic interfaces are easy to create and dynamic using just one pivot table.
  • The easy way to grant access to all the data or just bits of it to specific users.
  • The capability of QV to handle .pdf files.

Improvements to My Organization:

As an example, today we have our budget information from different areas in one summary page. Numbers are updated fast and easy in the web browser. This has given crystal clear info for all the users that have access to the model. Hard data and dynamic graphs give a clearer and accurate view of the data. Filtering saves a lot of time when doing presentations to the top executives of the company; any question is answered in real time with just a few clicks.

Room for Improvement:

I would like to perhaps be able to have preloaded and editable examples of models created by QV experts that can be customized for our specific needs, instead of starting from scratch anything we need to work on.

I work an electric utility in Mexico, therefore we build QV models and dashboards specific to our industry (electricity, gas, nuclear generation, asset management, executive reporting and such). 

Right now, we have to build our models from scratch, if we could have access to prebuilt models for our specific industry and line of business it would be very useful and time saving. 

Other Advice:

It’s important to understand that the quality of the final data will have a direct relationship to the source of information. You can really apply here the phrase "Garbage in-Garbage out". Because once QV is up and running, almost everyone will turn to the dashboards as THE source of information, it’s imperative to be sure the source of data is flawless.

It’s a great BI tool to convert raw data coming from several different sources into a dashboard full of in-depth knowledge, to do proper information analysis and make accurate decisions for the company.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Information System & Business Enterprise Manager at a government with 1,001-5,000 employees
Vendor
It is easy for developers and for end users. The management console could have better interfaces for managing security.

What is most valuable?

Usability, usability, usability: It is easy for developers and for end users.

How has it helped my organization?

We have cut Fire Department 911 response time 8-30 seconds.

We have improved the timeliness, accuracy, and consistency of reporting.

Unmetered water reports (e.g. fire hydrants, FDCs in commercial buildings)

Wage verification requests

Performance metrics

We have improved processes and increased compliance of firefighter training and certification, ensuring that firefighters are properly trained (“a trained firefighter is an effective firefighter”), expensive training courses no longer have empty seats, and we have improved our performance on training/certification audits from our regulatory agency.

We have engaged line managers on tracking and monitoring of program and operational budgets, leading to better oversight of the taxpayer dollar.

What needs improvement?

The QlikView management console could have better interfaces for managing security. Right now, it is hard to tell “who has access to exactly what apps?”

Better out-of-the box governance features, to allow analysis of application architecture, optimization of scripts, identification of unused fields/data.

Current GIS interfaces (e.g. with ESRI) are through partners, and are acceptable, but could be easier to implement, more streamlined interface between the two.

For how long have I used the solution?

I have used this solution since 2008.

What was my experience with deployment of the solution?

No issues at all. This application requires very little care and feeding. Cannot speak to big data scaling, our largest data sets are in the 1TB range — but no problems noted at that level.

How are customer service and technical support?

Customer and technical support are fine. Account manager deals well with the added layers of demand that come from being a government client — purchasing is always more complicated.

Which solution did I use previously and why did I switch?

Like everyone, we used Excel and Access. We tried using the enterprise MicroStrategy and both developers and users rejected it as too much effort, not intuitive compared to QlikView.

How was the initial setup?

Technically, initial setup was very simple. The hardest part was getting visualization requirements form unsophisticated users who were not used to any sort of reporting on their processes.

What about the implementation team?

We did it in-house, with one week of one vendor person assisting. (The four apps he helped us put together, we ended up redesigning altogether once we had a chance to use them and redefined requirements.)

Advice: Keep it simple. We know of similar organizations that used third-party implements, who created apps that were complicated to support and use, and consequently those implementations were not entirely successful. In at least once case, they abandoned the product (and haven’t done anything else that I’m aware of).

What was our ROI?

Qlik has a reputation for being expensive, but our TCO - compared to two other BI products in our organization (MicroStrategy and Cognos) is way, way cheaper. We didn’t have to pay for consultants or any professional services. The more we let our business managers design and develop their apps, the happier they are.

What other advice do I have?

Keep it simple, involve the team (prototype with them - don’t throw a fancy app over the wall at the end users and expect them to actually engage), do POCs before you decide which BI system you will adopt.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Bernard Barnard
Head of Qlikview IT at a financial services firm with 10,001+ employees
Real User
The business is delighted with its self-service capabilities, without the usual restrictions working through traditional IT channels.

What is most valuable?

QlikView’s Associative Data Model allow business users to easily create data models.

QlikView’s in-memory technology offers lightning-fast drill-down and drill-through capabilities.

The ability to apply row-based security provides the flexibility to deploy a single application and restrict access to sensitive data according to role.

How has it helped my organization?

We are busy rolling out QlikView as a self-service BI tool. The business is delighted with the capabilities they have without the usual restrictions they encountered working through the traditional IT channels.

What needs improvement?

  • Robust Version Control integration, limited in current versions
  • Automated deployment between DEV/UAT/PROD environments, currently these are manual file-based operations
  • More descriptive system metrics and lower-level diagnostic and performance metrics at the application level

What was my experience with deployment of the solution?

Deployment is easy and straightforward, even for non-technical resources.

What do I think about the stability of the solution?

Stability is largely linked to the infrastructure and requirements. QlikView SA has provided extensive guidance on deploying suitable hardware to support our environment.

What do I think about the scalability of the solution?

Scalability depends on the environment and requirements. If you have large data sets, due to the in-memory nature of QlikView, the hardware needs to support your requirements.

How are customer service and technical support?

I rate technical support 10/10, excellent. Qlik as well as our local QlikView Partner, QlikView SA, provides extremely good service and support.

There is also an extremely large and active online community.

Which solution did I use previously and why did I switch?

We evaluated IBM Cognos and SAP BusinessObjects. We chose QlikView because of its online community, extensibility and support, and large demand from business.

How was the initial setup?

Initial setup was straightforward, but consideration needs to be taken when procuring the hardware.

What about the implementation team?

Implementation was a combination of in-house and vendor. Take the time to understand the underlying architecture and deployment setup to later be able to troubleshoot the environments.

What was our ROI?

We realised instant value through data discovery not previously possible with traditional BI.

Consolidating six disparate instances into a single group instance has improved our ROI immensely.

What's my experience with pricing, setup cost, and licensing?

Care should be taken to purchase the right type of licensing blend for the environment.

Take time to understand the different license types, the requirements from users, usage model, etc., before deciding on licenses.

Potentially get some demo licenses before purchasing.

What other advice do I have?

Happy Qlikking!

Take the time to understand the data, and develop solid data models. This will ensure good performance and a great user experience.

Just because QlikView can do it, doesn’t mean it should. (There is still a place for traditional BI, databases and ETL/ELT.)

Develop fit-for-purpose applications.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Sales Engineer at a tech consulting company with 11-50 employees
Real User
It provided previously unknown intelligence. Cost and performance issues were too great to overcome.

What is most valuable?

I would say the most valuable part was the ease of use.

How has it helped my organization?

This product gave us intelligence on our business which was previously unknown.

What needs improvement?

I would like to see the price reduced and the speed to be much, much better.

For how long have I used the solution?

I used this solution for approximately two years.

What was my experience with deployment of the solution?

I did not encounter any deployment, stability or scalability issues.

Which solution did I use previously and why did I switch?

This product was in place when I joined the company. I did not take part in the decision of this solution.

What about the implementation team?

This was an in-house implementation. We had the technical resources available to install it.

What was our ROI?

Although we were able to gain insight into our organization, the pricing and performance of the system were too great to overcome.

What other advice do I have?

Since we stopped using it, there might have been some improvements to the speed of the reports and also to the pricing structure. At the time I was using this software, there were several comparable solutions at a fraction of the cost. The other solutions also performed better with less resources.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user140223
Marketing Intelligence Analyst at a financial services firm with 501-1,000 employees
Vendor
Their proprietary SET analysis allows calculations to be based on calculated dimensions, aggregations, and other logic against real-time selection of data. Licensing is cumbersome and expensive.

What is most valuable?

The in-memory technology allows you to easily manipulate and analyze vast amounts of data with simple clicks. It allows for real-time analysis of data via visual representations, as well as data tables. It supports using variables in calculations, as well as their proprietary SET analysis, which allows for calculations based on calculated dimensions, aggregations, and other logic against real-time selection of data.

It is very flexible in terms of calculations and presentation of values and data. It makes very quick reporting and data analysis possible.

How has it helped my organization?

This product has allowed us to create several applications and dashboards for use by management and different business units to conduct self-service analysis, as well as built-in intelligence. This accelerates business decision-making. It avoids the lengthy delays involved in requesting the information from IT or having to deal with the disconnect between technology and the business side, both from an objective point of view, but also from the customer view.

It also enables management and the end user to change the criteria of the reports and data without having to go back to IT with changes. In other words, dynamic reporting.

What needs improvement?

There definitely needs to be an update in the number of chart types available and the options within each chart. There are various charts that could use more customizable options, as well as certain charts that are missing such as waterfall charts, histograms, etc.

One glaring omission is the lack of mapping technology in QlikView. Although they do offer solutions through third-party add-ons, other similar providers have this as a default feature in the app. I think currently, mapping technology should be standard with these applications given the competition and the capabilities it brings. It seems that because of their third-party developer relationships, they are holding back on adding features to the application, which would put those developers out of business.

The licensing scheme leaves a lot of room for improvement. I believe it is cumbersome and expensive to maintain. In order for a user to view a published application, they need to have a viewer license (approx. $350 the last I remember). However, if they need to view multiple applications, they need a viewer license per application. $350 X # of applications they need to view per user. This will get very expensive if a lot of users need to view the application. There are application licenses, there are named user licenses, there are session licenses, and developer licenses. There are way too many licenses of varying costs, none of which are very economical in my opinion. If you need to view more than three applications, the best alternative is to purchase a developer license, which allows for unlimited applications. However, that will set you back about $1400, even if the user is not a developer.

For how long have I used the solution?

I have been using it for four years.

What was my experience with deployment of the solution?

Licensing costs are a big one, see aforementioned point. Second would be the hardware requirements from a developer point of view. Because of the in-memory allocation of the application, really big data sets take a really, really long time to load, often times making the user wait quite a while for the loads to finish. If you are making changes to one dataset on an application that has multiple load statements, there isn’t an option to only reload the changed statement. Instead, the entire load has to be redone and thus the cycle begins again, as does the waiting.

How are customer service and technical support?

I have not dealt with technical support or customer service. We have an implementation area that deals with technical support for server related matters, however, we got the installation and support through a reseller. In our case, internally for all technical support related matters we have to go through our internal channels and processes and in turn if it is something that they cannot handle, they go through the reseller for resolution.

Which solution did I use previously and why did I switch?

The choice to use this product was an organizational decision.

How was the initial setup?

Initial setup was straightforward.

What about the implementation team?

We had a recommended vendor do the install on site. My only advice is to have users that are somewhat knowledgeable of the application to test. (It can be installed individually for testing.) Also, I recommend thorough testing of all aspects of loading data.

What's my experience with pricing, setup cost, and licensing?

Try to speak with the vendor in terms of the best possible licensing scheme, keeping in mind scalability and future deployments. In the end, if this is not properly calculated, it could be very costly.

What other advice do I have?

It is a great tool for analysis and dashboards. It is better complemented by bringing in data as complete as possible in terms of calculated fields, case statements, etc. QlikView syntax can take some time to learn and might not be as flexible as SQL or other similar languages, in terms of capability in manipulating data.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user408444
IT Manager at a financial services firm with 1,001-5,000 employees
Vendor
It provides flexible data loading and presentation without a data warehouse.

What is most valuable?

Loading data is the most valuable feature of this product to me, because we don’t have a data warehouse yet.

How has it helped my organization?

QlikView helps me to combine data from many data sources and represent it in the dashboards.

What needs improvement?

I think the visualization of the charts and the number of default charts provided by QlikView should be improved. QlikView only has limited chart options compared to its competitor. I think Map would be a great addition if QlikView can provide it as default chart. 

I think that the type of chart that is provided by QlikView must be added to capture the need of variety of visualization. Tableau has more charts compared to QlikView.

For how long have I used the solution?

I have been using this solution for about three months.

What was my experience with deployment of the solution?

I use it on my laptop with limited data. I've never used it for big data.

Which solution did I use previously and why did I switch?

I chose QlikView because it provides flexible data loading that can help us present data without a data warehouse.

What about the implementation team?

I implemented it by myself.

What's my experience with pricing, setup cost, and licensing?

Pricing is higher compared to the competitor.

What other advice do I have?

If you are looking for dashboards and do not have a data warehouse yet, QlikView is the best option.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user381315
Manager at a financial services firm with 51-200 employees
Vendor
Data is automatically extracted from the database, so users can see data and charts in real-time. The license price is expensive.

Valuable Features

In-memory processing and ETL function are the most valuable features of the product to me.

Improvements to My Organization

Because data is automatically extracted from the database, users can see the operating data and charts in real-time.

Room for Improvement

I would like to see them add a powerful map and improve statistic functions.

Use of Solution

I have used this solution for three years.

Deployment Issues

I have encountered scalability issues. Users get slower report response time when there are a lot of chart expressions.

Customer Service and Technical Support

Technical support is OK.

Initial Setup

Initial setup was straightforward. QlikView is an excellent product.

Implementation Team

We implemented using a vendor team.

Pricing,

Valuable Features

In-memory processing and ETL function are the most valuable features of the product to me.

Improvements to My Organization

Because data is automatically extracted from the database, users can see the operating data and charts in real-time.

Room for Improvement

I would like to see them add a powerful map and improve statistic functions.

Use of Solution

I have used this solution for three years.

Deployment Issues

I have encountered scalability issues. Users get slower report response time when there are a lot of chart expressions.

Customer Service and Technical Support

Technical support is OK.

Initial Setup

Initial setup was straightforward. QlikView is an excellent product.

Implementation Team

We implemented using a vendor team.

Pricing, Setup Cost and Licensing

The license price is expensive for us.

Other Advice

Generally speaking, QlikView is suitable for under mid-range scale company.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user381693
FSI IT Consulting Manager at Deloitte Portugal
Consultant
As long as its back end data model is well designed, it is intuitive.

What is most valuable?

The strongest characteristics of the product are its ease of use and its data discovery and exploration capabilities:

  • Ease of use, as it is very intuitive, as long as its back end data model is well designed, providing its end users with a high level of autonomy and the developers with a very intuitive and complete set of tools.
  • Data discovery and exploration, thanks to its in-memory data association capabilities that provide a fast and easy way to relate and explore data.

How has it helped my organization?

As a consultant, QlikView has helped me deliver high-value BI solutions to my customers, consistently exceeding their expectations and creating new opportunities for my firm.

What needs improvement?

It could be more mobile friendly, as some of its features don’t work properly on mobile devices or do not provide the best user experience to our customers who would like to extend their access to data. A Cortana/Siri-like feature or advanced analytical capabilities for users with advanced scripting and statistical skills would also extend its usage in the organizations where I operate.

For how long have I used the solution?

I have been working with QlikView for about 4 years.

What was my experience with deployment of the solution?

I still find some fine tuning issues when scaling up in concurrent usage or data volumes.

How are customer service and technical support?

Strong customer service, not as strong on the technical part, and the community is still a bit underdeveloped.

Which solution did I use previously and why did I switch?

I’ve also worked with other main market solutions like Microsoft, or Tableau, but over the last few years, QlikView has evolved considerably, especially when they completed it’s offering with Qlik Sense 2. Although it is not as versatile as the Microsoft solutions, it is stronger in ease of use and development when compared to Power BI for example. It’s licensing costs when compared to Tableau are also a differentiating factor.

How was the initial setup?

It was extremely simple and straightforward to implement.

What about the implementation team?

We do our own implementations without the need for a high level of involvement from the QlikTech vendor team. Our main advice is that a good understanding of how tabular models work when designing the data model, and a good understanding of the full QlikView offering specifically in terms of ETL, are fundamental for a good QlikView implementation project.

What was our ROI?

BI implementation projects using QlikView are normally faster to execute and faster to get the customer to perceive its value. However, it makes sense to start with a smaller investment specifically on QlikView licensing, as modeling the data and implementing the ETL part is still the biggest bottleneck. It doesn’t make any sense doing a big investment in user licensing, when the real use of QlikView still depends on getting the data to make sense.

What other advice do I have?

Make sure you have your data straight - think like Kimball, but act like Inmon - before moving to QlikView.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik partner.
ITCS user
Analista de inteligencia de mercado at a university with 1,001-5,000 employees
Vendor
It is possible to work with a large amount of data without affecting the performance.

What is most valuable?

It is possible to work with a large amount of data without affecting the performance.

How has it helped my organization?

It improved development, because we could just put our data into it and start working, even with datasets with millions of records. Its high speed has also improved my organization.

What needs improvement?

It would be great if this software had better transforming tools. We can do a lot of heavy work with scripts, but sometimes that gets really messy.

I mean that it would be very good to have a graphic tool to manipulate the data.
I work with IBM Modeler, and I love how easy it is to transform data in it. I think QlikView could implement a graphical interface to manipulate date, just like Modeler. I also think thats way off the scope of QlikView, but I am just thinking how great it would be to have such tool built in.

For how long have I used the solution?

I have used it for four years.

What was my experience with deployment of the solution?

I haven’t found any problem with deployment, stability or scalability yet.

How are customer service and technical support?

Technical support is very good. Every question I had, there was someone to help me.

Which solution did I use previously and why did I switch?

I started working in my actual job because of this software, so I didn´t have the opportunity to choose it. However, I can see it´s great software, and I´d surely choose it.

How was the initial setup?

There wasn´t any problem with the setup, it was very easy (much easier then Oracle OBIEE).

What about the implementation team?

When I got access to it, it was already implemented. I just upgraded one time, without any kind of problem.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultant at a tech consulting company with 1,001-5,000 employees
Consultant
We can make somewhat complex reports, even though it does not have the best capabilities as an ETL tool.

Valuable Features:

It works as a complete BI software solution for us. We can do complex scripting to build data models. We can make somewhat complex reports, even though it does not have the best capabilities as an ETL tool. It is not the best tool for complex reports. It also does not have the best visualizations, but it has a lot of features in one package, and that is its biggest selling point for us.

Performance is very fast. You can create dashboards for large sets of data and the dashboards are still quite responsive.

Creating dashboards takes a lot less time compared to other big vendor solutions.

Improvements to My Organization:

In my current organization, we use QlikView and we love it. We feel that for us it still does the best job possible. We want to be able to create
beautiful visualizations like we could with Tableau, but we also know that the flexibility we have in QlikView is not possible in Tableau.

Also, as of now, we have IT-driven BI and self-service is not what we are focusing on. We don’t have separate tools for ETL jobs. We think for our purposes, QlikView is better.

Room for Improvement:

In one word, QlikView has become dated now. Other vendors are providing equal or better solutions, especially for self-service, on-the-fly beautiful visualizations and ease of use.

QlikView is not moving as fast as the market trend. There are no big updates in their product that could make our life easier. As far as the useful functionalities, QlikView is the same as it was five years ago.

Other Solutions Considered:

They did launch a new tool to compete with Tableau, Qlik Sense, which they are trying to push to customers, but it actually falls behind QlikView. (They know that, but they don’t want us to compare Qlik Sense to QlikView, saying they are two entirely different tools.) We still prefer QlikView compared to Qlik Sense. Qlik Sense is incomplete at best.

Other Advice:

QlikView is your one-stop shop for all of your BI needs, and it performs well enough. With one tool, you can take raw data from your database/files and develop the complex analytic apps, which I think is the best thing going for QlikView. It’s very flexible and has matured itself well enough to be deployed organization-wide. The learning curve is definitely higher and you might need your apps developed by IT.

It is good for organizations that don't want to invest in multiple products.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user296397
MIS General Manager at a engineering company with 501-1,000 employees
Vendor
Users can see the operating data and chart in real-time. I would like it to have powerful map and statistical functions.

Valuable Features

The in-memory architecture and ETL function are the most valuable features of this product to us.

Improvements to My Organization

Data is automatically extracted from the database. Users can see the operating data and chart in real-time.

Room for Improvement

I would like to see them add powerful map and statistical functions.

Use of Solution

We have used this solution for three years (starting with the BI project kick-off).

Stability Issues

Dashboards’ response time is slow when the logic behind them are complex or when there are many dashboards in one QVD file.

Customer Service and Technical Support

It’s quite good and their response time is quick.

Implementation Team

Districom, a QlikView partner and reseller, implemented the BI solution for…

Valuable Features

The in-memory architecture and ETL function are the most valuable features of this product to us.

Improvements to My Organization

Data is automatically extracted from the database. Users can see the operating data and chart in real-time.

Room for Improvement

I would like to see them add powerful map and statistical functions.

Use of Solution

We have used this solution for three years (starting with the BI project kick-off).

Stability Issues

Dashboards’ response time is slow when the logic behind them are complex or when there are many dashboards in one QVD file.

Customer Service and Technical Support

It’s quite good and their response time is quick.

Implementation Team

Districom, a QlikView partner and reseller, implemented the BI solution for us. Districom’s business consultancy is very strong but their technical support is somewhat in need of improvement.

Pricing, Setup Cost and Licensing

The license cost is very high.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Angel Monjarás
Product Specialist and Education Services at a consultancy with 501-1,000 employees
Real User
The associative indexing engine does away with the need to design and build OLAP cubes.

What is most valuable?

  • The associative indexing engine that does away with the need to design and build OLAP cubes. Instead, it can integrate information from multiple sources in one data model that is easy to maintain, expand, and completely flexible to navigate (no pre-defined query paths).
  • The out-of-the-box ETL capability that takes care of the necessary data transformations without having to rely on a separate product.

How has it helped my organization?

All information analysis, from casual one-shots to continuous tracking reports, is done with QlikView. This lets us see new patterns as they develop, enabling us to react quickly.

What needs improvement?

Currently, there is no SaaS licensing model.

The ETL tool could use some visual aids in addition to the wizards that help to build the code.

Visualization design is not drag-and-drop.

For how long have I used the solution?

I have used it for 6.5 years.

What was my experience with deployment of the solution?

I have not experienced any deployment, stability or scalability issues, except when the workload load exceeds the hardware capabilities, which is the result of poor sizing, poor development practices, or unanticipated growth.

How are customer service and technical support?

Customer Service:

Customer service is almost always spotless.

Technical Support:

Tech support is efficient, but seldom necessary due to the very large and dynamic user community.

Which solution did I use previously and why did I switch?

We did not previously use a different solution. Choosing it comes naturally because we resell Qlik.

How was the initial setup?

Initial setup is as straightforward as client/server installations go. Complexity can arise when getting access to data sources or integrating with third-party security, for example.

What about the implementation team?

We implemented it in house, because we have a Qlik consulting practice. My advice is to not overcomplicate the implementation with excessive design, because the data model can grow organically over time.

What was our ROI?

Historically, ROI is best-in class for this kind of solution. My advice is: If you have many users, use the large deal size to your advantage.

What other advice do I have?

Join the Qlik Community, ask around if you have any questions, and hire certified consultants.

Take my rating in the context of a complete Business Intelligence platform: data acquisition, transformation, reporting, dashboards, visualization, analytics, collaboration, mobility, and so on.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
BI Consultant at a financial services firm with 10,001+ employees
Vendor
The most valuable features of the product are its in-memory and ETL capabilities, especially the set analysis function.

What is most valuable?

The most valuable features of the product are its in-memory and ETL capabilities, especially the set analysis function.

How has it helped my organization?

We developed in a couple of days an application based on a timesheet application, in order to have a real-time vision of what we do in IT service. Before, there wasn't any system except some Excel manual spreadsheets.

We developed a QlikView prototype based on sales data to give easy and visual access to the data. It took minutes to be loaded, compared to the existing system of traditional cubes that required hours to be loaded... to give what? Reports without any interactivity.

What needs improvement?

QlikView should improve its front-end design and import the Qlik Sense design within.

For how long have I used the solution?

I have been using it for two years.

What was my experience with deployment of the solution?

We used the Nprinting extension. A great toot to create PDF reports, etc... However, the tool is not stable; installation was difficult before being able to use it.

How are customer service and technical support?

I rate the level of customer service and technical support 8/10, efficient.

Which solution did I use previously and why did I switch?

I previously used IBM Cognos, Tableau, MS, SAP BO... Personally, QlikView is the best when you talk about fast delivery and visualisation.

How was the initial setup?

Initial setup was straightforward: half a day and your QlikView server is up and running.

What about the implementation team?

I implemented it in-house, but I had QlikView experience.

What was our ROI?

QlikView is like a race boat, compared to other vendors who are king of Queen Elizabeth. ROI is never easy to measure but at the very least, you will definitely deliver something with added value to your customers within weeks.

What other advice do I have?

Consider the ETL capabilites of the tool, not only the visualisation. And, of course, the performance!

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user257343
Business Intelligence Latin America Leader at a engineering company with 1,001-5,000 employees
Vendor
Once you select data on the dashboard, it highlights the unavailable data in order to show that those combinations don’t exist or aren’t possible.

What is most valuable?

Once you select any data on the dashboard, QlikView highlights the unavailable data in grey in order to show to users that those combinations don’t exist or aren’t possible.

Filters are not local. Once you filter something, the standard is to apply the filter to all tabs available in the dashboard.

How has it helped my organization?

They used to manage the business data through spreadsheets, now they have an automates process and a stable solution. It reduced to zero the time to prepare the data, avoiding operational issues and allowing them to put all the focus on business analysis.

What needs improvement?

Qlikview should have a connector or a specific product to allow people outside of the company or that don’t have a license to read/use the application (a kind of reader license). At least something really cheaper or free.

For how long have I used the solution?

I have used QlikView for three years.

What was my experience with deployment of the solution?

I have not yet encountered any issues with deployment, stability or scalability.

How are customer service and technical support?

I rate technical support 8/10.

Which solution did I use previously and why did I switch?

The time or effort to develop new stuff in QlikView is lower than other traditional tools as MicroStrategy, Cognos, etc. Besides that, we are changing our approach to a self-service BI.

How was the initial setup?

The initial setup was straightforward. QlikView allows you to install it on regular desktops with 8 GB memory. After some time, we migrated QlikView to a server with 64 GB, due to the number of users and the amount of applications developed.

What about the implementation team?

We implemented/developed with an in-house approach.

I would advise that the first implementation should be done through a vendor team in order to have better standards/best practices applied from the beginning. It would speed up the learning curve.

What was our ROI?

For this specific case, we didn’t calculate or estimate the ROI. Comparing QlikView to Tableau, I think that Tableau has a more attractive pricing/licensing approach than QlikView. I would recommend studying it before starting to acquire new licenses in QlikView due to the model of sales (Named Call and Document Call). The cost of new licenses could increase faster if you don’t have in mind the proper usage.

What other advice do I have?

Qlikview has a huge community in the internet with a lot of examples, online course, etc. It will help a lot to test by yourself. I would recommend providing a POC among the tools to identify which of them would fulfill your needs better.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user368133
BI Analyst at a energy/utilities company with 10,001+ employees
Real User
In-memory allows fast slicing and dicing of data.

Valuable Features

  • In-memory performance – It allows slicing and dicing of a huge volume of data in the dashboard very fast if designed optimally.
  • Scripting – It provides a flexible data-preparation layer, along with the ability for data integration from multiple data sources. This enables creating a reporting data model inside QlikView from a transactional system without impacting the performance of the transactional system, if designed correctly.

Improvements to My Organization

Overall, it enabled connecting the entire spectrum of data into a single dashboard in:

  • Finance – connecting sub-ledger txn details all the way to GL
  • Supply Chain

Room for Improvement

  • Self-service capability is very limited, though it has been improved in QlikSense. However, it will require an additional license & server to set it up.
  • Dashboard capabilities and features are not on par with Tableau, though the same has been attempted in QlikSense. However, Tableau still has better dashboard features.
  • Real-time analysis with live connection (direct discovery) is very limited.
  • The current version is missing a variety of connectors and they need to be procured separately.
  • Not adaptive to display across various screen resolutions

Use of Solution

I have used this solution for two years.

Deployment Issues

Initially, there was an issue with LDAP and SSO integration (a compatibility issue with an earlier version of SiteMinder).

Initial setup was non-clustered and we encountered performance issues. It resolved once we moved to better infrastructure in a clustered environment of QlikView.

Customer Service and Technical Support

Technical support is very geographically oriented, but isn’t truly 24X7.

Initial Setup

Initial setup was not intuitive, but straightforward for a Qlik admin expert.

Implementation Team

A vendor team implemented the solution.

Other Solutions Considered

I evaluated Tableau. However, we selected Qlikview because:

  • Tableau’s current recommendation is to build dashboards directly on top of the reporting DB (for example – data mart or consumption layer) to avoid doing complex logic or transformation inside the tool and using a hybrid approach of live connection and extract. Tableau is currently not an extract-heavy tool. However, with the recent HyPer acquisition, we are expecting some changes.
  • Incremental loading (updates and deletes) inside Tableau is a challenge, which can be achieved very easily in QlikView.
  • Limitation in Tableau on # of columns and rows in table view

Other Advice

Evaluate visualization tools based on your organization need and appetite to spend on BI technologies overall (DB, etc.)

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior IT Project Manager at a financial services firm with 10,001+ employees
Vendor
SQL scripting provides the fastest way to pull data into the system.

What is most valuable?

SQL scripting, as it provides me the fastest way to pull data into the system, since I’m more on the technical side.

How has it helped my organization?

It has made our processes for collecting and presenting data easier, especially with regard to old spreadsheet mentalities.

What needs improvement?

Their marketing department is heavy-handed, more so than it really needs to be. This can turn companies off when they get too aggressive. Their pricing structure doesn’t match their aggressiveness either, costing an end user $1500 for a web-based license.

For how long have I used the solution?

I have been using QlikView for about 11 months.

What was my experience with deployment of the solution?

Their set criteria is a mystery of legends. I still, after a year, need to pull up a wizard to type up a set expression. It’s not intuitive at all.

How are customer service and technical support?

Technical support is very good, with an exceptional user base. I’m largely self-taught on Qlik because of their community and the breadth of their support on-line.

Which solution did I use previously and why did I switch?

I previously used Microsoft BI tools, but as a company we were too far behind the curve to take advantage of their latest technology in the BI space. Upgrading to Office 2016 is not something a Fortune 500 company is going to do overnight.

How was the initial setup?

The desktop component was straightforward. I didn’t set up the server component, so I can’t speak to the publishing.

What about the implementation team?

An in-house team performed the implementation.

What was our ROI?

No definitive ROI, but an enterprise license would go a long way towards adaptability and acceptance.

What other advice do I have?

QlikView and QlikSense are powerful tools that require IT and BI expertise to take full advantage of. True BI utilization is not just dragging fields and creating graphs. It requires deep knowledge of data utilization and visualization. Qlik can provide that, BUT at the cost of additional IT or BI expertise.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user254223
Project Manager - Business Intelligence at www.datademy.es
Consultant
We use QlikView to create department dashboards with useful analysis.

What is most valuable?

  • Flexibility
  • Agile development
  • Intuitive
  • Very good performance
  • Excellent user groups

How has it helped my organization?

We use QlikView to create department dashboards. We can create powerful dashboards with useful analysis in a few days.

What needs improvement?

I think its visualization has room for improvement, and I know Qlik Sense has better visualization.

For how long have I used the solution?

I have used it for two years.

What do I think about the stability of the solution?

It's difficult to manage big and complex data models, but the reason is that there isn't a semantic layer in Qlikview, but not having a semantic layer is a good point in other aspects, like agile development.

How are customer service and technical support?

Excellent, very good and active community.

Which solution did I use previously and why did I switch?

I have used Business Objects and Microstrategy. QlikView is a different tool. It has advantages and disadvantages compared to Business Objects or Microstrategy. The main advantages are flexibility and agile development.

How was the initial setup?

It was straightforward.

What was our ROI?

We haven't calculated the ROI yet.

What's my experience with pricing, setup cost, and licensing?

I think the pricing is really competitive.

What other advice do I have?

QlikView is an excellent reporting and data discovery tool. I have used it on a departmental scale, but not on a corporate level so I don't know how it will behave on that level.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior Manager - Anti Money Laundering at a financial services firm with 10,001+ employees
Vendor
The product enables top management with better decision making if utilized properly.

Valuable Features:

  • Data discovery
  • Set analysis
  • Adhoc reporting
  • Drill down options
  • Flexibility
  • In-Memory technology
  • Quick learning curve
  • Easy to deploy

Improvements to My Organization:

The product enables top management with better decision making if utilized properly.

Room for Improvement:

QlikView should not loose its original flavour. They should stop trying to emulate other BI products and mould their own product.

Use of Solution:

I'm using the QlikView local client.

Other Advice:

It is best suited for Dashboarding, Analysis and Reporting. Do not try to re-implement everything from a previous BI product if you had one. Ensure that the QlikView features & functionality are properly utilized to get the best out of it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user358971
Associate Consultant at a tech services company with 10,001+ employees
Real User
Integration with almost all databases is good.

Valuable Features:

  • Ease of use
  • NPrinting
  • Visually good diagrams
  • Integration with almost all databases
  • Associating links

Improvements to My Organization:

We have used this product for a number of different clients, and most of them liked the software and all the rich features it bring with it. The amount of data it displays on the dashboard with such a ease, helps users to always get the results in desirable time limit.

Room for Improvement:

They are coming up with a lot of improvements. However, the version control is not one of them, and it's not straightforward.

Deployment Issues:

We have had no issues with the deployment.

Stability Issues:

There have been no stability issues.

Scalability Issues:

We've had no issues with scaling it for our needs.

Other Advice:

There is a number of criteria you have to see before you start implementing the product, as you compare Qlikview with other tools such as Tableau. You make sure that you check the cost, ease of use, differnt ways to displaying the information etc.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jhornber
Director, BI & Analytics at a leisure / travel company with 10,001+ employees
Real User
Top 20
I would never propose QlikView, or any other single tool, as THE definitive data visualization and dashboard tool for every organization, but it did best meet our particular needs.

What is most valuable?

1. QlikView Scripting - Takes some time to learn, but it is very powerful. Not as a total ETL replacement tool necessarily, but as a supplement to load and join data sources, perform additional transformations, add supplemental inline tables, and even at times, output a final .txt/.csv for consumption by other tools (even Tableau!). I've combined as many as a half dozen data sources including data from multiple SQL Data Marts, Teradata Data Marts,Source System DBs, XLS, CSV, and Google Big Query.

2. Design Flexibility - While other products may do drag and drop, ad-hoc reporting analytics better. (Including Tableau, and Qlik's new product QlikSense) I've not come across one that better supports the creation of a polished, packaged, custom dashboard, that supports what I'd consider "guided exploration", and best meets the needs of our user base. The customization can be taken even further through in-house built, or borrowed, extensions (e.g. Custom D3 Visualizations).

How has it helped my organization?

We have gradually reduced laborious manual reporting in Business Units and "spreadmarts". We now have some executive using QV dashboards in weekly review meetings, in place of spreadsheets and PowerPoints. While it does take some time and IT involvement to initially develop and deploy a solution, the payback is immediate. In one particular case we were able to eliminate a days worth of manual work with a QlikView solution that required a few days of development effort. We also previously had no way for end users to routinely and easily analyze larger (100 Million+ rows) data sets, which now can be done through QlikView.

What needs improvement?

No out of the box mapping capabilities (Extensions/Plugins available).

No auto-scale for different display resolutions/dimensions, but the trade-off here is the much greater design flexibility than one gets with a Grid based product.

Would like to see a few more visualizations available out of the box (e..g Bullet Graph)

Very rudimentary report creation and PDF capabilities No scheduling or distribution without Publisher product.

For how long have I used the solution?

2 1/2 years

What was my experience with deployment of the solution?

None.

What do I think about the stability of the solution?

None thus far, but have a relatively small scale implementation (30-40 Users to date), on a single server (196GB RAM, 15 Core). Our largest data sets are in the 100-200 Million rows. Dashboards deployed to the server perform very well, but working with data sets that large locally (on QlikView desktop) may start to lag, depending on your hardware. Being a in-memory tool, desktops and laptops should have at least 8GB RAM, though even more is preferable if working with very large data sets.

How are customer service and technical support?

Customer Service:

Customer service was/is excellent.

Technical Support:

Our need for technical support has been minimal, but when needed it has been great. The overall Qlik Community is phenomenal. Many problems can be resolved through the community channel. Users often provide example files one can reference or reverse engineer.

Which solution did I use previously and why did I switch?

Previously used an older Domo product (Centerview). The product was no longer supported. It was very flexible, but also very labor intensive. Data had to be fully prepared outside of the tool ,and every interaction had to be defined. Development time was weeks vs days in QlikView.

Currently also using Tableau, depending on the particular use case.

How was the initial setup?

Straightforward setup. Connected to Active Directory to manage users.

What about the implementation team?

In-house with some set up assistance provided by the Qlik sales support team.

What's my experience with pricing, setup cost, and licensing?

Server is Apprx $35K initial cost, plus 20% annual maintenance/support cost

User licenses are $350 or $1500 depending on license type(plus 20% annual maintenance/support). This can get costly if you have a very large user base.

Which other solutions did I evaluate?

Several. If interested see my post http://www.itcentralstation.com/articles/i-evaluat...

What other advice do I have?

I would never propose QlikView, or any other single tool, as THE definitive data visualization and dashboard tool for every organization, but it did best meet our particular needs. Organizations with more data-savvy, self-sufficient business users may find a product like Tableau, or Qlik's other product, QlikSense, to be a better option.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
IT Analyst at a government with 501-1,000 employees
Vendor
​There have been no stability ​issues and a restart can be automated on a virtual machine. It can be deprecated as it follows an older approach.

Valuable Features

The ability to customize it. This involves a bit of programming however and that can be an issue. For data visualization, it involves the end-user with self-service BI. It's ETL functions are powerful as well, but this is a bit of an old fashioned approach.

Improvements to My Organization

Annual Information from public sector following transparency laws are now publicized in an automated way. Previously, this task used to involve a lot of scripting development and data warehouse routines, such as ETL. Now all this is done using QlikView and raw data.

Room for Improvement

Actually, Qlik, has decided to move forward with a brand new product, Qlik Sense, so it seems that QlikView can be deprecated as it follows an older approach that pre-dates data visualization in data warehouse and BI.

Use of Solution

I've used it for the last two years.

Deployment Issues

The tool involves too much programming when compared to other tools. It has a development/delivery circle as any internal system development for test/production environment does.

Stability Issues

There have been no stability issues and a restart can be automated on a virtual machine.

Scalability Issues

The product eats all memory you give according to the number of accesses it gets, as the navigation is buffered for future queries. Ideally, the datasets must be summarized to the granularity that the public expects.

Customer Service and Technical Support

Customer Service:

9/10

Technical Support:

9/10

Initial Setup

It was done with technical support, but I wouldn't classify it as complex.

Implementation Team

We used a vendor team who were 9/10.

ROI

This is not easy to measure, but senior management and the public are satisfied.

Pricing, Setup Cost and Licensing

It's aligned to the market, but document viewing and sharing constraints are a bit confused and intimidate. They have changed their approach for Qlik Sense.

Other Solutions Considered

All proof of concepts used trials and it's not easy to buy a specific product for the government, so the management decision was to apply to an on going acquisition process where the product was already chosen. Two other options were Tableau and Infogram.

Other Advice

Their competitors seem to be more up to date with features and technology. Check whether Qlik Sense is better for you, otherwise you may acquire a legacy tool.

This is a collage of some panels, in Portuguese. The data refers to Brazilian docking ports and loads by type of load, goods, and regions.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user377319
Analytics Application Consultant Manager at a computer software company with 51-200 employees
Vendor
The associative and in-memory technology are the most valuable features.

What is most valuable?

The associative and in-memory technology are the most valuable features.

How has it helped my organization?

It’s an easy way to create dashboards with minimal training. This product is good and I can collect data from multiple data sources.

What needs improvement?

They need to improve on the idea, concept and support.

For how long have I used the solution?

I've used it for five years, alongside Qlik Sense.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

There were no issues with the stability.

What do I think about the scalability of the solution?

There were no issues with scaling it.

How are customer service and technical support?

What is most valuable?

The associative and in-memory technology are the most valuable features.

How has it helped my organization?

It’s an easy way to create dashboards with minimal training. This product is good and I can collect data from multiple data sources.

What needs improvement?

They need to improve on the idea, concept and support.

For how long have I used the solution?

I've used it for five years, alongside Qlik Sense.

What was my experience with deployment of the solution?

There were no issues with the deployment.

What do I think about the stability of the solution?

There were no issues with the stability.

What do I think about the scalability of the solution?

There were no issues with scaling it.

How are customer service and technical support?

Customer Service:

8/10

Technical Support:

8/10

Which solution did I use previously and why did I switch?

No other solution was in place, but I have tried others and they can't offer what Qlik can.

How was the initial setup?

QlikView initial set-up is simple just run the installer and click next.

What's my experience with pricing, setup cost, and licensing?

If you can license QlikView with Qlik Sense it’s very good.

Which other solutions did I evaluate?

  • Tableau
  • MicroStrategy
Disclosure: My company has a business relationship with this vendor other than being a customer: I’m Qlik Partner in Indonesia
ITCS user
Senior Software Developer at a tech services company with 1,001-5,000 employees
Consultant
You can start working with it immediately after installation.

Valuable Features:

Easy to use in small/middle organization Cheap tool when compared to MicroStrategy It does require a separate ETL tool

Improvements to My Organization:

It helps to provide answers quickly for critical business questions. It has reduced our time spent on data entry and manipulation and can identify areas for cost cutting.

Use of Solution:

We've used it for three years.

Customer Service:

It's good.

Initial Setup:

It's a straightforward set-up. You can start working with QlikView immediately after installation.

Implementation Team:

I have implemented it for different clients.

Other Solutions Considered:

I also use MicroStrategy.

Other Advice:

If you are having small business set-up then you have to go for QlikView else MicroStrategy is more…

Valuable Features:

  • Easy to use in small/middle organization
  • Cheap tool when compared to MicroStrategy
  • It does require a separate ETL tool

Improvements to My Organization:

It helps to provide answers quickly for critical business questions. It has reduced our time spent on data entry and manipulation and can identify areas for cost cutting.

Use of Solution:

We've used it for three years.

Customer Service:

It's good.

Initial Setup:

It's a straightforward set-up. You can start working with QlikView immediately after installation.

Implementation Team:

I have implemented it for different clients.

Other Solutions Considered:

I also use MicroStrategy.

Other Advice:

If you are having small business set-up then you have to go for QlikView else MicroStrategy is more stable for big organisations.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior BI Consultant at a retailer with 51-200 employees
Consultant
​We use it for dashboard reporting.

Improvements to My Organization

We use it for dashboard reporting.

Room for Improvement

It needs JDBC connection for different databases.

Use of Solution

I've used it for five years.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service: It's good. Technical Support: It's good.

Initial Setup

Consultants setup our tools.

ROI

I think it is good. We took awards area of Big Data Technologies and we give some free or paid services to our customers.

Other Advice

You should try the trial version. if it is usable for your business, you should buy it.

Improvements to My Organization

We use it for dashboard reporting.

Room for Improvement

It needs JDBC connection for different databases.

Use of Solution

I've used it for five years.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service:

It's good.

Technical Support:

It's good.

Initial Setup

Consultants setup our tools.

ROI

I think it is good. We took awards area of Big Data Technologies and we give some free or paid services to our customers.

Other Advice

You should try the trial version. if it is usable for your business, you should buy it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
IT Project Manager at a energy/utilities company with 501-1,000 employees
Vendor
It saves us time by providing information all in one place for our users. However, it has a complicated license management.

Improvements to My Organization:

It provides information all in one place for our users. It saves us time.

Room for Improvement:

Threshold for a non-coder to create new reports. Complicated license management.

Improvements to My Organization:

It provides information all in one place for our users.

It saves us time.

Room for Improvement:

Threshold for a non-coder to create new reports.

Complicated license management.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
SAP Application Specialist at a comms service provider with 501-1,000 employees
Vendor
It's helped us get faster KPI's in many departments and it produces reports quickly.

What is most valuable?

It produces reports quickly.

How has it helped my organization?

We're able to get faster KPI's in many departments.

What needs improvement?

Job scheduler needs work.

For how long have I used the solution?

I've used it since 1 November 2012.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service: 10/10 - it's perfect, very fast and very good support. Technical Support: 10/10, Heyde is a perfect partner.

Which solution did I use previously and why did I switch?

Data Warehouse built with SQL,and…

What is most valuable?

It produces reports quickly.

How has it helped my organization?

We're able to get faster KPI's in many departments.

What needs improvement?

Job scheduler needs work.

For how long have I used the solution?

I've used it since 1 November 2012.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

10/10 - it's perfect, very fast and very good support.

Technical Support:

10/10, Heyde is a perfect partner.

Which solution did I use previously and why did I switch?

Data Warehouse built with SQL,and it was too complicated, and oversized for a medium sized company, and too slow for any changes.

How was the initial setup?

It was straightforward, and after the installation we had the first results in a few days.

What about the implementation team?

Through a vendor, Heyde, whose level of expertise is very good, 10/10.

What was our ROI?

Even though I am not able to mention a number or time, but because we didn’t have an equal solution it's been very good.

What's my experience with pricing, setup cost, and licensing?

Start small, and use this to get a close business relationship.

Which other solutions did I evaluate?

The DWH of our ERP.

What other advice do I have?

Top down, that requests from the top-level management of how deep the drill down should be.

Disclosure: My company has a business relationship with this vendor other than being a customer: We do have a close partnership with our vendor. We are working very close, it wouldn’t work in another way efficiently.
ITCS user
Product Manager - Healthcare Analytics at a healthcare company with 51-200 employees
Vendor
It's helped us aggregate our client-based data, but it is a very heavy RAM utilizer.

Valuable Features

  • KPI's
  • Dashboard creation

Improvements to My Organization

Powerful, scalable, and a bit addictive, allowing you to "see" your data in ways never thought possible. We can now take medical stats presented in an academic journal and applying them to community-based medicine. This literally changes physician behavior like no other tool.

We were struggling with running application reports, and were spending substantial time, and high-end resources to deliver the basics. Implementing QlikView for our clients also allowed us to aggregate our client-based data and see "What type of reports are they running" "What time of day" "Which users". This data alone allowed us to immediately focus on the points of user experience which would impact the users the most.

Room for Improvement

Online education, but they are revamping.

Use of Solution

I've used it for two years.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

QlikView is a very heavy RAM utilizer (all strong BI tools are). When we hit around 20 concurrent users, the user experience began to suffer. We contacted Qlik Support and they assisted us with a review of our infrastructure. We followed their suggestions to the tee, and were back with great speed!

Customer Service and Technical Support

Customer Service:

It's excellent, and very responsive.

Technical Support:

It's excellent.

Initial Setup

Simple, low level learning curve.

Implementation Team

We did it in-house.

ROI

Currently $1 spent = $3 recouped (including labor/support/Infrastructure).

Pricing, Setup Cost and Licensing

Push for more services in your installation (consulting, IT, Development, Design). Sales can be very creative.

Other Solutions Considered

We also looked at Tableau.

Other Advice

Review your end-goals, internally and externally. This can be a powerful tool for your clients but also for internal decision making.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
BI Expert at a tech services company with 51-200 employees
Consultant
Advanced information applications can be built, not only simple ones.

What is most valuable?

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.

How has it helped 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.

What needs 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.

For how long have I used the solution?

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

What was my experience with deployment of the solution?

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.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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.

How are 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.

Which solution did I use previously and why did I switch?

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.

How was the 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.

What about the implementation team?

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

What was our 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.

What's my experience with 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.

Which other solutions did I evaluate?

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.

What other advice do I have?

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.
Ed Dallal
Founder, CEO, & President at Krystal Sekurity
Consultant
It's easy to use but more graphics and dashboard support would be an improvement.

What is most valuable?

Ease of use Implementation Processing speed

How has it helped my organization?

Trends Opportunities Automated reporting

What needs improvement?

More graphics Dashboard support

For how long have I used the solution?

I've used QlikSense for six months.

What was my experience with deployment of the solution?

Not really.

What do I think about the stability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service: It's very good. Technical Support: I haven't had a need to contact them.

Which solution did I use previously and why did I switch?

We used Cognos BI which was fast but a bit complex.

What about the implementation team?

We used an in-house team.

What was our ROI?

It's…

What is most valuable?

  • Ease of use
  • Implementation
  • Processing speed

How has it helped my organization?

  • Trends
  • Opportunities
  • Automated reporting

What needs improvement?

  • More graphics
  • Dashboard support

For how long have I used the solution?

I've used QlikSense for six months.

What was my experience with deployment of the solution?

Not really.

What do I think about the stability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

It's very good.

Technical Support:

I haven't had a need to contact them.

Which solution did I use previously and why did I switch?

We used Cognos BI which was fast but a bit complex.

What about the implementation team?

We used an in-house team.

What was our ROI?

It's taken six months to get an ROI.

What's my experience with pricing, setup cost, and licensing?

It was free to download.

Which other solutions did I evaluate?

We also evaluated Tableau, which we also use, and Cognos BI.

What other advice do I have?

Try it alongside Tableau as depending on user preferences and other requirements, either product will do the job.

Disclosure: My company has a business relationship with this vendor other than being a customer: Qlik partner
ITCS user
Lead Technical with 1,001-5,000 employees
Vendor
Needs more support for collaboration. Extremely powerful for data analysis.

What is most valuable?

Amazing performance Easy to use self service Extremely powerful for data analysis

How has it helped my organization?

It has dramatically improved development time for BI reports. Using traditional tools like OBIEE or SAP BO, BI was more like an IT dependent work stream. Now it has reached the business side, who can do their own analysis. Users can drill data without much IT help.

What needs improvement?

More flexibility to alter auto association in the data model. Support for collaboration.

For how long have I used the solution?

3 years

What was my experience with deployment of the solution?

No issues with deployment, except a few hurdles for single sign on integration.

What do I think about the stability of the solution?

No, CPU and memory…

What is most valuable?

Amazing performance

Easy to use self service

Extremely powerful for data analysis

How has it helped my organization?

It has dramatically improved development time for BI reports.

Using traditional tools like OBIEE or SAP BO, BI was more like an IT dependent work stream. Now it has reached the business side, who can do their own analysis. Users can drill data without much IT help.

What needs improvement?

More flexibility to alter auto association in the data model.

Support for collaboration.

For how long have I used the solution?

3 years

What was my experience with deployment of the solution?

No issues with deployment, except a few hurdles for single sign on integration.

What do I think about the stability of the solution?

No, CPU and memory usage are not clearly presented.

How are customer service and technical support?

Customer Service:

Good, they need more proactive support.

Technical Support:

Good

Which solution did I use previously and why did I switch?

Yes, from SAP BO for ease of use and less time for development.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user208263
Associate Director at a consultancy with 1,001-5,000 employees
Consultant
The SME server edition doesn't include a deploy tool but it's a really good package for management reporting purposes.

Valuable Features:

  • Relationship based data modelling
  • Flexible charting

Improvements to My Organization:

It speeds up my clients capability to prepare various non-standard management reports.

Room for Improvement:

  • Macro Editing
  • It should have an HTML text box control
  • Presentation on smart device 
  • The performance of the Qlikview website is poor as it takes three minutes to open a page
  • The SME server edition does not include a deploy tool, and we have to copy updated document to the server manually which seems ridiculous

Use of Solution:

I've used it for two years.

Deployment Issues:

No issues encountered.

Stability Issues:

No issues encountered.

Scalability Issues:

No issues encountered.

Initial Setup:

It was quite straightforward.

Implementation Team:

We involved a local vendor, Shanghai EBI Strategy, and they helped us develop the solution based on our design, however, the result is not as good as expected.  In the local Chinese market, there is a lack of experienced consultants. I searched on the Qlikview forum for many tricks and solutions by myself and improved the overall data modelling structure.

ROI:

It's not bad.

Other Solutions Considered:

Yes, we also looked at BO and Microstrategy.  As Microstrategy is also a good package, we are exploring it further.

Other Advice:

It is a really good package for your management reporting purpose, as you do not rely on IT support to add/revise any reports.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
IT Specialist at a manufacturing company with 501-1,000 employees
Vendor
We mainly use it for visualizations. Issues we experienced were due to issues with our server hardware.

What is most valuable?

Integrated ETL In-memory data QlikView Management Console Front-end design.

How has it helped my organization?

Implemented some visualizations for: Orders Management Sales Dashboard Contribution Margin Dashboard Budget x Real Expenses Management So now we have better control in some areas, like Sales, Logistics and Financials. Sales, Marketing, Internal Controls, Factory, HR, Logistics, etc. all still have room for improvement.

For how long have I used the solution?

Over two years.

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

Yes, because at the beginning I didn't have the appropriate hardware in our servers. After an upgrade, there were no problems at all.

What do I think

What is most valuable?

  • Integrated ETL
  • In-memory data
  • QlikView Management Console
  • Front-end design.

How has it helped my organization?

Implemented some visualizations for:

  • Orders Management
  • Sales Dashboard
  • Contribution Margin Dashboard
  • Budget x Real Expenses Management

So now we have better control in some areas, like Sales, Logistics and Financials.

Sales, Marketing, Internal Controls, Factory, HR, Logistics, etc. all still have room for improvement.

For how long have I used the solution?

Over two years.

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

Yes, because at the beginning I didn't have the appropriate hardware in our servers. After an upgrade, there were no problems at all.

What do I think about the scalability of the solution?

Upgrading server hardware.

How are customer service and technical support?

Customer Service:

9/10.

Technical Support:

8/10.

Which solution did I use previously and why did I switch?

No previous solution used.

How was the initial setup?

It was complex because we didn't have the correct person (resource) to build the right queries. We then got someone with the right competency and things have been going well.

What about the implementation team?

In-house one.

What other advice do I have?

Not too many developers available in our market (Brazil).

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consulting Manager at a consultancy with 51-200 employees
Consultant
Fast access to data is a valuable feature but a less monolithic approach is needed

What is most valuable?

Fast access to data Rapid development Rich graphic interface

What needs improvement?

Licensing costs Cloud solution Less monolithic approach

For how long have I used the solution?

Six years.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

Yes we did.

How are customer service and technical support?

Customer Service: 8 out of 10 Technical Support: 8 out of 10

Which solution did I use previously and why did I switch?

We previously used SAP BW, and we changed because it had very complex development, and long development times.

How was the initial setup?

It was…

What is most valuable?

  • Fast access to data
  • Rapid development
  • Rich graphic interface

What needs improvement?

  • Licensing costs
  • Cloud solution
  • Less monolithic approach

For how long have I used the solution?

Six years.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

Yes we did.

How are customer service and technical support?

Customer Service:

8 out of 10

Technical Support:

8 out of 10

Which solution did I use previously and why did I switch?

We previously used SAP BW, and we changed because it had very complex development, and long development times.

How was the initial setup?

It was straightforward.

What about the implementation team?

We used a mix of an in-house team and a vendor team.

What was our ROI?

Six months.

Which other solutions did I evaluate?

We looked at doing either an in-house development or an ad-hoc solution from a software provide.

What other advice do I have?

You should perform a good sizing of the server, and develop a simple data model.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user175005
Project Manager at a logistics company with 51-200 employees
Vendor
We now have set up and shared dashboards across our services. Not all the features are available for Mac users.

What is most valuable?

Dynamic dashboards is definitely the most valuable feature. You select your filters and all your graphs and tables are automatically updated; it really saves time when doing analysis! 

How has it helped my organization?

Thanks to Qlikview we have been able to set up and share dashboards across our services. We can monitor our internal productivity and revenue, but as well our client’s activity and be proactive if we see a sudden change in volumes. We also monitor our service levels.
Qlikview is giving visibility to our directors and VP , accounts department, as well as operational managers who can follow on their teams productivity. 

What needs improvement?

Qlikview is very intuitive and user friendly compared to other solutions, however I regret that some of their features are not available for Mac users.

A build your own report feature on standard .qvw would be great. Qlik has recently launched Qliksense, it answers this need but we cannot use the Qliksense feature on Qlikview reports. An all-in-one solution would be perfect.

For how long have I used the solution?

Since 2008

What was my experience with deployment of the solution?

Initial database set up was the main concern.

How are customer service and technical support?

Customer Service is good, however we mainly use the Qlikview community. We can reach out to other users / developers who are always available to help.

Which solution did I use previously and why did I switch?

Before Qlikview we had 2 BI solutions : Cognos and Hummingbird. Hummingbird was more a database extraction tool available for our clients. We then developed our own operational web-based database for our clients to check their transportation invoices and extract instantly the data they needed for reporting purposes. When this solution was live and operational we stopped Hummingbird as it did not make any sense to maintain both solutions.

In parallel, Cognos was our BI tool for dashboards/ graphs. We decided to change to Qlikview since Cognos was more complex in terms of development and less user friendly. 

How was the initial setup?

I would say straightforward. Training was provided by our supplier, and our developers already had BI knowledge . 

What about the implementation team?

Our vendor (Decideis) helped us with the initial set up and training; we then deployed the solution ourselves.

We are really happy with their knowledge of Qlikview. 

Which other solutions did I evaluate?

Cognos was evaluated and Qlikview was highly recommended by one of our customers.

What other advice do I have?

Define precisely your needs, your budget and the resources available to set-up, deploy and maintain the solution. There are different solutions on the market, choose the one that will answer your needs. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultant at a tech services company with 51-200 employees
Consultant
Information used to be spread across different platforms, now we have a single source. GUI could be improved.

Valuable Features:

Memory data management, quick analysis and reporting.

Improvements to My Organization:

We can collect and analyze information; until now information was spread across different sites, databases and spread sheets, managed by people belonging to different organizations. Now reports are available in short time in a single source.

Room for Improvement:

Graphic User Interface, the product could be improved by a smarter, more intuitive and friendly interface for graphs or reports.

Use of Solution:

2 months.

Deployment Issues:

No issues with deployment. 

Stability Issues:

No problems with stability. 

Scalability Issues:

Yes, we had issues with scalability. 

Customer Service:

Valuable Features:

Memory data management, quick analysis and reporting.

Improvements to My Organization:

We can collect and analyze information; until now information was spread across different sites, databases and spread sheets, managed by people belonging to different organizations. Now reports are available in short time in a single source.

Room for Improvement:

Graphic User Interface, the product could be improved by a smarter, more intuitive and friendly interface for graphs or reports.

Use of Solution:

2 months.

Deployment Issues:

No issues with deployment. 

Stability Issues:

No problems with stability. 

Scalability Issues:

Yes, we had issues with scalability. 

Customer Service:

Not enough data to give an opinion. 

Initial Setup:

Very easy setup.

ROI:

We have not yet quoted a ROI, we expect a valuable saving of time and resource by cutting manual reporting, better decision making processes, and on time strategic management alignment.

Cost and Licensing Advice:

We are in early evaluation phase.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Team Lead, Data Engineering at a retailer with 501-1,000 employees
Vendor
Would be nice to see an improvement in server performance. Overall very intuitive to use.

What is most valuable?

Ease of use, visualization, intuitive, the Qlik method of ETL, Qlik Sense

How has it helped my organization?

Analysis in real time, predictive analytics, reporting

What needs improvement?

Server performance. Reloading of data sometimes weigh down the server's performance.

For how long have I used the solution?

1 year

What was my experience with deployment of the solution?

No issues with deployment.

What do I think about the stability of the solution?

Slight issues with stability.

What do I think about the scalability of the solution?

No issues with scalability.

How are customer service and technical support?

Customer Service: 8/10 Technical Support: 8/10

Which solution did I use previously and why did I switch?

SAP BusinessObjects.…

What is most valuable?

Ease of use, visualization, intuitive, the Qlik method of ETL, Qlik Sense

How has it helped my organization?

Analysis in real time, predictive analytics, reporting

What needs improvement?

Server performance. Reloading of data sometimes weigh down the server's performance.

For how long have I used the solution?

1 year

What was my experience with deployment of the solution?

No issues with deployment.

What do I think about the stability of the solution?

Slight issues with stability.

What do I think about the scalability of the solution?

No issues with scalability.

How are customer service and technical support?

Customer Service:

8/10

Technical Support:

8/10

Which solution did I use previously and why did I switch?

SAP BusinessObjects. Change in business requirements.

What about the implementation team?

Vendor - 7/10.

Which other solutions did I evaluate?

Yes. SAP BOBJ

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user164283
BI Developer at a tech services company with 51-200 employees
Real User
With one of our implementations, we saved the company over $1 million. Look and feel of the charts could be improved.

Valuable Features

Powerful Business Discovery Capabilities Fast Implementation Time Ease of Use Easily Scalable Quality Product

Improvements to My Organization

With one of our Implementations at a mining house, we were able to save the company over $1 million, by cutting out surplus inventory.

Room for Improvement

The look and feel of the charts and graphs can greatly be improved.

Use of Solution

2.5 Years.

Deployment Issues

No deployment problems.

Stability Issues

No stability problems.

Scalability Issues

No scalability problems.

Customer Service and Technical Support

Customer Service: Very good. Technical Support: Very good.

Initial Setup

The setup is very straightforward. The documentation is clear and concise.

Other Advice

Choose a good…

Valuable Features

  1. Powerful Business Discovery Capabilities
  2. Fast Implementation Time
  3. Ease of Use
  4. Easily Scalable
  5. Quality Product

Improvements to My Organization

With one of our Implementations at a mining house, we were able to save the company over $1 million, by cutting out surplus inventory.

Room for Improvement

The look and feel of the charts and graphs can greatly be improved.

Use of Solution

2.5 Years.

Deployment Issues

No deployment problems.

Stability Issues

No stability problems.

Scalability Issues

No scalability problems.

Customer Service and Technical Support

Customer Service:

Very good.

Technical Support:

Very good.

Initial Setup

The setup is very straightforward. The documentation is clear and concise.

Other Advice

Choose a good Implementation Partner with a wide level of expertise.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are a QlikView Implementation Partner.
ITCS user
Architect at a tech services company with 1,001-5,000 employees
Consultant
A lot of options in the tabbed panel used for different components

What is most valuable?

Its easy and fast to build dashboards.

For how long have I used the solution?

One year

What was my experience with deployment of the solution?

Sometimes the product final (look & feel) is different from the desktoop tool and the web server.

What do I think about the stability of the solution?

Its a product very stable

What do I think about the scalability of the solution?

No

How are customer service and technical support?

Customer Service: 4 out of 5. Technical Support: 4 out of 5.

Which solution did I use previously and why did I switch?

Microstrategy. We changed because Qlikview is faster to build a dashboard than Microstrategy.

What about the implementation team?

Vendor team Good expertise

Which other solutions did I evaluate?

What is most valuable?

Its easy and fast to build dashboards.

For how long have I used the solution?

One year

What was my experience with deployment of the solution?

Sometimes the product final (look & feel) is different from the desktoop tool and the web server.

What do I think about the stability of the solution?

Its a product very stable

What do I think about the scalability of the solution?

No

How are customer service and technical support?

Customer Service:

4 out of 5.

Technical Support:

4 out of 5.

Which solution did I use previously and why did I switch?

Microstrategy. We changed because Qlikview is faster to build a dashboard than Microstrategy.

What about the implementation team?

Vendor team

Good expertise

Which other solutions did I evaluate?

Tableau

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultant at a tech services company with 51-200 employees
Consultant
Presentation of data on a map and what-if modeling could be better, but its point and click user interface is valuable

What is most valuable?

The features of this product that are most valuable are: its point and click user interface, speed, ability to follow dependencies in data, ability to fix any view in my special sheet, ability to track back to data sources for any output value or part of a graph.

How has it helped my organization?

We implemented an application for control of sales team, for controlling. Accounting people or our sales director are able to work with it without extensive training and they are able to do their own analysis without support of IT people. We developed an application for health insurance company that allows them better control of a cost paid to hospitals or doctors. They have very detailed analysis of drugs paid by insurance.

What needs improvement?

Areas of this product with room for improvement are ETL, presentation of data on a map, what-if modeling or predictive modeling, license policy.

For how long have I used the solution?

We are using it for, I think, 6 years.

What was my experience with deployment of the solution?

No. But you should respect such special features when you design a data model.

What do I think about the stability of the solution?

No issues with stability.

What do I think about the scalability of the solution?

No. But we did not used QlikView for Big data.

How are customer service and technical support?

Customer Service: The customer service is done by partners. So if you have knowledgeable partner the service is good, if not you can easily switch to another. Our country is small and there are several partners who can support QlikView, so I think that every customer could receive good support.Technical Support: Technical support from QlikTech is at standard level. What is non-standard in a comparison with other tools is the very low number of errors that we found. I do not remember any important error during the time we used it.

Which solution did I use previously and why did I switch?

We used Microstrategy, Actuate, Crystal Reports. Microstrategy was much slower (all of them) and it had very bad support in our country. All three tools consumed much more days for building the applications – but it was 5-6 years ago, I am not familiar with today’s versions.

How was the initial setup?

It was straightforward, but we have skilled people and we are not beginners. We are an IT company.

What about the implementation team?

We did implementation in-house and we deliver projects for our clients. We have people that passed training in QlikTech.

What's my experience with pricing, setup cost, and licensing?

Day to day cost consists from maintenance fee and we have a man, who is responsible for development of the internal application. But the same man together with other members of BI team are working for the customers. Setup cost was not high. When we started we bought 5 licenses and developed the application in-house, but during the years we have invested in the development of our internal applications. It is a continuous improvement.

Which other solutions did I evaluate?

We have knowledge of Microsoft Analysis Services, Jaspersoft. We sometimes use Jaspersoft as an embedded reporting tool into application. QlikView was nice and easily to learn, so the evaluation period was short.

What other advice do I have?

To do careful requirements analysis, be sure that you have all relevant data available, start the project with somebody, who has an opinion of QlikView.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
AVP at a financial services firm with 10,001+ employees
Vendor
Best In Memory Tool

Valuable Features:

Our business finds this tool very impressive, particularly the drill down to nth level is very good.

Improvements to My Organization:

Yes. we were using BO previously and it took a long time to track particular trade details. In QlikView we get trade level data in seconds.

Room for Improvement:

Yes, Drag and drop of controls. Some geographical charts.

Use of Solution:

I've been using this tool for 4.5 years

Deployment Issues:

None.

Stability Issues:

None as of now.

Scalability Issues:

Sometimes it creates problem when many users log in at same time, but this also depends on your RAM capacity.

Valuable Features:

Our business finds this tool very impressive, particularly the drill down to nth level is very good.

Improvements to My Organization:

Yes. we were using BO previously and it took a long time to track particular trade details. In QlikView we get trade level data in seconds.

Room for Improvement:

Yes, Drag and drop of controls. Some geographical charts.

Use of Solution:

I've been using this tool for 4.5 years

Deployment Issues:

None.

Stability Issues:

None as of now.

Scalability Issues:

Sometimes it creates problem when many users log in at same time, but this also depends on your RAM capacity.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
BI Expert at a tech consulting company with 501-1,000 employees
Consultant
Data discovery, in memory analysis, one development for all devices is very valuable. Can improve in version management.

What is most valuable?

Data discovery, in memory analysis, one development for all devices, ease of use for both developer and end-user

How has it helped my organization?

A proof of concept with the customers data can be done in 1-3-5 days depending on the number of KPI’s and datasources to address.

What needs improvement?

Version management

For how long have I used the solution?

+ 3 years

What was my experience with deployment of the solution?

No

What do I think about the stability of the solution?

No

What do I think about the scalability of the solution?

No, server hardware sizing is very important here.

How are customer service and technical support?

Customer Service: Excellent, good reviews by Gartner as well.Technical Support: Excellent, good reviews by Gartner…

What is most valuable?

Data discovery, in memory analysis, one development for all devices, ease of use for both developer and end-user

How has it helped my organization?

A proof of concept with the customers data can be done in 1-3-5 days depending on the number of KPI’s and datasources to address.

What needs improvement?

Version management

For how long have I used the solution?

+ 3 years

What was my experience with deployment of the solution?

No

What do I think about the stability of the solution?

No

What do I think about the scalability of the solution?

No, server hardware sizing is very important here.

How are customer service and technical support?

Customer Service: Excellent, good reviews by Gartner as well.Technical Support: Excellent, good reviews by Gartner as well.

Which solution did I use previously and why did I switch?

Oracle BI, Microsoft BI, Business Objects XI, Cognos Reason for change: ease of use, speed in building models and applications, price, price and price.

How was the initial setup?

Straight forward, the complexity lies in the creation of the data model using scripting but you can do it step by step and add sources while building, something which is more difficult with classic BI products

What about the implementation team?

We are implementation partner of almost all BI suites.

What other advice do I have?

Do a proof of concept first, seeing is believing.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior Manager of Data Analytics at a tech vendor with 201-500 employees
Vendor
Great for personal productivity and data analysis. Forget it if you just need a reporting tool

What is most valuable?

I think it's the best data analysis/discovery tool I've ever seen.

How has it helped my organization?

I'm currently using it also for my personal and professional productivity: e.g. stock analysis, project management dashboards.

What needs improvement?

It is really missing a comprehensive semantic/metadata layer and security/data profiling can be hard to accomplish at corporate level without a high level of scripting.

For how long have I used the solution?

4 years

What was my experience with deployment of the solution?

Not in the last couple of years

What do I think about the stability of the solution?

Not in the last couple of years

What do I think about the scalability of the solution?

It really depends on your analytics. You have to think and design your documents and/or analytics for large scalability if you think you need something like that.

How are customer service and technical support?

Customer Service: Medium/LowTechnical Support: Medium/High

Which solution did I use previously and why did I switch?

I never replaced a tool with QV in my working experience. For my personal productivity, it mainly replaced excel.

How was the initial setup?

Everything is quite easy and straightforward

What about the implementation team?

We implemented in-house with limited support of the vendor team

What's my experience with pricing, setup cost, and licensing?

Server licence (about 9k USD) + maintenance and a bunch (increasing) of different kind of user licences (average $500 each).

Which other solutions did I evaluate?

Mainly SAS, Microstrategy and Microsoft BI

What other advice do I have?

Well, it really depends on what you're looking for. It's not a reporting product, it's an analysis/data discovery tool and it does it really well.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Business Manager (Exco level) & Executive Director at a retailer with 51-200 employees
Vendor
Start & the rest will follow. Just keep an eye open that design change to a pivot table can be problematic.

Valuable Features:

1) The ease with which self-service BI can be achieved via a small scale trail deployment

Improvements to My Organization:

The company moved from paper based reporting to full dashboard reporting in the Sales function

Room for Improvement:

Very little

Use of Solution:

2 years

Deployment Issues:

None

Stability Issues:

In some cases making a design change to a Pivot table can be problematic if an additional dimension is added to a report that has a “matrix” layout like the following:

Scalability Issues:

None – During a stress test it was able to load 38 million records without any problems on simple dual core PC with ONLY 1 GB OF RAM (absolutely amazing. I would not have…

Valuable Features:

1) The ease with which self-service BI can be achieved via a small scale trail deployment

Improvements to My Organization:

The company moved from paper based reporting to full dashboard reporting in the Sales function

Room for Improvement:

Very little

Use of Solution:

2 years

Deployment Issues:

None

Stability Issues:

In some cases making a design change to a Pivot table can be problematic if an additional dimension is added to a report that has a “matrix” layout like the following:

Scalability Issues:

None – During a stress test it was able to load 38 million records without any problems on simple dual core PC with ONLY 1 GB OF RAM (absolutely amazing. I would not have believed it to be possible but I did the test myself)

Customer Service:

There are frequent follow-ups from the vendor once you register on their web site.

Initial Setup:

Very straight forward for a simple 1 application installation. Just pick 32 or 64 bit and go!

Implementation Team:

Any user can implement a simple 1 application installation, then just follow good communication protocol with the IT team to get access to central data stores and you are away.

Other Solutions Considered:

Silver, Spotfire from Tibco, Tableau Public, MicroStrategy’s free Reporting Suite, Roambi Analytics, Webalo, YellowFin, Jaspersoft

Other Advice:

Just start …the rest will follow…
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
BI Expert with 51-200 employees
Vendor
A powerful user-friendly BI tool with an amazing graphic interface but security is difficult and slow to implement.

What is most valuable?

The graphic interface is amazing, it is also very user-friendly and easy for developers to iterate, modify and evolve it. Due to its "in memory" nature it is very fast and powerful.

How has it helped my organization?

It is a very easy-to-sell product. The value added is huge and the ROI is very high since the projects are done relatively fast.

What needs improvement?

Implement security model for a document can be difficult and slow to implement.

For how long have I used the solution?

3 Years

How are customer service and technical support?

Customer Service: Direct Communication, usually quick responsesTechnical Support: 9/10

Which solution did I use previously and why did I switch?

I have worked basically with CPM tools so this is my first BI tool.

How was the initial setup?

It is very easy to install Qlikview. The important part is to size correctly the servers according to the size of the application and the number of users.

Which other solutions did I evaluate?

In my company we work with many BI tools from different vendors, from SAP and Oracle to Pentaho and Qlikview.

What other advice do I have?

What I have seen is that it's addictive for the users. So if you are an IT manager and you are planning to use another BI tool, try not to show Qlikview to the users or they won´t let you change.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
BI Expert at a consultancy with 10,001+ employees
Real User
Works well when you have the right hardware to support it.
QlikView is a powerful visualization and data discovery tool, and works well when you have the right hardware to support it. I've seen the users getting excited about the tool, and the usage ever expanding in most places, provided the KPIs available are relevant. The tool offers much more capability than simple dashboarding - the natve qvd file formats are excellent if you want to do lots of data cleansing and massaging. Due to this reason, clients can avoid having a separate database license for DWH (please note that QV is not a full fledged DWH, though it supports the most wanted functionalities). QlikView works out to be the best cost effective when the number of users vary between 50 to 250. Users above or below may have its impact on the pricing per user. In a nutshell, it is a…

QlikView is a powerful visualization and data discovery tool, and works well when you have the right hardware to support it. I've seen the users getting excited about the tool, and the usage ever expanding in most places, provided the KPIs available are relevant.

The tool offers much more capability than simple dashboarding - the natve qvd file formats are excellent if you want to do lots of data cleansing and massaging. Due to this reason, clients can avoid having a separate database license for DWH (please note that QV is not a full fledged DWH, though it supports the most wanted functionalities).

QlikView works out to be the best cost effective when the number of users vary between 50 to 250. Users above or below may have its impact on the pricing per user.

In a nutshell, it is a great product to create leadership dashboards setup for any organization size.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultant at a tech consulting company with 51-200 employees
Consultant
Excellent product (if RAM intensive) that is easy to use and delivers on its promises.

What is most valuable?

Ease of development. Data Discovery and Analytics

How has it helped my organization?

Great insight into our data and aides both business explanations and data analysis.

What needs improvement?

Collaboration. Data Input.

For how long have I used the solution?

5 years

What was my experience with deployment of the solution?

None

What do I think about the stability of the solution?

None

What do I think about the scalability of the solution?

Once your user base or applications get large you do need a powerful server with lots of RAM.

How are customer service and technical support?

Customer Service: Excellent and great community interactions as well.Technical Support: Excellent

Which solution did I use previously and why did I switch?

This was our my first in memory data discovery tool. I have used more static reporting solutions such as SSRS, BOXI etc but they are not really a comparable product to QlikView, Tableau or Spotfire.

How was the initial setup?

Very simple, standard desktop installation file and when performing the server install it requires very little Windows Server knowledge.

What about the implementation team?

In house

What's my experience with pricing, setup cost, and licensing?

Depends on licence version purchased an number of licenced users. One off software purchase plus 20% annual maintenance plan.

Which other solutions did I evaluate?

Tableau, Spotfire

What other advice do I have?

It is a great product that is easy to learn. Ensure you still put the necessary work into the "back-end" design as even thought the new breed of BI tools are easy to use, having a well designed data structure behind the model will make the speed and scalability that much better.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user7713
BI Expert at a tech consulting company with 51-200 employees
Consultant
Continues changing, adding more features, improving performance, opening new possibilities
QlikView was born in 1994 in Lund, Sweden. While it was quickly spreading in Europe, it was virtually unknown in the US for many years. In 2000, there were few companies that used this BI tool. (I was lucky to work in one of these companies and learn QlikView in early 2000.) The situation is quite different now. Certainly the product has changed a lot, but the most important features that are responsible for its success remain the same. First of all, the exceptional ease of use. User doesn’t need to learn anything “BI-specific” or any particular technology. If you know how to click – you can use QlikView applications. Well, maybe 15-minute presentation is needed to explain what this particular application is about and how to use it. Second, there is no steep learning curve…

QlikView was born in 1994 in Lund, Sweden. While it was quickly spreading in Europe, it was virtually unknown in the US for many years. In 2000, there were few companies that used this BI tool. (I was lucky to work in one of these companies and learn QlikView in early 2000.) The situation is quite different now. Certainly the product has changed a lot, but the most important features that are responsible for its success remain the same.

First of all, the exceptional ease of use. User doesn’t need to learn anything “BI-specific” or any particular technology. If you know how to click – you can use QlikView applications. Well, maybe 15-minute presentation is needed to explain what this particular application is about and how to use it.

Second, there is no steep learning curve for the developers. After initial training (two or three days), you can create QlikView applications. Not the advanced ones yet, but quite reasonable and useful. The only technical knowledge I consider a pre-requisite is SQL, and you don’t need to be on an advanced level, basic “SELECT … FROM …” is good enough to start from. Even if you don’t know any SQL, you still will be able to develop QlikView applications using wizards that will create simple SQL queries for you. Developer certainly must understand the business needs, and know where to get the data which support business requirements.

Another important advantage of QlikView – it is “in-memory analytics” tool, I believe the first of this kind. All data is in memory rather than on the disk or other storage, and this allows get the results fast. Certainly it was somewhat a limitation in early years because of the limits of 32-bit architecture and memory price. Now with much cheaper memory and 64-bit systems, the “in-memory” applications can handle larger amounts of data than ever before.

Unlike the most (if not all) other BI tools, QlikView does not require data warehouse. Data can be read directly from the original sources, and all ETL work can be performed within QlikView application itself in the data load script and on the front-end level. If a data warehouse exists already, QlikView can use it as well.

Speaking of data sources, QlikView can load data from the variety of the RDBMS (I used it with Sybase SQL Anywhere, Oracle, MS SQL Server), Excel files and many file types including CSV and XML. There is also a proprietary data type, QVD (for QlikView Data) for temporary storage and retrieval, which is extremely fast. In practice, it is not uncommon for one QlikView application to read data from several heterogeneous data sources – multiple databases, maybe even of different types, from QVDs and flat files.

QlikView continues changing, adding more features, improving performance, opening new possibilities. The important event in the company’s history were moving to the US in 2006, and going public in 2010. I guess it is here to stay and increase its market share.

Disclosure: The company I work for is a Microsoft Partner

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6855
CEO with 51-200 employees
Vendor
More than just a pretty face, there is some truly innovative, and very useful technology on offer here
QlikView has more than just a pretty face, there is some truly innovative, and very useful technology on offer here. The company talks of maintaining associations between data, and this facilitates a much more flexible approach to data exploration and visualization. In practice what this means is that users can search available data resources with the knowledge that any relevant items will be retrieved, no matter how disjoint the origins of the various data items. In a way it is almost a merging of enterprise search with BI – something I talked about several years ago. The QlikView Business Discovery Platform provides an enterprise wide solution to the need for information. It embraces IT (instead of alienating it), business users and analysts. This is comprised of three main components –…

QlikView has more than just a pretty face, there is some truly innovative, and very useful technology on offer here. The company talks of maintaining associations between data, and this facilitates a much more flexible approach to data exploration and visualization. In practice what this means is that users can search available data resources with the knowledge that any relevant items will be retrieved, no matter how disjoint the origins of the various data items. In a way it is almost a merging of enterprise search with BI – something I talked about several years ago. The QlikView Business Discovery Platform provides an enterprise wide solution to the need for information. It embraces IT (instead of alienating it), business users and analysts. This is comprised of three main components – the QlikView Server, QlikView Publisher and QlikView Desktop.

  • QlikView Desktop is where the associations between data items are established and where the user interface is laid out for QlikView Apps. An SQL like scripting language is used to create associations for use by business users and analysts.
  • QlikView Server is the engine of the architecture where in-memory processing takes place and where issues such as security are addressed. It also handles communication with clients (web browsers, mobile or desktop) and includes a web server, although Microsoft IIS can also be used.
  • QlikView Publisher loads data from the various defined data sources and distributes documents to the QlickView Server(s) for consumption by users.

Because the users generate their own reports and visualizations IT is left to get on with addressing the infrastructure issues associated with BI, including security, capacity, governance and systems management. The analyst typically uses QlikView Desktop to create the data models users will need. Meanwhile business users are presented with an environment where the data can be viewed as a unified whole, where a rich visualization environment is provided and where needed, QlikView supports extensive collaboration features.

QlikView has clearly thought the whole thing out both conceptually and practically. The net result is that every function in the organization should get what it wants. This is a different, and potentially much more productive, approach to BI. The capability does not extend to data mining or other forms of analytics, and it doesn’t pretend to. The scripting language provides ample means to create highly bespoke solutions to individual organization needs, and as a BI tool it should not run into any dead-ends. QlikView is certainly worthy of serious consideration.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user7503
Consultant at a tech consulting company with 51-200 employees
Consultant
Yet another possibility with QlikView.
I sometimes wonder, haven’t we seen all the possibilities for QlikView? The answer is simple – NO! The other day a client of my, asked if I could build some kind of a data warehouse monitor upon their enterprise data warehouse. This client has a SQL Server data warehouse with QlikView as a frontend. The data in the data warehouse are updated in parallel processes, so data for each country are loaded in different time of the day. They also do ad hoc updates of the data warehouse if needed. They have a nice log table in the SQL Server data warehouse, telling us when each ETL step is updated, and if there have been any errors in a step. However, reading this log is not that easy. Therefore, they asked if QlikView could visualize the data in some kind of a data warehouse monitor. My…

I sometimes wonder, haven’t we seen all the possibilities for QlikView?

The answer is simple – NO!

The other day a client of my, asked if I could build some kind of a data warehouse monitor upon their enterprise data warehouse.

This client has a SQL Server data warehouse with QlikView as a frontend. The data in the data warehouse are updated in parallel processes, so data for each country are loaded in different time of the day. They also do ad hoc updates of the data warehouse if needed.

They have a nice log table in the SQL Server data warehouse, telling us when each ETL step is updated, and if there have been any errors in a step. However, reading this log is not that easy. Therefore, they asked if QlikView could visualize the data in some kind of a data warehouse monitor.

My idea was, why not create a one sheet overview, showing each of the component in the data warehouse architecture and visualize this? I wanted to use red and green icons and arrows showing witch part of the data warehouse is currently under update and if there were any errors to take care of.

I ended with this lovely solution:

I have used text-boxes with images as background, color expressions and conditional show of objects.

Simple, very useful and hopefully a good inspiration.

Disclosure: The company I work for is partners with several vendors

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user7494
Director of IT at a tech services company with 51-200 employees
Consultant
QlikView on the Clouds
With the #cloud and #BigData becoming more relevant for enterprises, there is a lot of interest to explore ways of using QlikView on the Cloud. While discussions on private cloud, public cloud and hybrid clouds are continuing, I would focus on using QlikView on Infrastructure on Cloud in this short coverage. Any enterprise wanting to run QlikView on an off-premise “Cloud” infrastructure can do so by using the QlikView image available on Amazon EC2 cloud. This can allow enterprises to create off-premise, often distributed deployment of QlikView. In essence, running QlikView on Amazon EC2 is very much like running QlikView in-premise. The licenses for QlikView are required to be purchased. The software distribution need not be installed on the Amazon EC2, but a ready-made image of…

With the #cloud and #BigData becoming more relevant for enterprises, there is a lot of interest to explore ways of using QlikView on the Cloud. While discussions on private cloud, public cloud and hybrid clouds are continuing, I would focus on using QlikView on Infrastructure on Cloud in this short coverage.

Any enterprise wanting to run QlikView on an off-premise “Cloud” infrastructure can do so by using the QlikView image available on Amazon EC2 cloud. This can allow enterprises to create off-premise, often distributed deployment of QlikView. In essence, running QlikView on Amazon EC2 is very much like running QlikView in-premise. The licenses for QlikView are required to be purchased. The software distribution need not be installed on the Amazon EC2, but a ready-made image of QlikView already available on the Amazon can be chosen and deployed in no time. Refer how QlikTech uses Amazon to run the Demo environment.

The key aspect is, like any other cloud deployment, data stays in cloud. Where enterprises have their current data in the enterprise data center, then moving the data to the cloud could become a bandwidth intensive exercise. Companies who have data already on EC2 are luckier.

Extraction of data into QVDs from their source, and transferring QVD files over to the cloud server is a good way to optimize bandwidth and storage usage. Even if applications like CRM etc. are already in cloud, they exist in separate service providers, and the data still needs to be transferred to the virtual server where QlikView is running. Bandwidth will still be used for the same amount of data.

Following are some key situations when an enterprise can look at cloud:
1. Quick pilot to be done, without waiting for infrastructure additions
2. Do not want the upfront capital costs for server hardware
3. Need a flexible quickly scalable solution
4. Relatively less amount of incremental data being generated
5. As for security, the features of security discussed in chapter “QlikView Security” are relevant in the cloud deployment as well. Integration with data sources and portals are all the same as the in-premise deployments.

Some of the benefits in using cloud deployments include:
- Zero infrastructure requirements
- Elastic scalability
- Instantly available
- Users are up and running in 15 minutes
- Standard QlikView user license pricing (licenses can be moved from and to cloud)
- Shifts expenses from capital expenditures to operational expenditures
- Platform neutrality - Available through Amazon’s fast and reliable Elastic Compute Cloud (EC2) Web service

Currently, most organizations cannot move completely to cloud, but need a coexistence of in-premise and cloud infrastructure/solutions. QlikView can also be implemented in a hybrid fashion, to take advantage of the cloud benefits. QlikView is not available as a “Saas” or a “PaaS” offering at the moment. OEM offering of QlikView allows OEM customers to custom license QlikView and deploy on a multi-home/multi-tenant servers to offer pay-per-use services. For more information, refer to QlikView Blog: “QlikView and the Cloud - Have it your way” and QlikCommunity discussion “QlikView in the Cloud”.

Integration of QlikView with SalesForce, Workday and other solutions like OrangeScape is possible. Lot of companies who use SalesForce have integrated the QlikView dashboards into the SalesForce portal itself, as a separate Tab. The same is possible with other applications, to embed / integrate QlikView into the cloud front-ends seamlessly.

Integrating employees and extranet users (intermediaries, partners, customers and vendors) is a need in many situations, providing interactive analytics to them. One large global security appliances company has integrated QlikView into their SalesForce interface to provide analytics to their vendors. Implementing Single-Sign-On - using various identity stores is another aspect - where there are challenges. Solutions are emerging through integration partners. Security aspects of this integration need careful planning and execution - require a deep understanding of what is possible. Also the various deployment options need to be kept in mind while planning a cloud integration. I have treated these at length in my book.

With more and more cloud solutions emerging, integrating QlikView on Cloud and offer as a cloud SaaS is slowly emerging as a solution of choice, among the Cloud SaaS providers. More movement of QlikView to the cloud is a natural progression I believe.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user7491
Director of Development at a manufacturing company with 51-200 employees
Consultant
Big Data – Qlikview (Allies or Foes)
“Big Data” as it is generally defined as: A large voluminous, fast changing, multi-structured dataset, generally distributed in nature, non-EDW compliant (mix of RDBMS/non-RDBMS) dataset Due to the nature and flow of data, it has associated issues and complexities like performance, governance and analytics etc… In general discussions, “Big Data” term is generally used analogous to Hadoop infrastructure, but in this discussion, we will assume Big Data as a principle rather than a current technology/solution. “Qlikview” on other hand, is In-memory Business Intelligence Solution able to handle very large datasets and advocates its user friendliness and intuitiveness, shorter development cycles and analytical capabilities among other things… Now once, Big Data/Qlikview…

“Big Data” as it is generally defined as:

A large voluminous, fast changing, multi-structured dataset, generally distributed in nature, non-EDW compliant (mix of RDBMS/non-RDBMS) dataset

Due to the nature and flow of data, it has associated issues and complexities like performance, governance and analytics etc…

In general discussions, “Big Data” term is generally used analogous to Hadoop infrastructure, but in this discussion, we will assume Big Data as a principle rather than a current technology/solution.

“Qlikview” on other hand, is In-memory Business Intelligence Solution able to handle very large datasets and advocates its user friendliness and intuitiveness, shorter development cycles and analytical capabilities among other things…

Now once, Big Data/Qlikview introduction is clear, let’s see these two bit closely and together

Following charts generally lists 3 aspects of Qlikview/Big Data

  

Big Data

Qlikview

Configuration

Distributed

It is distributed in nature…
b) Multiple Filesystems
c) Multiple OS

Traditionally Single instance of Qlikview Application is
a) Single Server
b) Single OS

Properties

Volume

Very large Volume (terabytes or more)

Large Volume (20-100 of Gigabytes is not unheard of)

Velocity

Data speed is varied, based on operation… Click Stream data, RFID data is real time

Data Frequency(speed) is generally mini-batch with small delays

Data is generally pre-defined datatype, and most of datasets in general occurrence is Date, text, numbers etc.

Implication

System

Generally data is large for a single DB/Filesystem to handle, so data is generally distributed across a number of systems.
FYI – The system hides this complexity from end-user
Datasize is unlimited in this case

Generally data from multiple datasets, since memory based, it is limited by max memory applicable on server

Data Relationship

Dataset is traditionally non-EDW (images/videos/blogs/web logs etc)

Generally a Dimensional model

With big data comes, problems like performance, management and analytics.
There are tools which are improving in these areas

In memory solution, allow fast performant reporting and analytics user response

Quite obvious there are number of ways, where the systems are designed differently and surely for different purposes, Does it make Qlikview and Big Data as non-compatible solutions or two applications with own strengths and perfect partners when used in conjunction can deliver solution the business needs?

The answer of this question lies in answering the bigger question… “What does business wants and what does IT have?”

With more and more mountain of information flowing in and new nomenclature becoming more common in regularly use. (Mega/Giga/Tera) being now replaced by (Peta/Exa/Zetta). New technologies and more processing power coming to fore, surely underlining the validity of Moore’s law.

What is more important is not what this data holds, but what useful or relevant information it has and which can be used efficiently. Information is Gold; it has to be treated that way. But while looking at information, we need to understand and look at another analogy, which comes from mining of precious metals. While searching for Gold, it is not like that miners find the strips of Gold and they don’t. It is more likely that Gold may not be visible to naked eye and need sophisticated processes to find and process Gold. A terminology Strip Ratio (1 ppm for Gold) defines amount of waste need to be processed to find area of your interest

So new technologies allow exposure to more and more data with different “strip ratio” and to make it as information, as John mentioned in this article Qlikview and Big Data: It’s all about Relevance. The information is about relevance, having more and more information on users desk or computer, will not make users any more capable and knowledgeable and geared toward making right decisions, but what is needed, an organized, structured view on that information set, where information which is relevant to the user is presented in way, the user can utilize.

Major critics of In-memory based solution generally come out with this argument – “Memory/Hardware/OS Limitation” and hence its (Qlikview) in-ability to handle this Big Data in single application.

Picking the comparison from Big Data itself, technical reasons were governing reason of distributed nature and Architecture of Big Data.

I see no surprise if same principle is applied across BI and Analytics with distributed Apps as answer to it, with Business driving the data distribution split rationale.

As ideally Business doesn’t need a single application, showing them universe of data, but wanted to see the data of their universe in single forum, so on top of well distributed dataset, there can be array of Qlikview apps serving specific business needs or drive.

So revamping some of the definitions:

Hadoop (HDFS) – Data is being global, distributed and varied and large, it is split into multiple subsets, location and copies for multiple usage…

Qlikview (BI) – Information is being global, distributed and varied and large, it is split into multiple apps, location and copies for multiple usage…

The new world order

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user7488
Developer with 51-200 employees
Vendor
BI Tool Rant: Qlikview Pie Charts
This posting is the first in a subset of posts I plan to make on this site that I can use as my method of stress release in regards to general frustrations with business intelligence tools and all related subject matter. In terms of BI tools I can not say that I align myself to any single software. They all have their own strengths and weaknesses and it’s a combination of that matrix of features (or lack thereof) along with the context of the business implementation that needs to be considered when picking a tool to investment. That being said let me get back to my rant… IF YOU LOVE PIE CHARTS DON’T USE QLIKVIEW! Okay, okay let me elaborate on such a strong claim. On a recent piece of work that I had done for a client they had wanted to utilize a portion of their dashboard with a…

This posting is the first in a subset of posts I plan to make on this site that I can use as my method of stress release in regards to general frustrations with business intelligence tools and all related subject matter. In terms of BI tools I can not say that I align myself to any single software. They all have their own strengths and weaknesses and it’s a combination of that matrix of features (or lack thereof) along with the context of the business implementation that needs to be considered when picking a tool to investment.

That being said let me get back to my rant…

IF YOU LOVE PIE CHARTS DON’T USE QLIKVIEW!

Okay, okay let me elaborate on such a strong claim. On a recent piece of work that I had done for a client they had wanted to utilize a portion of their dashboard with a pie chart that would show the breakdown of possible values for a particular field. The pie chart was actually quite cool to see. It drew the correct relationship. It gave the pie chart one of the 3D angled views. The thing it couldn’t do? It couldn’t label the chart inside the pie slices! I could show percentage breakdowns, counts for each value, and have any dynamic label I wanted AROUND the pie chart – but trying to put the details within the slices cued up the “Impossible Dream.”

So is there a workaround for something that isn’t second nature with the application? Well there is a solution per say. Option A would be to possibly add a text label within the chart and try to position it within the slice. Each text label would show the percentage for a certain value. The issue is that as your pie chart changes there wouldn’t be a guarantee that your static label would be sitting in the correct spot. Option B would be to use some kind of macro or javascript plugin that would relocate the label – but now you’ve added custom macro codings for a LABEL. *Insert a headshake here*

Qlikview has a lot of power behind its engine and can offer many ways to illustrate your data. The warning is to do a bit of research and try to browse through different Qlikview demos to see the strongest visualizations. Or hire a web developer.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user7161
Consultant at a consultancy with 51-200 employees
Consultant
Managing QlikView Server Without a Publisher
I have many clients who are using QlikView Small Business Edition or Enterprise Edition without Publisher. I'd love for them to add Publisher because I HATE HATE HATE managing file permissions in windows. I love that publisher automatically distributes QlikView documents to the User Documents folder and I can easily change who will receive each file right from the Management Console AND I don't have to remote into the server to do it Ok, time to end this publisher love-fest and time to get down to the business of designing our security environment when you don't have publisher. I'm writing this post because I spent a good chunk of the other day fixing a problem we had that was caused by a goofed up security configuration(This is called learning from experience because I goofed it…

I have many clients who are using QlikView Small Business Edition or Enterprise Edition without Publisher. I'd love for them to add Publisher because I HATE HATE HATE managing file permissions in windows. I love that publisher automatically distributes QlikView documents to the User Documents folder and I can easily change who will receive each file right from the Management Console AND I don't have to remote into the server to do it

Ok, time to end this publisher love-fest and time to get down to the business of designing our security environment when you don't have publisher. I'm writing this post because I spent a good chunk of the other day fixing a problem we had that was caused by a goofed up security configuration(This is called learning from experience because I goofed it up). So after banging my head on the wall trying to figure it out I thought it would be a good idea to share with the interweb.

Here is my use case...

I work for a company who has 25 Named user CALS and 100 Document CALS(Probably not an important detail) There are several departments using QlikView Dashboards Each department includes sensitive data in their Dashboards so they must remain private to the department. There is also a Corporate Dashboard used by the C Suite and the CEO often uses the department dashboards to explore information about some key clients.

Our data is built by first extracting data from the source databases into QVD files. Dimensions are conformed and key fact tables are also built in QVD format. The Conformed Dimensions and Facts are combined into data models based on user requirements and finally the data models are binary loaded into the user applications and presented on Access Point.
A three tier data flow model provides the framework needed to present clear and consistent data to all your applications.

So let's start planning. We want to set up a folder structure to use in our Small Business Edition server to manage user access to their documents, and provide organization for our ETL framework, remember we don't have publisher. Obviously we can get very complicated with this but for the sake of explanation I'm going to make a single directory our starting point, I'll call it "QlikWarehouse".

Applications The Applications folder contains our user facing QlikView documents I always add one folder for each application and I design my security around those folders. You should create a "QlikView Users" group in active directory and assign read/write access to the Applications folder. Then you will override inheritance for "QlikView Users" on the application specific directories and grant read/write access to a group that corresponds to the folder for that application. In the QEMC you will set the Applications folder as the "Root" folder, when you do this the QlikView Server will add several files in the Applications folder, if your users do not have read/write access to these files then they will see login failure errors and you'll get to bang your head on the wall to figure out the problem.

Load Scripts Load scripts is added to the QlikView environment as a mapped meta folder. Mapping it into the QEMC will allow you to set the reload schedule for your data. It is essential that your users do not have access to this folder. If they do you will be exposing documents to the users that will not have any data in them and probably cause nothing but confusion for your users.

Data Most of the files in the data directory will be QVD files but you must map it because the data model files will live in here but just like the load scripts your users should not have access to this directory.

Active Directory security settings needed to manage your QlikView SBE deployment.

Following this kind of configuration will allow you a couple of advantages.

Management Got a new Application? Create an AD group to go along with it and make it a member of Qlikview Users.

Simplicity Users only see the applications that they have access to, period.

Compatibility This structure is compatible with publisher so if you do decide to expand your Qlikview footprint you'll be ready to go. It won't be a turnkey deployment but this structure is close enough to adapt to the Source Docs/User Docs division in publisher.

I'd like to encourage comments since this is just what I've been doing when I deploy a server, any suggestions, criticism or praise(especially praise) is welcome.

A quick note on the images in this post, I would like to give credit where it is due. Many of the individual icons have been clipped from various presentations I have received from Qliktech however the overall diagrams are my creation(even if not terribly creative).

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6894
Consultant at a tech consulting company with 51-200 employees
Consultant
QlikView Enterprise Deployment
PART 1 --------- QlikView is a great business discovery tool that can easily generate excitement among business users. However, to build out a QlikView system that can support tens, hundreds, or even thousands of users is no easy task. As a QlikView consultant I have seen these scenarios many times: - A business analyst is eagerly showing an IT manager the beautiful dashboards he/she builds in QlikView, and can’t wait to show the dashboards to hundreds of internal and external users; - A business executive wants all business users to self-service their information needs through a QlikView platform. Often times the IT managers seem to be less excited than their business counterparts. To be fair, in order to build a solid system, IT managers have a lot of questions that…

PART 1
---------
QlikView is a great business discovery tool that can easily generate excitement among business users. However, to build out a QlikView system that can support tens, hundreds, or even thousands of users is no easy task. As a QlikView consultant I have seen these scenarios many times:

- A business analyst is eagerly showing an IT manager the beautiful dashboards he/she builds in QlikView, and can’t wait to show the dashboards to hundreds of internal and external users;
- A business executive wants all business users to self-service their information needs through a QlikView platform.

Often times the IT managers seem to be less excited than their business counterparts. To be fair, in order to build a solid system, IT managers have a lot of questions that need to be answered. Let’s take a look at the most commonly seen ones (I have to warn you it’s a bit technical).

-- VMware for the servers? --

Nowadays most IT infrastructure professionals are in love with Virtual Machines (VMs). With its lower cost and flexibility in terms of horse power, VM seems to be the way to go for all enterprise applications. Well this is almost true for QlikView. All components of QlikView services can work fairly well on VM except for QlikView Server. This is because QlikView Server does the heavy lifting in-memory data processing, and the extra VM layer is going to slow it down, a lot. Most seasoned QlikView consultants would recommend at least using a physical machine for the production QlikView server.

-- Separate Publisher from Server? --

The two most important components in a QlikView system are the QlikView Server and Publisher (aka Distribution Service, I am a QlikView veteran so I will stick to the old name). Most people install all components on the same machine but as your data volume and user base grow, people frequently see these two components getting in the way of each other. At this point, it might be a good idea to put Publisher on a second machine (by the way, that second machine could be a VM). The good news is you can still manage both the QlikView Server and Publisher from a single QlikView Management Console (QMC).

-- QlikView Web Server or IIS? --

QlikView comes with its own web server, which is a light version of Microsoft Internet Information Service (IIS). In a perfect world, where all users are Active Directory users, and the number of users is small, QlikView’s web server works pretty well. For a large user base deployment you might want to choose to use IIS because it’s more scalable. IIS also gives you more security options.

-- Security Integration --

Security is always a big issue in an enterprise. Typically security includes authentication, which is about making sure a user is who he/she claims to be, and authorization, which is about letting the user see only what he/she is allowed to see. In the real world, we often see QlikView Publisher and Section Access can handle authorization pretty well, while the authentication is a bit more complex. This is because QlikView does not do authentication itself, it always relies on third-party authentication like NTLM, SiteMinder, WebSeal, etc. This process is also known as Single-Sign-On (SSO). This normally plays well in an enterprise because usually there is already a standard authentication product in place. The good news is, if the existing standard authentication product happens to be NTLM/Active Directory, QlikView can work with it out-of-box with no additional configuration. Otherwise, the third-party authentication product needs to inject the user id into http header and QlikView needs to be configured to read user id from http header. If the QlikView Servers are also accessed by outside people, it might be a good idea to setup a reverse proxy.

I hope by now you get a sense of the extra “behind the scenes” efforts that are necessary to make your QlikView system successful. In my follow up blog, I am going to talk more on topics such as high availability, storage, and running load tests.

PART 2
---------
In my last “QlikView Enterprise Deployment” article, I discussed VMware, the benefits of separating Publisher from QlikView Server, the choice of QlikView web server vs IIS, and security. However, there is more to consider in making your system solid.

-- High Availability --

The QlikView deployment has been so successful, people cannot live without it anymore. All of a sudden IT’s are victims of their own success. People are demanding high availability and high performance of the QlikView system, which of course will make the system more complicated. QlikView Servers need to be put on more than one machine, and a load balancer needs to be put in front of these machines. QlikView Servers also need to be clustered. By doing this, if one server is down the load balancer will stop sending users to this server. Users also enjoy a better response time because they are spread across multiple QlikView Servers.

The same concept also applies to Publisher. I have seen customers trying to get many dashboards refreshed (e.g., month-end or quarter-end) in a short timeframe. It might be a good idea to also install Publisher on multiple machines and cluster them. If one Publisher goes down, QMC will wait for it to be back to normal before sending data refreshing tasks to it again. In the meantime, QMC keeps sending tasks to the good Publishers and nothing gets interrupted.

-- Storage --

A lot of QlikView Servers objects (sessions, shared objects, bookmarks, licensing information, etc.) are stored in a set of system files. When QlikView Servers are clustered, both servers read and write from the same set of system files, which can cause contentions. Some people would use one of the QlikView server’s hard disk as the storage for these system files. This is normally fine except that when that server is down, the good servers cannot work either because the storage location is not there anymore. The best configuration we have seen is to use a SAN owned by a third windows server as the storage, and that windows server can be a VM.

-- Load Tests --

Every component of your QlikView system is properly configured and it looks like it’s ready to go. But wait, how can it be sure the system can support the desired user load and data volume? The only way to find out is to run load tests. QlikTech offers a great tool that is based on JMeter and it is relatively easy to setup. The tool can automatically generate JMeter scripts based on specified testing scenarios, and it can simulate any number of concurrent users. The testing results can be loaded into QlikView for analyzing. Of course, if the company has a strong load testing team that uses other tools like LoadRunner, you can also use your own tool to perform a load test.

These are the most common things people consider in an enterprise deployment. I hope you enjoyed reading it as much as I enjoyed writing it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6891
Recruiter with 51-200 employees
Vendor
Qlikview compared to other BI Tools
Qlikview is one of the older names in Business Intelligence software since it’s been around since 1993. It’s known as being particularly easy to learn, which is important for quickly training employees and getting them up to speed. Business intelligence tools are applications that deal with Business Objects and that help with analysing and presenting data. For the most part, a BI tool will be working with data that’s already been in-putted into a system, and you’ll simply be using the BI application to work with that particular data set, though there are exceptions. The best business intelligence software for you though will depend on what you need, since there are many pros and cons of various BI programs. -- Cons -- Qlikview has strong features all around, but there are other…

Qlikview is one of the older names in Business Intelligence software since it’s been around since 1993. It’s known as being particularly easy to learn, which is important for quickly training employees and getting them up to speed.

Business intelligence tools are applications that deal with Business Objects and that help with analysing and presenting data. For the most part, a BI tool will be working with data that’s already been in-putted into a system, and you’ll simply be using the BI application to work with that particular data set, though there are exceptions. The best business intelligence software for you though will depend on what you need, since there are many pros and cons of various BI programs.

-- Cons --

Qlikview has strong features all around, but there are other clients that tend to be somewhat better when it comes to certain features. For example, Tableau actually has a free reader integrated into it, which makes offline viewing considerably easier than the limited viewing capabilities while offline that Qlikview has.

Qlikview also struggles when it comes to integrating GIS data, which can be pretty important for topographic and geographic analysis and presentation. Other programs having mapping abilities integrated into the client, for example. Qlikview also struggles when it comes to multidimensional support, and support for things like xVelocity or Power Pivot.

While Qlikview excels in ease of use, there are many alternatives out there like Tableau and OLAP that tend to be better at analysing data in a deep and thorough way, and with support for all of the other applications and data sets that you may need.

-- Qlikview Pros --

An advantage of Qlikview is that it takes a very small amount of time to implement. It’s even better at this than other similar software such as Tableau. Another advantage that Qlikview has is that it has a significantly larger Partner Network than many of the alternatives.

Additionally, Qlikview has development scripting that tends to be superior as well. The 64-bit in-memory of Qlikview is among the best of any software BI package period. Qlikview has good interactivity with the UI, solid visual controls, and extensive compatibility with both web clients and especially with mobile clients. Qlikview also has considerably more mature features when it comes to data interactivity and visual drilldown as well. It’s easier to deal with the visualization aspect of the program than almost any of the competitors, including Tableau.

The best feature for Qlikview tends to be the visual drill down which it just does better than any other client. You can hardly go wrong with all of the extras Qlikview like MDI support, as well. The software shines when it comes to ease of use and learning curve. If you need to implement a BI solution fast and without hassle, Qlikview is often the best way to go.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6888
Consultant at a tech consulting company with 51-200 employees
Consultant
What’s So Great About QlikView in the iPad World?
Disclosure: I work for a company that is a partner with QlikView, SAP BusinessObjects and Microsoft. As a non-Apple using professional (we are becoming less in numbers) I have always leaned further to the Android side of the mobile world. As a QlikView professional, most of my experience is on Windows desktops, laptops and servers and in previous years involved less interaction with what many people believe to be the greatest gadget(s) in the world. So enter the iPad and QlikView V11.0.11426.0 SR2. Day one, the first step was simple, get to the QlikView Access Point. Open the browser, navigate to my access point and sign in. Outside of the search for the “\” key (domain\userid) that all went well. The first question you are presented with after getting to the access point is…

Disclosure: I work for a company that is a partner with QlikView, SAP BusinessObjects and Microsoft.

As a non-Apple using professional (we are becoming less in numbers) I have always leaned further to the Android side of the mobile world. As a QlikView professional, most of my experience is on Windows desktops, laptops and servers and in previous years involved less interaction with what many people believe to be the greatest gadget(s) in the world.

So enter the iPad and QlikView V11.0.11426.0 SR2. Day one, the first step was simple, get to the QlikView Access Point. Open the browser, navigate to my access point and sign in. Outside of the search for the “\” key (domain\userid) that all went well.

The first question you are presented with after getting to the access point is would you like your default in full browser mode or small device mode. iPad is full browser. No question. I’m not a big fan of the small device mode unless the application was really made for phone use. The full browser mode gives you the full experience but beware: if the application was not developed for a smaller device, selection and navigation can become difficult. If you want your users to spend their time using the application, rather than zoom in, selecting, zoom out…repeat, follow some simple design rules from QlikView site:

- It is recommended that QlikView applications are designed for 980 x 590 with a tab row, and 980 x 610 without a tab row. This is a rule of thumb and depends on many things including the version of iPad your audience is using. I found myself struggling to keep the application down to this limit and expanded it slightly after thorough testing in a “no-tab” application.
- Use Arial or other font faces that are supported in iPad browser. I got lucky because my client gave me two options for font based on their creative team, one of which was supported.
- Font sizes – minimum 11pt. Good for most users. Someone with large hands will still probably struggle a bit selecting a specific line item but they probably struggle with most touch screen applications. I did cut this down to 9 and 10 pt sizes for informational only text areas that were non selectable.
- No Mouse Over Options – No mouse, not an option.
- There are some additional tips that I recommend you review but ultimately just keep in mind what you are designing for.

So now I am having enough fun with this that I really want to start testing out existing applications, some designed for mobile and some not. Unfortunately my lack of attention span kicked in and I was diverted over to the Apple Store to discover QlikView for iOS.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6870
Consultant with 51-200 employees
Vendor
Impressions from Tableau in comparison with QlikView
I had the chance to get to Tableau Customer Conference in early November 2012 and thanks to exceptionally good organization of the event I was able to greatly enhance my picture of Tableau (which I first reviewed 2 years ago) and get answers to some questions. Below are my impressions from Tableau (which I haven't used in real projects yet) in comparison with QlikView -- tool I've been working with since 2009. First thing I'd like to tell -- starting from version 8 Tableau can honestly be considered a truly mature product -- a big difference with what I saw two years ago. It's a smartly designed, feature-full and powerful analytic tool which is especially good for ad hoc query and analysis (Q&A). Prior to Tableau I considered BusinessObjects WebIntelligence to be the best Q&A tool on…

I had the chance to get to Tableau Customer Conference in early November 2012 and thanks to exceptionally good organization of the event I was able to greatly enhance my picture of Tableau (which I first reviewed 2 years ago) and get answers to some questions.

Below are my impressions from Tableau (which I haven't used in real projects yet) in comparison with QlikView -- tool I've been working with since 2009.

First thing I'd like to tell -- starting from version 8 Tableau can honestly be considered a truly mature product -- a big difference with what I saw two years ago. It's a smartly designed, feature-full and powerful analytic tool which is especially good for ad hoc query and analysis (Q&A). Prior to Tableau I considered BusinessObjects WebIntelligence to be the best Q&A tool on the market. However, in my picture of BI world this honorable title now belongs to Tableau.

Here is what I liked (not in order of importance):

- State-of-art data visualization makes Tableau outstanding in the crowd of BI suites. Tableau people talk about "being creative with data" and it's easy to believe in this while looking at clean and elegant Tableau dashboards. By the way, in French tableau has two meanings -- painting and table. Artwork and data. Excellent match of brand and product concept.

- Drag-n-drop authoring as cornerstone of analysis and design processes. That's what WebIntelligence was good at, but Tableau makes it even better, simpler and easier. Sadly QlikView has almost nothing to offer here -- fields still...

Read the rest of the post at http://bi-review.blogspot.co.il/2012/11/impressions-from-tableau-in-comparison.html

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6867
Partner at a tech consulting company with 51-200 employees
Consultant
When is the best time to implement Business Intelligence?
When is the best time to implement Business Intelligence? Many of our clients still operate with outdated ERP legacy systems. The common complaint we hear is “I cannot get access to the information that is stored in my ERP system!” Most commonly, issues are due to the fact that when these systems were built, paper-based reporting was still dominant. That is not the case anymore. --A New Approach to Reporting-- There are ways to solve data access and reporting issues today without having to go through a costly conversion to a new ERP system. Today a number of new software products are available that are relatively easy to deploy. These tools can put the power if information in the hands of users. -- QlikView -- We recently reviewed one such product from QlikView. This…

When is the best time to implement Business Intelligence?

Many of our clients still operate with outdated ERP legacy systems. The common complaint we hear is “I cannot get access to the information that is stored in my ERP system!”

Most commonly, issues are due to the fact that when these systems were built, paper-based reporting was still dominant. That is not the case anymore.

--A New Approach to Reporting--
There are ways to solve data access and reporting issues today without having to go through a costly conversion to a new ERP system.

Today a number of new software products are available that are relatively easy to deploy. These tools can put the power if information in the hands of users.

-- QlikView --
We recently reviewed one such product from QlikView. This Business Intelligence (BI) vendor got its start in Sweden in 1993. Today they have over 27,000 customers worldwide.

Our client still uses a legacy system they implemented 20 years ago and struggles to manage the business with poor information. The information they access often takes hours to assemble.

This BI product easily attaches to the client’s various data sources: the old legacy data files, Excel files, Access files and more. The data files can be linked. The user, through a series of wizards, can easily construct displays of the data.

-- A Cube of Data --
What we saw during the system review was the access of a “cube” of data. The system organizes the cube by dimensions and the user can “slice and dice” the information by the various dimensions: dates ranges, customers, products, territories and more.

In this demonstration we viewed a dashboard that showed tabs across the top:

- This year YTD compared to last year YTD
- KPI’s over time
- P&L
- Cash Flow
- Budgets
- Trends

The user could click to the tab, and then select the dimensions they wanted to look at.

The user can add notes to the dashboard for other users to view. Also, the user can share a view of the dashboard to other members of the team at no addition license cost. This increased insight aids in overall business process improvement.

-- Unlocking Data --
Over the years, our independent ERP consultants have found BI to be an effective route to unlocking information. By getting information into the hands of the users, companies achieve benefits that can then be used to fund the transformation to modern ERP. The BI system you deploy today can ease your transition to modern ERP implementation and is compatible with your data today and your data tomorrow.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6861
Consultant at a tech consulting company with 51-200 employees
Consultant
What QlikView Consultants can learn from the A-Team
Growing up in the 80′s and 90′s, one of my favorite TV shows was the A-Team. Over-the-top, cartoonish action with huge explosions, cars flipping over in mid-air topped off with a cool theme song. And all without anyone getting seriously hurt. This was the perfect TV show for young Barry! But I’ve grown up since, and my tastes have matured (somewhat). However, there is one thing about the A-Team which I think is still relevant today: the actual A-Team and the well-balanced blend of skills of its members. No matter what an episode’s villain (drug king-pin/shady land developer/corrupt senator/whatever) threw at them, the combined qualities of the A-Team always ensured that they came out on top. In today’s post, I am going to take a closer look at the skills and qualities of the A-Team,…

Growing up in the 80′s and 90′s, one of my favorite TV shows was the A-Team. Over-the-top, cartoonish action with huge explosions, cars flipping over in mid-air topped off with a cool theme song. And all without anyone getting seriously hurt. This was the perfect TV show for young Barry!

But I’ve grown up since, and my tastes have matured (somewhat). However, there is one thing about the A-Team which I think is still relevant today: the actual A-Team and the well-balanced blend of skills of its members. No matter what an episode’s villain (drug king-pin/shady land developer/corrupt senator/whatever) threw at them, the combined qualities of the A-Team always ensured that they came out on top.

In today’s post, I am going to take a closer look at the skills and qualities of the A-Team, and will explain how they can be translated to the role of a QlikView Consultant. (Or, alternatively, how these roles can be used to staff the perfect QlikView Competency Center.)

-- B.A.: Technical genius and a pragmatic attitude --
Let’s start with the character every kid in my class wanted to be: Bosco “B.A.” Baracus. Forget about the kick-ass hand to hand combat skills and bad temper, as a QlikView Consultant, it’s B.A.’s technical genius that you’ll want to emulate.

Invariably, the A-Team will get pinned down somewhere (usually a barn) by the episode’s bad guys. What follows is a 5 minute montage in which B.A. welds together an entire armored vehicle out of scrap metal. In the next scene, we see the A-Team using this vehicle and some make-shift weapons to defeat the villains. (Who, for some reason, never see this coming, despite the A-Team using the exact same tactic in every single episode)

For a QlikView Consultant, the takeaway is that you should strive to continually improve your technical skills. Besides that, when the situation calls for it, you need to be able to keep your head down and do the work. Doing the work is a lot easier when you have the right tools, in this case not an acetylene torch, but a toolbox of scripts and solutions (either your own, or a third party one such as QlikView Components or QlikView Addict’s Codebox) that you can use to quickly build a solution in a modular, maintainable manner.

-- Murdock: Analytical skills and general knowledge --
Don’t let the goofball impression of H.M. “Howling Mad” Murdock fool you. While he may seem to not be all there, he is in fact a deep and analytical thinker.

Every episode sees Murdock obsessing over a new subject, historical character or object. This greatly annoys B.A., who refers to Murdock as a ‘crazy fool’. (in reality, even though B.A. will never admit it, they’re the best of friends) Despite his strange behavior, throughout the series, it becomes clear that Murdock is an analytical thinker, has a broad general knowledge and is very aware of current events and trends in the world. More than once do his brilliant, out-of-the-box ideas save the team.

While as a QlikView Consultant you’ll probably want to avoid the “raving madman” association, in my opinion, you do need to possess some of Murdock’s analytical and out-of-the-box thinking skills. Not only to apply them to your client’s projects, but also to periodically apply them to your own way of working. There are always ways in which you can improve.
Besides purely analytical skills, you also need to have a broad general knowledge of business processes and functions, as well as general market trends. Technical proficiency may be mandatory to get the job done, but real value is added when you understand the client’s business and market, and because of this, his/her problems and needs. There’s nothing wrong with ‘obsessing’ a little over a new field of knowledge if it helps you become more effective and efficient.

Combining the skills and knowledge of BA and Murdock leads to a T-shaped profile that I believe comes very close to the ideal profile for a QlikView Consultant; a deep, technical understanding of QlikView and peripheral methods, technologies and skills, combined with sound analytical skills, business knowledge and a broad general knowledge. As your experience grows, both the base and the roof of the T become broader and deeper, adding extra value for your clients and making you a more all-round professional.

Of course, we still have two more characters left, and as we’ll see, their skills and knowledge are just as important.

-- Face: Communication skills and persuasion --
Templeton “Faceman” Peck is the A-Team’s suave and smooth-talking con man and womanizer. He is always able to procure whatever supplies the team needs to get the job done.

The superiority of Face’s ability to convince others is demonstrated by the fact that he is able to break Murdock out of the same military hospital in almost every episode. Even after hundreds of successful escapes, each time using the exact same approach, he is still able to convince people that they should let Murdock leave with him. That’s an impressive display of persuasion, rivaled only by the Jedi mind trick.

Of course, womanizing and duping people aren’t really things you should be doing in a professional environment. However, as a QlikView Consultant, you will want to take at least a few pages from Face’s book. You can have best the best technical and analytical skills in the world, they’re useless if you cannot clearly communicate your ideas and are able to rally people around your cause.

Whether it be gathering requirements, getting access to various resources, designing interfaces, presenting your business case or just plain office politics (unfortunately a reality in many organizations), having excellent verbal and written communication skills and being able to present a convincing argument will greatly increase your effectiveness as a consultant.

-- Hannibal: Project management and leadership --
John “Hannibal” Smith is the leader of the A-Team. He is a master tactician, planning for every contingency and always ensuring that “the plan comes together”. His leadership ensures that the team is directed towards the common goal.

He also likes to wear very bad disguises, but nobody’s perfect.

One of the reasons for Hannibal’s continued success is the formulaic approach he takes to his projects. Every episode of the A-Team roughly plays out the same:

Bad guys harass innocent victims → Victims hire A-Team → B.A. says he won’t go on no plane → B.A. gets drugged and is put on the plane → A-Team confronts villains about their dastardly deeds and urges them to stop → Bad guys ignore the advise, take the A-Team by surprise and lock them up → A-Team builds weapons from scrap metal, escapes and beats up the bad guys in a fist fight → Villains go to jail → Credits roll.

You may find a lot of faults in Hannibal’s plan (I certainly see a few) but at least he is following some sort of methodology and he consistently delivers within the agreed-upon 60 minute timeframe. As a QlikView Consultant, you should also be following a consistent methodology to deliver your projects. I prefer to use Scrum, but any method will do, as long as it follows a predictable and consistent process that results in quality output delivered in a timely manner, with the end result meeting the client’s expectations.

Besides Hannibal’s project management skills, the most important takeaway for the QlikView Consultant is his leadership and focus on the end-result. Hannibal is really the one who brings the plan together, by keeping the team together. Without Hannibal, the individual qualities of the A-Team’s member would become unproductive; impulsive action (B.A.), paralysis by analysis (Murdock) and cheap talk (Face). Hannibal ensures that the team maintains just the proper blend of skills and qualities to get the job done, every time.

-- I love it when a plan comes together --
And that’s how I think the skills of the individual A-Team members relate to those of an ideal QlikView Consultant. Unfortunately, like the A-Team, consultants that actually meet this ideal combination of skills and traits are very hard to find. Often one specific ‘personality’ will be more present than others. As a consultant, once you’re aware of this, you can work on developing the other qualities. The Magic A-Team Quadrant (shown below) can be a very useful tool to assess yourself, or your team.

[To see the diagram go to: http://www.qlikfix.com/2013/03/26/what-qlikview-consultants-can-learn-from-the-a-team/]

Besides the ‘All-round QlikView Consultant’, the obvious hero of this story, I’ve added two profiles that I often encounter:

- The IT Consultant: has great technical skills, but has problems understanding the business context of what they are doing. Often delivers exactly what the client asked for, but not what they need. Applications tend not to be used after they leave.
- The Business Analyst/Management Consultant: knows exactly what the client needs, but has problems delivering a technically sound solution. Applications tend to fall over after they leave.

Where are you? And where are you going? Would be very interested to hear about your thoughts in the comments.

PS. Should you be based in the Netherlands and either feel that you already meet the ideal profile, or aspire to attain it; I’m hiring. Drop me a line and let’s chat. And no, unfortunately there is no company van :)

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6858
BI Expert with 501-1,000 employees
Vendor
Real-time Data Collaboration
Yesterday, I had a very nice meeting with the folks at Qlikview (thanks, @DHurd11 & Andy for making the trip). They partnered with a local DC consulting firm by the name of Tandem Conglomerate. I had the pleasure of working with Ben Nah from Tandem Conglomerate last year – and I can vouch that their talent is top-notch. Qlikview is smart to find partners of this caliber – and utilize them to better serve their customers. As a technologist, I always have my eyes open to exploring new technology. This is always challenging with long term contracts, university politics, and an ever-changing IT landscape. However, for me, vendors have to prove why they should remain at the top. Competition is healthy for everyone as it makes us constantly improve. I should also say that as long as we…

Yesterday, I had a very nice meeting with the folks at Qlikview (thanks, @DHurd11 & Andy for making the trip). They partnered with a local DC consulting firm by the name of Tandem Conglomerate. I had the pleasure of working with Ben Nah from Tandem Conglomerate last year – and I can vouch that their talent is top-notch. Qlikview is smart to find partners of this caliber – and utilize them to better serve their customers.

As a technologist, I always have my eyes open to exploring new technology. This is always challenging with long term contracts, university politics, and an ever-changing IT landscape. However, for me, vendors have to prove why they should remain at the top. Competition is healthy for everyone as it makes us constantly improve. I should also say that as long as we have a defined data model, the reporting tools that we use on top of that data model are fluid. The point is not to constantly change and rip out what you’ve done just for the sake of redoing it, but it is important to keep an eye on the latest technology, experiment, and find what is best for your organization. This can be done gradually with small pilot projects to prove value. We’re actually in the process of doing one of these pilot projects with Hadoop.

Ok – so you’re probably wondering why I titled this post ‘real-time data collaboration’? During the Qlikview presentation yesterday, I saw something that really resonated with me. And, that was the ability to collaborate, in real-time, on the same Qlikview dashboard.

This capability is a market differentiator for Qlikview. As many of you may have seen from Gartner and in my previous post regarding Gartner’s Magic Quadrant for BI, this is one of the reasons that Qlikview remains ahead of competitors such as Tableau. Other dashboard vendors may provide the ability to ‘share’ with others, or embed the dashboard into a web page or part. Don’t misunderstand. This is NOT the same.

During their product demonstration, Qlikview demonstrated the ability in real-time to share dashboards. This means that you can select the filters/parameters that you would like to analyze, hone in on the particular area of interest, and share it in real-time. The recipient can then see that selection, modify it, and as they modify the shared dashboard, it will update your dashboard. You can modify and send changes back to the recipient as well. VERY COOL! Kudos to Qlikview on this feature.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user6327
Industry Analyst with 51-200 employees
Vendor
The future of BI in two words
Disclosure: I am an industry analyst focused on self-service business intelligence and data analysts. QlikView and Tableau user. Current clients include QlikView, Spotfire, and Tableau. What’s the future of BI? Last fall, one sharp source of mine answered, “Two words: Tableau and QlikView. You didn’t hear it here.” Those are startling words coming from that source, a well-regarded BI consultant known for big-name clients and their big deployments. At about the same time, a column of mine appeared in Information Management titled “Don’t call it BI” — in which I mentioned Tableau and a few smaller tools. A reader emailed, “You should also become familiar with QlikView.” My many Tableau-using friends say QlikView is hardly worth a look. Poor visualization! Control panels!…

Disclosure: I am an industry analyst focused on self-service business intelligence and data analysts. QlikView and Tableau user. Current clients include QlikView, Spotfire, and Tableau.

What’s the future of BI? Last fall, one sharp source of mine answered, “Two words: Tableau and QlikView. You didn’t hear it here.”

Those are startling words coming from that source, a well-regarded BI consultant known for big-name clients and their big deployments.

At about the same time, a column of mine appeared in Information Management titled “Don’t call it BI” — in which I mentioned Tableau and a few smaller tools. A reader emailed, “You should also become familiar with QlikView.”

My many Tableau-using friends say QlikView is hardly worth a look. Poor visualization! Control panels! Scripting! “It’s so — yesterday,” one emails.

It’s “yesterday” to some yet it’s the future to others. It’s time for a look.

Both Tableau and QlikView promise the same magic: Listen to one pitch and you might think that you’re listening to the other. Each sets itself up against traditional, big-iron BI. Each claims to empower business users by giving them all the data and control they need for free discovery. Each is easy to use. Go inside each tent, though, and you see how different they are.

Metaphorically speaking, Tableau is West Coast. It’s built for discovery by the individual. Just show up and ride on the breeze, the demos seem to say, free as a seed fairy on a meadow. The inevitable mistakes of discovery are quickly undone and forgotten. Create the most dazzling visualizations — “vizzes” — thanks to built-in best practices that nudge you toward beauty and punch.

One of the most attractive aspects is users’ effervescence. They seem to be riding on the wind and solving business problems all at once. Their rapture sweeps me away every time I’m near it.

If Tableau is West Coast, QlikView is East Coast. Its community is bigger, the third-party add-ons are more plentiful, support seems more available, and overall workflow feels more structured. It too is built for discovery, but it’s discovery rooted in community. The “associative experience” reveals relevant data, and you can create your own views and in quick succession ask any questions, anticipated or not. But unless you’re working alone, someone else probably defined the data and its structure for you. This is QlikView’s counterpart to Tableau’s meadow, though it’s more like a manicured garden than Tableau’s unfenced field of daisies.

QlikView’s boundaries may be more apparent than Tableau’s, but I suspect that there’s at least as much power there. I just haven’t yet been able to judge it for myself well enough.

The trouble for me is that I’ve used it alone, as if stuck in a remote cabin. Though even Thoreau might have liked the “associative experience,” QlikView really comes alive only when you link to others.

As in Tableau, any QlikView user can create or modify a workspace, a document linked to one or more sets of data with any number of displays. Unlike Tableau, QlikView isn’t so finicky about data; for one thing, linking to Excel spreadsheets is easier.

I can’t speak with assurance just yet on the differences between QlikView and Tableau Server — more on that later — though I think I see a QlikView edge there.

One other advantage for QlikView is clear: built-in collaboration. True, Tableau workbooks can be passed around in a variety of ways forever. But as with our atomized life on the West Coast, such a community would be for me, the hypothetical manager of a group, too loose for comfort.

Tableau users will shudder, as if about to be extradited back to Maine. “Great, central authority all over again,” they would say. Yet when I imagine myself managing a group, I would feel disabled without a tight, integrated social structure.

“It’s the soft stuff that matters,” TechTarget research director Wayne Eckerson likes to say. Such stuff is what interests me more than anything: Who are these people and how did they choose what they did?

Have most Qlik or Tableau users chosen their tool the way most of us choose spouses, religion, and politics — guided by our relationships? How many software shoppers qualified their candidates with lists of requirements and features and followed through based on evidence? Did they do what a veteran sales person at a large BI vendor sees?: “They gather requirements, they issue RFPs, they visit trade shows, they talk to vendors, and ultimately they pick one because they like its color.”

I think it’s usually about “color,” color being the cover story for something most people can’t quite describe. For now, though, I’m happy to say that at least my first question has been answered: Yes, QlikView belonged on that list in “Don’t call it BI.”

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user2862
VP of IT at a manufacturing company with 1,001-5,000 employees
Vendor
Our support has been excellent, but is provided by a 3rd party consultant group

What is most valuable?

Ability to quickly deploy dashboards with multiple data sources.

How has it helped my organization?

We have enable a user self service reporting capability support minimally by IT for linking and sourcing of data.

What needs improvement?

Map capability without add ins and extra cost.

For how long have I used the solution?

We have used this product for about 2 years

What do I think about the scalability of the solution?

No, product has proven to be scalable. You need to consider at least mid term scale before deciding which license types to purchase, I would recommend Server versions with session cals, vs. Document cals.

How are customer service and technical support?

Our support has been excellent, but is provided by a 3rd party consultant group.

Which solution did I use previously and why did I switch?

No we did not have a dashboarding tool other than using MS Products such as Excel.

What about the implementation team?

We used a combination of both internal and external resources. We used DI Squared, they have been excellent to work with and have more than adequate capabilities and expertise.

What other advice do I have?

Go for it. I might consider waiting for latest release version to come out before comparing other products. There may be some excellent additions to functionality. Plan out your environment, plan out the data modeling process. Spend time on governance of the processes that support the user self service capabilities. Although end users can use the product easily, they may need help with data procurement. Think about security of your data before turning everyone loose.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user4605
Consultant at a wholesaler/distributor with 51-200 employees
Vendor
Once you see what it can do, you will want it
Pros: Speed Flexibility User Friendly Associated Search In Memory Cons: Reporting is quite difficult to get right, but if you spend you will get it right

Pros:
Speed
Flexibility
User Friendly
Associated Search
In Memory

Cons:
Reporting is quite difficult to get right, but if you spend you will get it right

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user4605
Consultant at a wholesaler/distributor with 51-200 employees
Vendor
I left my Job of 15 years to...
I left my Job of 15 years to work with Qlikview full time, that alone will tell you what I think of it, a full review to follow

I left my Job of 15 years to work with Qlikview full time, that alone will tell you what I think of it, a full review to follow

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user3768
Consultant at a financial services firm with 10,001+ employees
Vendor
QlikView vs Tableau
As promised in my last “first look” review, I’m taking Qlikview 10 for a spin. For those of you not familiar with Qlikview it’s a data visualization tool that’s designed to make the creation of ad-hoc reports and dashboards, from existing data, quick and simple. Installation Getting hold of Qlikview is a matter of registering on their web site and downloading the “personal” edition. The personal edition has the limitation of not being able to share your Qlikview files with any other users, but doesn’t appear to have any other time or functionality restrictions. You will probably want to download the tutorial. This is made up of some sample files and a PDF tutorial. Whilst a PDF feels a bit “old school” however it is clearly written and progressive, making it pretty easy to follow…

As promised in my last “first look” review, I’m taking Qlikview 10 for a spin. For those of you not familiar with Qlikview it’s a data visualization tool that’s designed to make the creation of ad-hoc reports and dashboards, from existing data, quick and simple.

Installation

Getting hold of Qlikview is a matter of registering on their web site and downloading the “personal” edition. The personal edition has the limitation of not being able to share your Qlikview files with any other users, but doesn’t appear to have any other time or functionality restrictions.

You will probably want to download the tutorial. This is made up of some sample files and a PDF tutorial. Whilst a PDF feels a bit “old school” however it is clearly written and progressive, making it pretty easy to follow.

Interface

The interface is very “Office 2003”. Not a bad thing, in that most of the icons are pretty easy to figure out, but it does feel quite dated (Qlikview 11 is being trumpeted on their blog – so this may be remedied soon). The workspace is also pretty bare until you start adding some data. There’s not too much clutter though and most Windows follow sensible conventions (right click on an object for properties etc.)

Properties window. Lots there, but fairly accessible

Applying the “man test”

Being a vain middle aged man I prefer not to read tutorials and instructions. The “man test” is very subjective, and in this case I did resort to reading the tutorial (whereas with Tableau I was compelled by child-like curiosity to cobble something together without instructions). This isn’t to say that Qlikview isn’t intuitive – it’s really very good, but it’s not quite as visual and inviting as apps such as Tableau.

Features that really stood out

Qlikview seems to bring the data to the fore. Your start point is very much the fields that make up the database and you then add charts onto this. One of Qlikview's specialities – they call it the Associative Engine – seems to be the ability to filter all linked fields in other tables when selecting any field in any table. It grays out not applicable data and highlights linked data in white – so you understand the associative relationship (or not) between datasets.

I think I’d need to use this tool in anger on my own data set to really understand the benefits of this approach, but it seems logical and intuitive – all good.

Dashboards are quick and easy to create, at least as simple as Tableau – they are both drag-and-drop efforts. Qlikview makes it fractionally easier to tweak the look and feel of objects.

Tables are easy to create and to drop into dashboards. Interactivity on tables and charts is excellent, allowing you to reselect data and ranges on the fly.

Things I didn’t like

This type of tool is all about delivering insight from your data. This inevitably includes charts. Working through the tutorial I was very disappointed by the standard of charts shown. Now it may well be possible to tweak these graphs to follow better practice, but frankly we shouldn’t have to. Having charts like this:

…is unacceptable. It shows a real lack of understanding of how to present information and you wonder how much of this attitude spills into the design of other templates and software features. The 3d pie chart…

.. had me biting lumps out of the carpet – but perhaps it’s just me (see this rant about pie charts for the background of my loathing). By the time I got to mock-gauges…

…I was inconsolable. Tableau can do “proper” charts, with minimal clutter, careful use of colour and good layout – Qlikview, you can do better.

One of Qlikview's selling points is that it’s “in-memory”, so it should be able to execute analysis very swiftly. However, the Gartner report from 2011 on BI tools indicates that customers are not particularly stunned by the overall speed of Qlikview and I have concerns over server memory usage – a query I still have open with Qlikview sales (i.e. what happens when you exceed the available memory with your requirements).

Sharing

There are lots of ways to share your output:

  • Over the intra/internet
  • To a dedicated client app on your PC
  • To mobile phones/tablets (iOS, Blackberry and Android supported)
  • Export to Excel
  • PDF

Pretty much every method you could hope for, save carrier pigeon.

Verdict

I like the ease of use of Qlikview. I was very under-whelmed by it’s charting ability- it feels like the defaults and the tutorial regard graphic representation as an afterthought – this was backed up by their sales person commenting on the “pretty graphs” of their rival – Qlikview – you just don’t seem to get it!  The company are making great play of the way it handles data, and specifically the relationship between that data, so I think it merits some further investigation. Watch this space for some longer-term road testing and a more in-depth review.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user2862
VP of IT at a manufacturing company with 1,001-5,000 employees
Vendor
Flexible, quick access, but need to spend time designing the Data Warehouse.

Valuable Features:

Flexible, quick access by end users, can promote user self service reporting

Room for Improvement:

Still need to spend time designing the Data Warehouse behind this tool to facilitate user self service model.

Valuable Features:

Flexible, quick access by end users, can promote user self service reporting

Room for Improvement:

Still need to spend time designing the Data Warehouse behind this tool to facilitate user self service model.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user1245
Project Manager at a computer software company with 51-200 employees
Vendor
QlikView is a highly effective management tool, allowing a broad area of analysis.

Valuable Features:

QlikView is based on a different technology from OLAP technology. Called AQL ™ (Associative Query Logic), this technology has been patented since 1994. If there is no need rethinking QlikView OLAP cubes, development and implementation of new elements, reconfiguring the graphical interface. Also, working with databases is much more flexible. Thus reducing the time and that the costs of implementing new analysis / reports. QlikView is easy to use, letting you easily analyze large volumes of data! Interactive graphical interface to predominantly assures unquestionable advantage over other applications. From a few clicks you can find any information in your database, no matter how "hidden" or detailed as! QlikView is a highly effective management tool, allowing a broad area of analysis. Virtually any existing information in the database the company can be valued by this application, stimulating her performance in an integrated context. • Qlikview has its own ETL engine built-in • You can analyze millions of data - QlikView is easy to use, letting you easily analyze large volumes of data! • Time to implement - Any user / manager can define its own set of analyzes • Partner Network – Qlikview has more than 1000 partners world wide • Development - Qlikview has Scripting • 64-bit in-RAM DB - Qlikview is faster than Tableau • QlikView is based on a different technology from OLAP technology. Called AQL ™ (Associative Query Logic), this technology has been patented since 1994. • Interactive graphical interface - Extremely intuitive interface (requires almost no training);

Room for Improvement:

QlikView should give you just that: gather, provide access to, and analyze data and information about their company operations So, QlikView has little success by itself, so we have to go with: ERP, CRM, or some planning and estimation solutions (this would take what-if scenarios) which means other costs besides the costs of implementing QlikView This is why QlikView offers the possibility to perform what-if scenarios. • QlikView has little success by itself, so we have to go with: ERP, CRM, or some planning and estimation solutions (this would take what-if scenarios) which means other costs besides the costs of implementing QlikView • QlikView can display better analysis but it takes more skill and time to develop/design than with Tableau. • Qlikview it is stronger than Tableau for reporting only, but it requires more training and is less intuitive than Tableau • You have to employ IT specialist • It is limited by RAM, so Qlikview is not very scalable I chose QlikView specialization rather than other BI solution available on the market due to the advantages this technology offers:- Good price compared to other solutions; - Flexible licensing system (but not complicated and consists of dozens of modules that other solutions); - Very little development time; - Easy maintenance; - Ability to provide Business Intelligence Off-The-Shelf. - In QlikView, you can develop yourself analyzes you need in just minutes
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros sharing their opinions.