QlikView vs. Tableau

Some while ago I was asked by the CIO of my company to give a report on the Microsoft BI tool set. While gathering information I constantly found QlikView and Tableau being named as the new top dogs. Having used QlikView for a couple of years now I got interested to know more about the rival.

Just by reading blog posts and articles it already became clear Tableau fits into the category of data analysis tools. QlikView emphasizes on data discovery, so would it be fair to compare them against the same criteriors?

Planning to buy me a new car I needed to analyse the balance history of my bank account. This gave me a perfect scenario to try to implement using both tools utilizing the data I already had ready in a Excel workbook.

QlikView

In QlikView the building of a solution always starts by configuring the load script defining how the data will get imported. QlikView is never directly connected to a data source, instead the information is always first imported, processed and compressed.

I had to add two data transformations: convert the date information to a correct date format and to change the numbers with a trailing negative or positive sign to the more traditional format. To help with displaying the values on a monthly and weekly timeline I also had the script generate some additional information.

QlikView load script

When I was ready with the importing, setting up the chart and table objects was easy. As I only had data from the beginning of this year I configured the accumulation “manually” by defining it in the chart expression enabling me to include the initial balance.

QlikView solution

The final result looked nice and as QlikView by default already supports filtering by clicking on any visible information I did not see a need for any additional filter boxes.

Tableau

My plan was to use Tableau Desktop but as my trial license had expired I had to turn to Tableau Public that is offered free for publishing dasboards online.

Configuring my Excel files as a data source was easy using the inbuilt wizard. Unike QlikView Tableau links in general directly with the data source and the transformations are processed on the fly.

As the data required some tansformation as desrcibed earlier, I created two additional calculated dimension fields for this. The script language was quite close to what I used in QlikView so I could copy-paste most of what I had earlier written.

Creating the list was easy and done by drag and drop just like when working with pivots in Excel. Configuring the chart was more of a challange as I needed to create some additional calculated measure fields to get the same result I had in my QlikView solution. In contrast to QlikView, I did not have to create any week and month fields has Tableau could do the groupping directly using the available date field by selecting the desired option from the menu.

Tableau workbook

In Tableau the visual elements are defined in worksheets and these are then composed on a dasboard. Setting up the dasboard was easy and done by placing the previsouly created worksheets onto a grid. As there is no standard drill down and filtering available the presentation ended up being quite static .

Tableau dashboard

Summary

Using QlikView, writing the import script and configuring the objects on the canvas requires some degree of knowledge but it also allows the user to setup complex data handling and having full freedom to define the visual appearance of the solution. QlikView enables not only setting up dashboards but also has potential as a platform for creating complete BI tools.

Despite the fact that I did not spend any time on reading manuals or watching video tutorials before getting started with Tableauwas easy. Tableau also offered much of the functionality through menu options that required scripting in QlikView. Unfortunately when working with dashboards what you see is what you get, leaving less room for discovery.

I would imagine Tableau is closer to Microsoft PowerPivot in its user experience and approach than to QlikView. As there tools are of different nature, only by comparing them against specific requiremets will yeld in a truthful conclution.

Advertisements

5 thoughts on “QlikView vs. Tableau

  1. You basically came to a similar conclusion I came to when doing a similar comparison over a year ago. Tableau is far easier to use for a non-techie beginner and even if you are technically minded Tableau is far quicker to get up and running. You could have your report complete in the same time it takes to load the data into QV. My full write up is at this article: http://reports4u.co.uk/tableau-vs-qlikview/

    I still think QV is a very powerful reporting tool, probably more suited to bigger BI depts, where Tableau woud be better for smaller and less techincal teams. Qlikview is more of an IT dept product while Tableau is easy to use by the business teams who would ordinarily be report consumers rather than developers.

    • QlikView offers two features that common data analysis tools do not: 1) The load scripting provides a basic ETL solution, so the data can be whatever is available and transformed, maped and completed on the run, 2) QlikView offers a powerfull platform for BI solutions, offering a replacement for those using Excel and macros. Many companies offer reporting solutions built on QlikView to support their or 3rd party products.

      The last mention is maybe not of interest to old school BI specialist, but for sure of those business users processing and reporting information daily.

  2. I know this was written a while back but the latest version of qlikview allows for direct connection to SQL data sources. It’s bait slower than the traditional method described in your post but its worth noting .

  3. I want to understand.
    Which is better QlikView Server or Tableau Server? (in terms of deployment and why)
    Why We need QlikView publisher? Tableau don’t have publisher but only server . So , does that mean Tableau server is smart or does Publisher provides something extra and therefore QlikView has edge over tableau.
    Please revert asap

    Thanks in advance !!!

    Siddharth

    • Hi Siddharth,

      There are 2 ways to access QlikView solutions. You can use QlikView as your personal desktop tool only OR use the server to provide your creations through a web portal. The QlikView server also allows you to schedule reloading and managing floating licenses.

      The QlikView Publisher is a additional product that allows you more control over the scheduled loading and allows data segregation by splitting the data of a single solution for multiple audiences based on the attributes you define.

      Does Tableau offers a similar concept?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s