Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Qlik Sense vs Power BI & Tableau

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
robert99
Specialist III
Specialist III

Qlik Sense vs Power BI & Tableau

Last Update:

Nov 13, 2019 7:59:33 PM

Updated By:

robert99

Created date:

Nov 28, 2016 3:45:26 AM

Attachments

Qlik Sense vs Power BI & Tableau.

Labels (2)
Comments
mmarchese
Creator II
Creator II

Joe,

1. You just blew my mind!  Thanks for pointing that out!  A right-click option for chart-type changing would be nice for new users who haven't discovered such tricks yet.

2. Cool extensions!  I will try those out.  When you said, "Small-multiples are certainly possible in Qlik Sense," did you mean that QS can do something regarding chart arrays right out of the box?  If so, how?  Or is it necessary to get one of those two extensions?

3.That brings up another, broader point: that the number of object types built into Qlik Sense is pretty limited, forcing users to rely on extensions a lot.  Some extensions cover very basic features that really should have been there to begin with, like filtering based on a date range or setting a variable's value from a sheet (both are built into Tableau).  In the brief sampling I did of extensions, it seemed like there was a high chance that a given extension would be buggy, awkward/difficult to use, or styled in a way that doesn't match built-in objects.  Buggy extensions were sometimes catastrophically buggy (the grid-size-changing one corrupted my app) and sometimes abandoned long ago by the original developer, with no one else having picked up the torch in the meantime.  I'm glad that extensions exist in general, but the more that is built-in and robust, the better.

4. Another problem I thought of with Qlik as compared to the others is that Qlik can't show multiple hierarchy levels at once on a single axis of a graph (as far as I know - maybe I'm wrong again).  For example, look at the Excel pivot chart below.  In Qlik, I could make a Region > State > Category drill-down dimension to drill into the data, but what if I wanted to see sums by Category (and Size) for the Categories inside multiple States/Regions at the same time (instead of having to drill into just one State inside just one Region)?  Qlik's pivot table does this just fine, but I don't think any of the graphs do.  I couldn't find an extension for it either.  I imagine I'd have to create a dual dimension that concatenated Region, State, and Category into a single string while also maintaining the correct sort order?  I think that's basically what Power BI is doing automatically behind the scenes.  And Tableau just shows something similar to what Excel shows in the picture below, which is both nicer-looking and easier to understand.

pivot chart.png

nevets22
Contributor III
Contributor III

Yes, thanks for the response -- had no idea you could drag one object on top of another and simply convert it. Hugeeeeee time-saver!

robert99
Specialist III
Specialist III

HI Michael

3. I mostly agree. But things are improving on the free extensions front. For example the variables input extension is excellent. And hopefully it will continue working for future releases

But I don't have an issue with the built in date filtering. Its personal preference but I clearly prefer the way Qlik Sense does it. It provides more options

- I often prefer one calendar for all the various dates, This can be done using canonical dates or a date Island. It stops users filtering using the wrong date eg order date when sales date is required

- Alternatively the new derived dates enables calendars for dates to be easily set up

Derived Dates.JPG

or the traditional calendars can be set up

What I've moved to now is a lot more date filtering in charts. Just drag the mouse for the months required (in yellow)

Date Filtering.JPG

But its personal preference. I don't like the for example the new Power BI Timeline Slicer. But it was highly requested

From the Power BI web Site

"This week, I am thrilled to introduce the newest member of the custom visuals family – Timeline Slicer. This Slicer was the top request visual on our community’s User Voice. Ain’t it great to scratch this one off?!?"

robert99
Specialist III
Specialist III

"4. Another problem I thought of with Qlik as compared to the others is that Qlik can't show multiple hierarchy levels at once on a single axis of a graph (as far as I know - maybe I'm wrong again)."

As far as I know this is correct. Sense allows either

Option A. Only one or two dimensions and one measure only or

Option B. One dimension with many measures

I tend to prefer Option B with a dimension drill down (or around) if required.

I'm unsure why this restriction was built in. As Qlik View allowed any number of dimensions and measures. Although I always used drill down or drill around using Qlik View except for a pivot table

Combo Chart.JPG

after drill down (different layout)

Combo Drill3.JPG

robert99
Specialist III
Specialist III

I have updated this report to include

  • A section on loading data only once.
  • A Power BI vs Sense cloud comparison.
  • Some updates required for the latest Power BI release.
0 Likes
shivanandk
Partner - Creator II
Partner - Creator II

Hi !

Great document for comparison. Also can you add your comments on the domo BI tool.

Thanks,

SK

0 Likes
robert99
Specialist III
Specialist III

Hi shivanand

I had a very quick look at Domo some time back. But not in any depth. And I intend now to mainly focus on Power BI vs Sense. But to keep an eye on Tableau and Quick Sight for any major changes.

It takes so much time to do a fair comparison and I haven't the time (or interest) to do more than the above.

0 Likes
robert99
Specialist III
Specialist III

I have updated this report to include recent changes by Power BI and Sense. And have added a new section comparing coloring options for Power BI and Qlik Sense.

0 Likes
Anonymous
Not applicable

Hi Robert!

Thanks for the great comparison, much appreciated.

But i wonder, whith every update, do you change your ratings too?

Thanks for your answer!

0 Likes
robert99
Specialist III
Specialist III

Hi Diego

I mainly focusing on Power BI vs Qlik Sense now. But yes I do where appropriate. For example Power BI has added features and make filtering better but more complex. So my next rating will now reflect this. I hope to finish another update soon.

0 Likes
Contributors
Version history
Last update:
‎2019-11-13 07:59 PM
Updated by: