Discover, Analyze, Explore, Pivot, Drilldown, Visualize your data… “How do I know what I think until I see what I say?” [E.M. Forster, G. Wallas, A. Gide]
named “The future of BI in two words” which made me feel warm and fuzzy about both products and unclear about what Ted’s judgement is?
Fortunately I had a more “digitized” comparison of these 2 Data Visualization Leaders, which I did a while ago for a different reason. So I modified it a little to bring it up-to-date and you can see it for yourself below. Funny thing is that even I used 30+ criterias to measure and compare those two brilliant products, final score is almost identical for both of them, so it is still warm and fuzzy.
Basically conclusion is simple: each product is better for certain customers and for certain projects, there is no universal answer (yet?):
It’s indeed a very valuable information before investing on DV tools.
Our Organization is looking at DV tools to reduce manual efforts for reporting, improve operational efficiency, perform smarter analytics. Our current BI system is built on Microsoft BI suite with database on SQL Server and OLAP cubes on SQl Server Analysis Services and hence we are looking for DV to connect to SSAS OLAP cubes.
Your assessment on these tools indicate that for Multi-dimensional, Tableau is very good and QlikView is limited and Spotfire is None.
a. And what do you mean by Limited for QlikView?
b. On Which version of Spotfire is the assessment done? (I can see that Tableau 7 and QlikView 11)
a. Qlikview will not inherit any cube infrastructure (dimensions, measures, KPI, etc. and that is LIMITED) but I saw very smart Qlikview developers were able to get data from SSAS cubes with sophisticated Qlikview Scripting. In addition internal Qlikview data structures (Columnar database and associative Queries) in Qlikview can be used to emulate the Multidimensional Cubes
b. Yes I used the latest to compare: Tableau 7, Qlikview 11 and Tableau 4.0 (version of Tableau Server still 3.3.1)
c. Links you provided are not completed and they only can help with multistage extraction of Data from Cubes; when Data will arrive into Spotfire, all Cube infrastructure will be gone/lost.
I have a good news (rather rumor) for you but you will have to wait for a while: I guess/hope that the next version of Spotfire (4.x or 5.0 or 6.0?) will have the ability to interact with SSAS cubes. In any case, if you need to choose the DV tool now and connection to SSAS Cubes is the Requirement, you have only one choice – Tableau 7.0.
Hi Andrei,
1 Thanks for sharing so many of your observations on the DV platforms. I have found you observations very useful.
2 It is definitely a mystery why Microsoft with all its resources in terms of money and people is not investing in making a DV tool whether within Excel or out of it. It seems to be having no integrated strategy towards BI. Things seem to be done in bits and pieces. Whether it has an overall strategy which commoners like us don’t understand is not known.
3 We do most of our practice in MS-BI, and lack of a DV has been a very sore point. We have lost a lot of our customers / prospects to QV (Qlikview). We are now trying to partner with one of the big DV companies viz QV or Tableau or Panorama.
4 Panorama has still not come into the Gartners magic quadrant, while Tableau and QV have come in.
5 Would it make sense to rely only on QV (Qlikview), or to do the back-end work on MS-BI and then have Tableau/Panorama do the front end ?
I suggest to stay away from Panorama until they will figure out of how to compete with Tableau and Qlikview.
My answer on your questions are not simple, unfortunately. I also will not rely solely on Qlikview, because of
a) they are limited by RAM, so Qlikview is not very scalable.
b) Tableau is very competitive with Qlikview, in some case even better then Qlikview
c) also Tableau allows server-less distribution of DVs with free Tableau Reader
d) Tableau can read SQL Server Analysis Services Cubes AND PowerPivot Cubes
e) I will try to keep MS-BI as the back-end, especially if you can use SQL Server 2012 with its Columnstore Indexes, xVelocity in-memory engine, and new Tabular Mode in SSAS. Try to stay away from Power View as it is immature and has many problems (SharePoint is the biggest).
f) if you wish the real Visual Analytics, you may need Spotfire with its S-Plus, API and integration with .NET, IronPython and Visual Studio.
g) In some cases you need either Spotfire Silver or Tableau Digital
a) QlkView can scale. It doesn’t need to go after everything and place it all into memory. There are design best practices (as with any tool) that should be discussed and fitted for particular situations.
b) agree – but not when it comes to sheer data volumes, loading speed, reusability, # of functions and calculations available.
c) not sure why a business would want to permit its users to distribute content like this
d) QV can read SSAS and PowerPivot. Partner solutions exist, MDX can be used, or frankly – can’t you just go after the original data sources? Break free of the handcuffs of OLAP…there are other ways of modeling and interacting with data
e) QV integrates very well with MS Sharepoint (Not deep on knowledge about Tab with this); Agree – keep data in db, unless you need control of it or access to it because of excessive controls or restrictions
f) “real Visual Analytics” – not sure what that means, but I would be hard-pressed to find technologies better than QlikView, Tableau and Spotfire. Seems like new tools emerge each day…When will Oracle, IBM, SAP, possibly Google gobble up one of these tools? Only time will tell.
I have done similar comparisons for clients looking for an evaluation between different BI Products. From a Qlikview point of view I can offer the following:
– Although Gartner has now recognised QV as a leader, it is important to realise that the difference between QV 9 (when it first entered Gartner Magic Quadrant ratings) and the current v11 is vast. QV is not most certainly mature and stable product. The QV user community is well established with many examples and helpful posts.
– QV connection to SQL SSIS cubes…. In most cases a cube is a data staging database whilst as a QV Developer I would try to jump past this and hit the original data sources directly. I have seen cases where QV has bypassed the cubes and after a few months it is evident that QV is able to much more easily adapt to reporting changes and changes to business data sources that the Cube (which is sheepishly being maintained by administrators who are finding their staging database becoming obsolete as a data source in favor of QV.
– QV scripting is a combination of SQL and VB. these are well known and with a little experience I cant think of a data source or a business problem that would be too difficult for QV.
Thank you for the comparison chart. As a QlikView user, there are ways to connect to SSAS and MS PowerPivot. 1 would mean that it cannot be done…this is inaccurate. It can and has been done. Tableau and QlikView get compared to one another although I haven’t really seen an article exposing their true core competencies…in short, Tableau is a terrific tool for helping individuals navigate data sources that are pre-baked with formatting. It is a terrific visualization tool. QlikView is a functionally deeper product in that it can provide ETL-like behavior, store data offline (if required), and provide visualization. So, if both provide visualizations, which one is better at identifying patterns, outliers, anomalies?…the difference…QlikView’s associative analytics engine…Green/White/Gray color identification. Also, not covered in your article was the ability to perform massive loads of data, incremental loads of data, lack of chaining from one workbook, unlike doc chaining in QlikView. I appreciate your table. It is certainly a good start, but you may wish to also include things like: # of functions available (QV), Meta data management (QV), server abilities (QV), # of wizards (Tab), Reusability of objects (QV), Auto date formatting (Tab), collaboration (sharing screens and annotations (QV), Internet integration with numerous social media sites (Tab)…
One thing I cannot agree with stating is ability to connect to certain data sources…E.g. QV has an API, Tableau has an API…these API’s can be used to connect to pretty much anything. When people bring up Cube connections…I know immediately they do not “get” QlikView’s core purpose. Provide QV the raw data and let it empower a dept, a team, a division, the enterprise to connect, model, build a UI and collaborate for findings.
The article is skewed for Tableau…I understand. I am a QV user. The tools are good solutions for organizations…just do your homework and be sure to see the tool in action…don’t simply rely on demonstrations or a sales pitch. If you were to purchase a car…you would first, most likely, drive the vehicle before dropping down cash…do your homework.
[…] not Spotfire, for example. I just want to choose one. Qlikview vs Tableau. Comparison articles like this and this are very helpful, but a man is a man with his circumstances. Each starting point is […]
I like your business intelligence software criteria (and the logical breakdown between business and technical) very much, will use for internal purpose, thanks Andrei
[…] not Spotfire, for example. I just want to choose one. Qlikview vs Tableau. Comparison articles like this and this are very helpful, but a man is a man with his circumstances. Each starting point is […]
April 30, 2012 at 6:12 am
Dear Dr. Pandre,
Thanks for your post on the DV visualization tools comparison (Spotfire vs Tableau vs QlikView) on
http://www.practicaldb.com/blog/data-visualization/tableau-qlikview-spotfire/
It’s indeed a very valuable information before investing on DV tools.
Our Organization is looking at DV tools to reduce manual efforts for reporting, improve operational efficiency, perform smarter analytics. Our current BI system is built on Microsoft BI suite with database on SQL Server and OLAP cubes on SQl Server Analysis Services and hence we are looking for DV to connect to SSAS OLAP cubes.
Your assessment on these tools indicate that for Multi-dimensional, Tableau is very good and QlikView is limited and Spotfire is None.
a. And what do you mean by Limited for QlikView?
b. On Which version of Spotfire is the assessment done? (I can see that Tableau 7 and QlikView 11)
c. Your assessment on Spotfire indicate none for Multi-dimensional. Going through some of the blogs in TIBCO community it is indicated that TIBCO can be connected to SSAS OLAP cubes through Application data services ( http://spotfire.tibco.com/community/forums/t/1203.aspx?PageIndex=1 ) or through Linked Server
( http://spotfire.tibco.com/community/forums/t/1203.aspx?PageIndex=2 ). What’s your opinion on that?
Kindly appreciate your valuable feedback.
Thanks
Shankar
April 30, 2012 at 7:14 am
a. Qlikview will not inherit any cube infrastructure (dimensions, measures, KPI, etc. and that is LIMITED) but I saw very smart Qlikview developers were able to get data from SSAS cubes with sophisticated Qlikview Scripting. In addition internal Qlikview data structures (Columnar database and associative Queries) in Qlikview can be used to emulate the Multidimensional Cubes
b. Yes I used the latest to compare: Tableau 7, Qlikview 11 and Tableau 4.0 (version of Tableau Server still 3.3.1)
c. Links you provided are not completed and they only can help with multistage extraction of Data from Cubes; when Data will arrive into Spotfire, all Cube infrastructure will be gone/lost.
I have a good news (rather rumor) for you but you will have to wait for a while: I guess/hope that the next version of Spotfire (4.x or 5.0 or 6.0?) will have the ability to interact with SSAS cubes. In any case, if you need to choose the DV tool now and connection to SSAS Cubes is the Requirement, you have only one choice – Tableau 7.0.
May 2, 2012 at 4:08 am
Hi Andrei,
1 Thanks for sharing so many of your observations on the DV platforms. I have found you observations very useful.
2 It is definitely a mystery why Microsoft with all its resources in terms of money and people is not investing in making a DV tool whether within Excel or out of it. It seems to be having no integrated strategy towards BI. Things seem to be done in bits and pieces. Whether it has an overall strategy which commoners like us don’t understand is not known.
3 We do most of our practice in MS-BI, and lack of a DV has been a very sore point. We have lost a lot of our customers / prospects to QV (Qlikview). We are now trying to partner with one of the big DV companies viz QV or Tableau or Panorama.
4 Panorama has still not come into the Gartners magic quadrant, while Tableau and QV have come in.
5 Would it make sense to rely only on QV (Qlikview), or to do the back-end work on MS-BI and then have Tableau/Panorama do the front end ?
Your opinion would be helpful to me..
Sanjay
May 2, 2012 at 5:12 am
Hi Sanjay:
I suggest to stay away from Panorama until they will figure out of how to compete with Tableau and Qlikview.
My answer on your questions are not simple, unfortunately. I also will not rely solely on Qlikview, because of
a) they are limited by RAM, so Qlikview is not very scalable.
b) Tableau is very competitive with Qlikview, in some case even better then Qlikview
c) also Tableau allows server-less distribution of DVs with free Tableau Reader
d) Tableau can read SQL Server Analysis Services Cubes AND PowerPivot Cubes
e) I will try to keep MS-BI as the back-end, especially if you can use SQL Server 2012 with its Columnstore Indexes, xVelocity in-memory engine, and new Tabular Mode in SSAS. Try to stay away from Power View as it is immature and has many problems (SharePoint is the biggest).
f) if you wish the real Visual Analytics, you may need Spotfire with its S-Plus, API and integration with .NET, IronPython and Visual Studio.
g) In some cases you need either Spotfire Silver or Tableau Digital
Andrei
August 31, 2012 at 2:01 am
a) QlkView can scale. It doesn’t need to go after everything and place it all into memory. There are design best practices (as with any tool) that should be discussed and fitted for particular situations.
b) agree – but not when it comes to sheer data volumes, loading speed, reusability, # of functions and calculations available.
c) not sure why a business would want to permit its users to distribute content like this
d) QV can read SSAS and PowerPivot. Partner solutions exist, MDX can be used, or frankly – can’t you just go after the original data sources? Break free of the handcuffs of OLAP…there are other ways of modeling and interacting with data
e) QV integrates very well with MS Sharepoint (Not deep on knowledge about Tab with this); Agree – keep data in db, unless you need control of it or access to it because of excessive controls or restrictions
f) “real Visual Analytics” – not sure what that means, but I would be hard-pressed to find technologies better than QlikView, Tableau and Spotfire. Seems like new tools emerge each day…When will Oracle, IBM, SAP, possibly Google gobble up one of these tools? Only time will tell.
August 12, 2012 at 1:33 pm
I have done similar comparisons for clients looking for an evaluation between different BI Products. From a Qlikview point of view I can offer the following:
– Although Gartner has now recognised QV as a leader, it is important to realise that the difference between QV 9 (when it first entered Gartner Magic Quadrant ratings) and the current v11 is vast. QV is not most certainly mature and stable product. The QV user community is well established with many examples and helpful posts.
– QV connection to SQL SSIS cubes…. In most cases a cube is a data staging database whilst as a QV Developer I would try to jump past this and hit the original data sources directly. I have seen cases where QV has bypassed the cubes and after a few months it is evident that QV is able to much more easily adapt to reporting changes and changes to business data sources that the Cube (which is sheepishly being maintained by administrators who are finding their staging database becoming obsolete as a data source in favor of QV.
– QV scripting is a combination of SQL and VB. these are well known and with a little experience I cant think of a data source or a business problem that would be too difficult for QV.
August 31, 2012 at 1:47 am
Thank you for the comparison chart. As a QlikView user, there are ways to connect to SSAS and MS PowerPivot. 1 would mean that it cannot be done…this is inaccurate. It can and has been done. Tableau and QlikView get compared to one another although I haven’t really seen an article exposing their true core competencies…in short, Tableau is a terrific tool for helping individuals navigate data sources that are pre-baked with formatting. It is a terrific visualization tool. QlikView is a functionally deeper product in that it can provide ETL-like behavior, store data offline (if required), and provide visualization. So, if both provide visualizations, which one is better at identifying patterns, outliers, anomalies?…the difference…QlikView’s associative analytics engine…Green/White/Gray color identification. Also, not covered in your article was the ability to perform massive loads of data, incremental loads of data, lack of chaining from one workbook, unlike doc chaining in QlikView. I appreciate your table. It is certainly a good start, but you may wish to also include things like: # of functions available (QV), Meta data management (QV), server abilities (QV), # of wizards (Tab), Reusability of objects (QV), Auto date formatting (Tab), collaboration (sharing screens and annotations (QV), Internet integration with numerous social media sites (Tab)…
One thing I cannot agree with stating is ability to connect to certain data sources…E.g. QV has an API, Tableau has an API…these API’s can be used to connect to pretty much anything. When people bring up Cube connections…I know immediately they do not “get” QlikView’s core purpose. Provide QV the raw data and let it empower a dept, a team, a division, the enterprise to connect, model, build a UI and collaborate for findings.
The article is skewed for Tableau…I understand. I am a QV user. The tools are good solutions for organizations…just do your homework and be sure to see the tool in action…don’t simply rely on demonstrations or a sales pitch. If you were to purchase a car…you would first, most likely, drive the vehicle before dropping down cash…do your homework.
Thank you again for the article! Nice job!
September 25, 2012 at 4:23 pm
[…] not Spotfire, for example. I just want to choose one. Qlikview vs Tableau. Comparison articles like this and this are very helpful, but a man is a man with his circumstances. Each starting point is […]
September 28, 2012 at 1:11 pm
I like your business intelligence software criteria (and the logical breakdown between business and technical) very much, will use for internal purpose, thanks Andrei
January 19, 2014 at 3:17 pm
[…] not Spotfire, for example. I just want to choose one. Qlikview vs Tableau. Comparison articles like this and this are very helpful, but a man is a man with his circumstances. Each starting point is […]