Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitk1609
Specialist III
Specialist III

How Qlik Sense is better than Looker

Hi Techies,

Can anyone tell me in detail with facts how Qlik Sense is better than Looker BI tool ?

 

Thanks,

Rohit

Labels (1)
1 Solution

Accepted Solutions
mr_novice
Creator II
Creator II

Hi,

I'm (or was) a qlikview developer but have been working with Looker the last year.

I think you need to realize that Looker works differently. Looker does not store any data. It's like an SQL editor with visualization where you may model your data and distribute the model between different dashboards, objects etc. All of these reachable through an API so you can let external/internal apps connect through rest-api to fetch data that you already modelled. The models are converted to SQL when you run a dashboard, graph, query...This "semantic layer" is created with "Look ML" that is very simple to use.

If you want, Looker may also cache the results of each query you run to display results faster next time. The models created can be extended, imported and/or browsed by users and developers in other projects. Users can drag/drop dimensions and measures and create their own calculations. All of these are translated to sql by looker using the models created.

My comments below.

Three things I found best in Qlik Sense than Looker:
1. Better way of connecting to data sources in Qlik than looker. Looker is based on API connectivity mostly or its very complex to connect looker to like MSQL, needs SSL SSH tunnel which are complex.

1.1 Looker connects to a lot of different databases such as MSSQL, BigQuery, etc Havent needed to use ssl or SSH yet but then I have only worked with cloud based solutions like azure dw, snowflake, bigquery.


2. Qlik ETL is powerful and can solve complex use cases especially create missing data which is not available like master calendar creates such date records which are not present in data.
Looker has ETL but not so much powerful and no capability to view data model architecture.

2.1 Anything you can do in SQL, you can do in Looker and even more. You may also let Looker schedule and run your queries and save the result back to the source database which lets you create some form of transformation. Looker lets the source database do the heavy lifting. Calendars can be created in SQL so no problems there. And yes, you may see the model architecture but not in a nice "star schema" as in Qlik. Looker scaffolds the code it needs to help you out too.


3. Variety of charts, 3rd party extension comes in Qlik but I am not sure looker has also 3rd party extension cap

3.1 Looker have 3rd party extensions and "blocks" which are like dashboards, models, connections all together. 


4. looker is cloud based, not sure how it deals with load balancing.

4.1 Looker is cloud based on AWS or GCP. On-premise version is available as well. Load balancing? this is taken care of by Looker on the platform you use. No need to worry about the infrastructure, its "under the hood" at least on the standard cloud version.


5. Looker is good with API data sources.

5.1 Yes and Lookers rest-api is nice to use. 


6. Not much tutorial content is available for free on internet

6.1 Their website have a lot of information and I think you must register (free) to access all tutorials.

 

Any way, I think there's no "best" tool to do it all. If you compare feature by feature Qlik will be better I think but Qlik have like 20 years of "lead" right?  It all depends on what the customer needs to do with the BI-tool. What infrastructure they have, if they're using cloud DW or not. Looker is doing great stuff and growing fast so there's more to come!

View solution in original post

7 Replies
miguelbraga
Specialist III
Specialist III

Hi there,

 

I don't even recall to hear from Looker BI tool. It's so unpopular that it doesn't appear in Gartner Magic Quadrant BI in February 2018. So my view about this subject is limited and based on this picture:high-res.jpg

I assume that Looker BI is weaker, but I'll investigate more about this.

 

Best regards,

MB

Ivan_Bozov
Luminary
Luminary

Looker appears as a leader in a couple of G2 Crowd  quadrants. They are similar to the Gartner magic quadrant but based on reviews from the user community. Not sure how accurate they are as Qlik is not even present in the quadrants for Data Visualization Software or Embedded Business Intelligence Software.

Anyway, I have not worked with the tool, but there are some videos online that you can check, e.g. https://www.youtube.com/watch?v=ytHf3nq_LCY or https://www.youtube.com/watch?v=Hvw44QNTgRc

To me it looks like that you need to use filters and the graphs (tiles) are not connected to each other (at least not by default) which would limit the data exploration capabilities (see the second video, 1:33). The associative engine and the possibility to make multiple selections are main strengths of Qlik and it appears that Looker is missing these functionalities.

vizmind.eu
rohitk1609
Specialist III
Specialist III
Author

I do agree with you but when I read this Gartner article, it makes me confuse
https://www.gartner.com/reviews/market/analytics-business-intelligence-platforms/compare/looker-vs-q...

I do believe Qlik has best QIX engine. ETL and powerful set analysis for creating measures but I am trying to gathering facts to prove is Qlik is best than looker

Please share your inputs.
Thanks,
Rohit
rohitk1609
Specialist III
Specialist III
Author

I saw these URLs before, no facts just rating on names.
rohitk1609
Specialist III
Specialist III
Author

Three things I found best in Qlik Sense than Looker:
1. Better way of connecting to data sources in Qlik than looker. Looker is based on API connectivity mostly or its very complex to connect looker to like MSQL, needs SSL SSH tunnel which are complex.
2. Qlik ETL is powerful and can solve complex use cases especially create missing data which is not available like master calendar creates such date records which are not present in data.
Looker has ETL but not so much powerful and no capability to view data model architecture.
3. Variety of charts, 3rd party extension comes in Qlik but I am not sure looker has also 3rd party extension cap
4. looker is cloud based, not sure how it deals with load balancing.
5. Looker is good with API data sources.
6. Not much tutorial content is available for free on internet

These are my analysis till now, Can you please add your inputs ?

Thanks,
Rohit
mr_novice
Creator II
Creator II

Hi,

I'm (or was) a qlikview developer but have been working with Looker the last year.

I think you need to realize that Looker works differently. Looker does not store any data. It's like an SQL editor with visualization where you may model your data and distribute the model between different dashboards, objects etc. All of these reachable through an API so you can let external/internal apps connect through rest-api to fetch data that you already modelled. The models are converted to SQL when you run a dashboard, graph, query...This "semantic layer" is created with "Look ML" that is very simple to use.

If you want, Looker may also cache the results of each query you run to display results faster next time. The models created can be extended, imported and/or browsed by users and developers in other projects. Users can drag/drop dimensions and measures and create their own calculations. All of these are translated to sql by looker using the models created.

My comments below.

Three things I found best in Qlik Sense than Looker:
1. Better way of connecting to data sources in Qlik than looker. Looker is based on API connectivity mostly or its very complex to connect looker to like MSQL, needs SSL SSH tunnel which are complex.

1.1 Looker connects to a lot of different databases such as MSSQL, BigQuery, etc Havent needed to use ssl or SSH yet but then I have only worked with cloud based solutions like azure dw, snowflake, bigquery.


2. Qlik ETL is powerful and can solve complex use cases especially create missing data which is not available like master calendar creates such date records which are not present in data.
Looker has ETL but not so much powerful and no capability to view data model architecture.

2.1 Anything you can do in SQL, you can do in Looker and even more. You may also let Looker schedule and run your queries and save the result back to the source database which lets you create some form of transformation. Looker lets the source database do the heavy lifting. Calendars can be created in SQL so no problems there. And yes, you may see the model architecture but not in a nice "star schema" as in Qlik. Looker scaffolds the code it needs to help you out too.


3. Variety of charts, 3rd party extension comes in Qlik but I am not sure looker has also 3rd party extension cap

3.1 Looker have 3rd party extensions and "blocks" which are like dashboards, models, connections all together. 


4. looker is cloud based, not sure how it deals with load balancing.

4.1 Looker is cloud based on AWS or GCP. On-premise version is available as well. Load balancing? this is taken care of by Looker on the platform you use. No need to worry about the infrastructure, its "under the hood" at least on the standard cloud version.


5. Looker is good with API data sources.

5.1 Yes and Lookers rest-api is nice to use. 


6. Not much tutorial content is available for free on internet

6.1 Their website have a lot of information and I think you must register (free) to access all tutorials.

 

Any way, I think there's no "best" tool to do it all. If you compare feature by feature Qlik will be better I think but Qlik have like 20 years of "lead" right?  It all depends on what the customer needs to do with the BI-tool. What infrastructure they have, if they're using cloud DW or not. Looker is doing great stuff and growing fast so there's more to come!

View solution in original post