it_user381693 - PeerSpot reviewer
FSI IT Consulting Manager at Deloitte Portugal
Real User
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.

Buyer's Guide
QlikView
April 2024
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.

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 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.
PeerSpot user
it_user257343 - PeerSpot reviewer
Business Intelligence Latin America Leader at a engineering company with 1,001-5,000 employees
Real User
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.
PeerSpot user
Buyer's Guide
QlikView
April 2024
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.
PeerSpot 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.
PeerSpot user
Logistics Engineer at a logistics company with 201-500 employees
Real User
Top 20
An incredibly powerful tool that offers great scalability
Pros and Cons
  • "QlikView is a scalable solution that multiple users can easily use."
  • "QlikView certainly lacks in its ability to share visualizations or create visualizations easily."

What is our primary use case?

In my company, we use QlikView for dashboards. With QlikView, our company tries to ensure that we capture all operational items in the dashboard so that the management can take action based on that.

What is most valuable?

I think the main benefit of QlikView is that it is an incredibly powerful tool, as it can handle millions and millions of rows.

What needs improvement?

QlikView certainly lacks in its ability to share visualizations or create visualizations easily. QlikView is a powerful tool but has shortcomings when compared to the visualization capability provided by Qlik Sense or Power BI.

From my perspective, I understand that since QlikView is an older product, it can be simply left as it is, and users can move to Qlik Sense, which provides a much stronger visualization.

If QlikView decides that its visualization part should be just like Qlik Sense or Power BI, then I would say it would be too much to capture in one or two phrases, considering that it is overall much easier to create visually good-looking dashboards and also something like a geographical map which is not possible in to get in QlikView currently.

For how long have I used the solution?

I have been using QlikView for years. I am a user of the solution.

What do I think about the stability of the solution?

I am happy with QlikView's stability. Stability-wise, I rate the solution an eight out of ten.

What do I think about the scalability of the solution?

QlikView is a scalable solution that multiple users can easily use.

My company has 20 to 50 users of the solution.

How are customer service and support?

QlikView has a lot of resellers, and my company has been in touch with one of QlikView's resellers. It is QlikView's reseller and not the support from QlikView that my company contacts for help. I rate the technical support a seven out of ten.

How would you rate customer service and support?

Neutral

How was the initial setup?

The solution is deployed on an on-premises model.

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

QlikView is a reasonably priced solution.

What other advice do I have?

I would suggest others to QlikView and go for Qlik Sense. Qlik Sense is a tool that is as powerful as QlikView with better visualization capabilities. I would not recommend anyone to use the older QlikView, but I would recommend anyone to move to Qlik Sense.

I rate the overall tool an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
PeerSpot user
Director of IS at Bennington Marine, LLC
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.
PeerSpot user
Sue Penick - PeerSpot reviewer
Sue PenickDirector of IS at Bennington Marine, LLC
Real User

just used the REST connector for an API in the load script...worked excellent!

PeerSpot user
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
Pros and Cons
  • "I had the option to prepare data myself instead of always having to depend on the data team."
  • "More/newer visualisation components need to be added."

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.
PeerSpot user
PeerSpot 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.
PeerSpot user
it_user326337 - PeerSpot reviewer
it_user326337Customer Success Manager at PeerSpot
Consultant

What would embedded predictive analytics help you obtain that you are currently unable to access?

Director of Development at Strat-Wise Consulting
Consultant
Top 5Leaderboard
Very intuitive to business users and executives
Pros and Cons
  • "On the positive side, QlikView's scripting is a great asset as it functions as an ETL."
  • "If a user wanted to see something not included in the application the new object had to be created by a power user or developer because Qlik view's scripting has somewhat of a learning curve."

I do use both Tableau and QlikView. Although very different, I really like both solutions. They belong to the new BI generation known as Interactive Visual Analytics.

In my opinion, QlikView has a more intuitive interface for regular users or executives that are not technical experts but the development side is a little more complex. Up to version 12 QlikView did not provide drag & drop features.

If a user wanted to see something not included in the application the new object had to be created by a power user or developer because Qlikview's scripting has somewhat of a learning curve.

On the positive side, QlikView's scripting is a great asset as it functions as an ETL allowing the integration of hundreds of different data sources into the same visual app.

Another feature that’s extremely useful is Qlik’s proprietary Associative Model that allows the users to visualize data relationships that exist as well as those that do not.

Tableau on the other hand is a lot easier to use for developers, analysts or power users who need to connect, manipulate and visualize data rather quickly. While this makes Tableau a better fit for the more analytical crowd, it may not be as appealing or intuitive to the regular or casual business users as QlikView is.

Tableau has full pivot, drag & drop and drill down capabilities that are great for developers or power users. They can rotate measures and dimensions and graph them instantly using visualization best practices as suggested by the "show-me" feature.

Tableau’s provides a forecasting function and the capability to connect with the open source statistical program R to include predictive modeling.

Tableau includes a Data Interpreter that makes data cleansing, column splitting and crosstab pivoting very intuitive. Tableau’s latest versions allow joining tables from different data bases and have included the hyper data engine that provides 5 times faster query speeds.

The latest version includes "relationships" with an algorithm that makes
the necessary data connections automatically with no need to perform joins or add Level of Detail scripts (LOD) to eliminate duplicates. However one can still create joins to override relationships if for some reason it was necessary.

Also when opening older files containing joins they are kept under a
"migrated data base" or the migrated joins can be deleted to be replaced with simpler automatic relationships.  Tableau releases updated versions once a quarter.

Both Tableau and Qlik continue to be excellent. They are positioned at the top of the leader's quadrant in Gartner's 2022 Magic Quadrant report for BI and Analytics platforms. 

https://powerbi.microsoft.com/...

In my experience the choice depends on the fit with the company culture and the users' profile.

Qlik introduction of their new platform called “Qlik Sense” provides intuitive drag & drop functionality to create visualizations. At this point Qlik Sense Desktop is free for personal and small group of cloud business users that need to easily develop analytic applications on their own - with virtually no IT intervention.

Recently Tableau has moved to a subscription based model but still offers free products: Tableau Public and Tableau Reader to ease the user entry process.

It certainly seems like Qlik Sense is an attempt to regain some of the impressive growth Tableau has enjoyed during the last few years playing in the truly self-service visual BI segment.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Martin Goebbels - PeerSpot reviewer
Martin GoebbelsData Analyst & Researcher (Freelance) at Sonra Intelligence
Top 10Real User

Sure thing, Qlik ELT scripting isn't exactly standard programming language. And set analysis, very powerful but also complicated.

See all 2 comments
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Reporting Embedded BI
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros sharing their opinions.