Tableau vs. Qlikview: Which is better?Category: Tableau Training Posted:Oct 11, 2017 By: Serena Josh
Here are a few ways to find out which Tool suits an individual or an organization better:
1. Ease of Use
Qlikview is offers great ease of use and also easy discovery of hidden trends across the entire host of users. Its search function is similar to that of Google Instant Search bar providing (as the name suggests) instant results which are also associative. Such search results will also display relationships and links across your data. Menu driven options and properties make it hard for users to architect customized views.
Tableau has a drag and drop interface which is simple and populated only by limited features per page. A feature for content search across various data types is limited. Users are able to create customized views through multiple objects, which are made simple because of a GUI which is well architected.
2. Ease of Learning
Qlikview has a dynamic and highly engaged community coupled with associated resources to aid users in picking up software skills with the least application of effort.
Tableau has a similar community with identical levels of engagement coupled with similar resource levels. The drag and drop application interface makes it very easy to learn from a users perspective.
Qlikview’s personal edition comes free with the exception of document sharing. A named user license runs up an expense of $1,350 and concurrent users come at a price of $15,000 per user. Server licenses will obviously run up a premium expenditure of $35,000/server. An extra charge of $21,000/server is levied on PDF distribution services and a cost of $22,500 for SAP NetWeaver Connector. This may need RAM upgrades for larger volumes of concurrent users.
Tableau has its free Desktop version named simply as “Public” which makes data accessible for download. Private versions costs range from $999 to $1,999 depending on the data access that is availed. According to reports by users, Tableau Server comes at a price of $1000/server user, provided there are at least 10 users including the maintenance charge.
4. Connectivity with Other tools/ Language or Database
Qlikview enables integration with a large data source spectrum ranging from Informatica Powercenter, Horton works Hadoop and Cloudera Hadoop to CSV, SAP HANA and Salesforce. It can also link with R through API integration, while also being able to connect with Big Data.
Tableau has a similar set of data source integration capabilities ranging from Google Analytics, Big Query, and MS SQL to Windows Azure Marketplace, Teradata and Oracle. This can also similarly connect with R, driving the analytical capabilities of the tool, while also having the ability to connect with Big Data.
5. Deployment Process and System Requirement
Qlikview had enhanced value addition in terms of having its very own data warehouse along with its scripting feature. Multilevel layers can also be used here for deployment. With Qlikview being easy to deploy and configure, users can generate stunning reports within barely minutes of its installation. Since the product does not make use of cubes, every table and chart in the memory is loaded to allow for creation of reports and interactive queries. This feature is particularly noteworthy since such a technology is seldom found in other products of the same nature. It can be developed on both 64 and 32 bit. And it is also important to observe that associative technology makes data modeling easier.
Tableau does not have a dedicated data warehouse and is not able to create layers while connecting with data set. The need for higher volumes of structured data makes for easier deployment.
6. Insight Generation
QlikView: Associative technology makes it more powerful and it helps to read association between variables easily. Sometimes this feature helps businesses to understand the hidden relation between data points.
Tableau storytelling feature helps one in generating presentation utilizing existing data points.
7. Visualization Objects
Qlikview is has within its purview a great deal of options which are accessible for visualizing information and is loaded with multiple objects. Users can customize it by playing around with object properties. Users can also resort to creation of custom charts such as geospatial, box-plot or waterfall through property customization. Insertion of objects is aided by formatting and layout options which resemble the document theme. Users need to roll up their proverbial sleeves to work on formatting options to enhance visual appeal.
Tableau is said to come with a relatively better set of formatting options with great objects for visualization purposes. With varied choices for data visualization, the quality of said visualization is considerably better. Geospatial visualisations carry great scope here with varied options for visualization of data, in the best quality possible.
Qlikview is device agnostic, making it just as easy to access across various devices. In this process there is accelerated decision making that happens when contrasted with conventional methods.
Tableau is similarly agnostic with it being able to be accessed over various devices, whilst also being able to be accessed over the internet. One can use Tableau on anything from a laptop and tablet to a mobile phone.
Qlikview comes with a host of security choices such as user authentication, Section Access, as well as document and script. Qlikview Desktop always needs Windows NTFS File Security for direct access to the Qlikview Document. Only Windows users who are members of a specified Windows group can access the web based QlikView Enterprise Management Console.
Tableau is known to have an excellent set of security features handled with high efficiency by the Tableau Server. It is fundamentally an enterprise analytics platform that’s modern and that allows for self service based analytics through governance. As most enterprises would already know, data and content governance strategies have security detail at their core. Tableau offers holistic features coupled with in depth integration to take care of every aspect of enterprise security. This helps enterprises to promote trusted data sources within users, as the right data should be provided to make and act on the right decisions as fast as humanly possible.
According to customers Tableau provides enhanced capability to scale as compared to Qlikview. Some other customers find that it is the other way round. This is entirely subjective.
The above perspective given regarding both software suites has to be combed through to find the best product for use. Only depending on user need and product compatibility can you decide which software suite will be a better fit for your organisation.