Tableau vs Qlikview, the differences between these platforms?

qlikview
tableau

#1

Currently i am working with Qlikview and heard a lot about Tableau. I want to know which tool is better for the data visualization and career both?

Regards,
Satish


Difference between Visualization tools
Can Qlikview or Tableau replace Excel Reporting?
#2

Satish,

To be honest, there is no winner of loser here. Both, QlikView and Tableau are fabulous tools, which are changing the way BI used to happen traditionally. Both have their own pros and cons. Let me provide my perspective on it:

Benefits / Pros for both the tools:

  • Fast implementation - typically it takes only 2 - 3 months to deploy a dashboard on any of these tools
  • Good community in the making - Both Qlik & Tableau have decent community size
  • Both come with good set of visualizations and story-telling features

QlikView Pros:

  • Easy to learn for basic usage. No coding required to create simple dashboards.
  • Provides a personal edition free - so you don’t need to buy one to learn or in case you are a small Organization
  • Relatively lower cost compared to Tableau
  • QlikView’s association based filtering is very intuitive to use and something you get used to very quickly
  • Very efficient data storage (QVD formats) and capability to perform datawarehousing with in the tool.

Tableau Pros:

  • No coding required at all. The entire interface is drag and drop
  • Can create Geo-spatial dashboards with a lot of ease. If you provide name of city and country - it will pick up latitude and longitude itself.
  • Integration with R - Tableau can connect with R easily and you can run your models and monitoring from Tableau directly
  • More connectors e.g. Google Analytics

However, Tableau requires data warehouse to be present in the Organization (except for small scale clients)

So the bottom line is that you are in good shape, if you become an expert in any of them. Both of them fall in the leaders quadrant in Gartner reports and are leading the changes in BI industry. The choice for an Organization depends on a lot of factos liks budgets, presence of data warehouse etc.

Hope this helps


#3

Very nice reply Kunal.
What is you take on pentaho which offers community edition(cde,cdf,etc) which is like free of cost for smaller organisations?


#4

Hello,

I have worked on both the tools and frankly speaking I’d say tableau has an edge over qlikview. I’ve tried to make a comprehensive list of features on the basis of which this comparison can be justified.

Ease of Use

Qlikview : It is easy to use and easily explore the hidden trends. To search, just type any word in any order into search box for instant and assocaitive results and it will show connections and relationships across your data. It is difficult for user to design their own views due to menu driven properties.

Tableau: Its interface is simple, not filled with too many features at one page and has a drag and drop interface. It does not provide feature to search content across all your data. User can easily create their own views using various objects and it is easy because of well designed GUI interface

Ease of Learning

Qlikview:It has actively engaged community and resources to help you learn this software in the best possible manner.

Tableau:It also has actively engaged community and resources to help you learn this software in the best possible manner.

Cost / Availability

Qlikview: Its personal edition is free with limitation of document sharing. Each named user license is $1,350 and $15,000 for a concurrent user. Server license is $35,000/server. Additional $21,000/server for PDF distribution service; $22,500 for SAP NetWeaver connector. May require RAM upgrades if large numbers of concurrent users.

Tableau: Free Desktop version called “Public” that makes data is available for all to download. Private versions come with fixed fee $999 or $1,999 depending on data access. Tableau Server - anecdotal evidence says $1k/server user, with minimum of 10 users plus maintenance.

Connectivity with Other tools/ Language or Database

Qlikview: It integrates with a very broad range of data sources like Amazon Vectorwise, EC2, and Redshift, Cloudera Hadoop and Impala, CSV, DatStax, Epicor Scala, EMC Green Plum, Hortonworks Hadoop, HP Vertica, IBM DB2, IBM Netezza, Infor Lawson, Informatica Powercenter, MicroStrategy, MS SQL Server, My SQL, ODBC, Par Accel, Sage 500, Salesforce, SAP, SAP Hana, Teradata, and many more. It can connect with R using API integration. It can connect with Big data.

Tableau: It can integrate with a broader range of data sources including spreadsheets, CSV, SQL databases, Salesforce, Cloudera Hadoop, Firebird, Google Analytics, Google BigQuery, Hortonworks Hadoop, HP Vertica, MS SQL Server, MySQL, OData, Oracle, Pivotal Greenplum, PostgreSQL, Salesforce, Teradata, and Windows Azure Marketplace. It can connect with R that powers the analytical capabilities of the tool. It can also connect with Big data

Deployment Process & System Requirement

Qlikview:Qlikview has its own dataware house and addition of scripting feature adds more values to it. We can use multilevel layers in qlikview deployment. Qlikview is easily deployable and configurable, and starts producing stunning reports within minutes of installation. This product does not use cubes; hence loads all the tables and charts in memory to enable interactive queries and creation of reports—a technology not found in other products. It can be developed on both 32 and 64 bit. Its associative technology makes data modeling easier.

Tableau: It does not have its own dataware house. It can not create layers while connecting with data set. It is more easier to deploy because it requires more structured data.

Insight Generation

Qlikview: Associative technology makes it more powerful and it helps to read association between variables easily. This feature sometimes help businesses to understand hidden relation between data points

Tableau:Story telling feature helps you to create presentation, using your available data points.

Visualization Objects

Qlikview: It has good options available to visualize information. It is loaded with various objects. We can play with properties of these objects easily to customize it. We can also create custom charts like waterfall, boxplot, geo-spatial charts by customizing properties. While inserting object, it has layout and formatting options similar to theme of document. Here we need to work on formatting options to make it more visually appealing.

Tableau: It has good visualization objects with better formatting options. It has very good visualization for geo-spatial visualizations.

Mobility

Qlikview: Qlikview is not dependent on device, we can easily access from anywhere. Decision making becomes much faster compared to traditional method.

Tableau: It is also available on all devices and can be accessed over internet.

Security

Qlikview: It has various security options like security for Script, Document, Section Access and user authentication.

Tableau: Tableau has good security feature and it is highly handled by tableau server.


#6

Kindly Check the Below article to know the Qlikview and Tableau differentiation

Qlikview vs Tableau