Let's compare tableau and qlikview on the basis of some parameters.
1. Ease of Use
QlikView : It is easy to use and explore the hidden trends. To search, just type any word in any order into search box for instant and associative 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.
2. 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. It is a simple drag & drop application which makes it very easy to learn.
3. Cost
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 $1000/server user, with minimum of 10 users plus maintenance.
4. 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 sources.
5. Deployment Process & System Requirement
QlikView: QlikView has its own data warehouse and addition of scripting feature adds more value to it. We can use multilevel layers in QlikView deployment. QlikView is easily deploy-able 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 data warehouse. It can not create layers while connecting with data set. It is more easier to deploy because it requires more structured data.
6. 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.
7. 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 the 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. It has numerous options of visualizing your data. The visualizations are always in the best quality.
8. Mobility
QlikView: QlikView is not dependent on a device, we can easily access it from anywhere. Decision making becomes much faster compared to traditional methods.
Tableau: It is also available on all devices and can be accessed over internet. You can use Tableau on your laptop, tablet or phone.
9. Security
QlikView: It has various security options like security for Script, Document, Section Access and user authentication. Direct access to the QlikView Document using QlikView Desktop is always governed by Windows NTFS File Security. Access to the web-based QlikView Enterprise Management Console is restricted to Windows Users who are a member of a particular local Windows Group.
Tableau: Tableau has good security feature and it is highly handled by Tableau server. Tableau is a modern enterprise analytics platform that enables self-service analytics at scale through governance. Security is the first and most critical part of a data and content governance strategy. Tableau Server provides the comprehensive features and deep integration to address all aspects of enterprise security. Tableau helps organizations promote trusted data sources for all users, so the right data is used to make the right decisions quickly.
10. Scalability
You may have heard Tableau offers better scalability than QlikView, or that QlikView can scale faster than Tableau. The truth is, both vendors can handle a huge amount of data. In fact, the majority of organizations are not producing that much of data which either solution can’t handle.
Read the following blog to know more: Tableau vs QlikView | Comparing Data Visualization Tools | Edureka
Hope it helps! :)
Master data integration and transformation with our comprehensive Informatica Course.
