Passionned Group™

Looker BI & Analytics

Business Partner
By: Daan van Beek MSc
Business Partner
Table of Contents

Below we show a concise summary of our recently updated, independent BI & Analytics research on the software vendor Looker and its portfolio of products (such as LookML, Looker Studio and Looker API). Looker BI & Analytics scores better in our survey than Yellowfin but slightly worse than InetSoft. Of all the categories in our research, Looker has the best performance in data discovery and has a poor performance in multidimensional models. Within the context of BI & Analytics, we have put together the main advantages and disadvantages of Looker Data Analytics, and present them by component (BI, Big Data, data analytics, AI and data science). We also point out the highlights of the main products such as LookML, Looker Studio and Looker API et cetera.

How does Looker BI & Analytics score on certain components?

In our survey we looked in detail at the various software products of Looker software. More than 720 evaluation criteria were examined. The graph below gives good insight into the strengths and weaknesses of Looker Data Analytics, compared to the competition. Please note that Passionned Group is 100% independent of the suppliers in the research. We are not a reseller, we do not make deals or have done business with the supplier. Among other things, we help and advise companies in the proper selection of BI tooling.

Score of Looker Data Analytics software.Figure 1: The pros and cons of the software vendor Looker BI & Analytics. A maximum of 100% can be obtained. Source: the BI & Analytics Guide 2023. Do you want more information about the survey structure? Click here to download this guide.

The Looker analysis was conducted by collecting a lot of public big data and from there it was extensively analyzed. More than 5,222 documents have reviewed from Looker in recent years. In this analysis process both algorithms and the critical eye of a senior BI expert played a key role in drawing conclusions.Looker BI & Analytics in our BI & Analytics Guide 2023. In our 100% vendor-independent BI & Analytics Guide we have collected all the ins and outs of Looker BI & Analytics for you.Enrich your knowledge and skills

Looker and their complete BI & Analytics product portfolio

Looker knows (a minimum of) 14 products in the realm of BI & Analytics. Starting with the most popular product of Looker BI & Analytics we list the most important products below:

What is Looker Data Analytics?

Other names by which this software product is known: Looker Business Intelligence, Looker BI, Looker Platform

Under this heading, we provide a description of Looker Data Analytics, including some of its features and any related products. This product group consists of LookML, Looker Studio, Looker API, LookML Dashboards, Looker Blocks, Looker Server, Looker mobile, Looker Embedded Analytics, Looker Retail, Looker Data Modeling, Looker Marketing Analytics, Looker Web Analytics and Looker Digital Marketing. The Looker Data Analytics can be best defined by the following features:

  • analytics
  • business intelligence
  • data analytics
  • BI
  • real-time analytics > real-time
  • business intelligence > reporting
  • analytics > analytics platform
  • business intelligence > reports
  • business intelligence > dashboards
  • data governance > data management > SQL

Are you curious about all the functionalities (100+) of Looker Data Analytics? Download directly our BI & Analytics Guide™ 2023 here.

Lacking capacity and want to hire an experienced Looker Data Analytics consultant?

Do you want to hire a freelance Looker Data Analytics developer who can do a mountain of work for you and implement an Looker Data Analytics application? Or do you want to develop an application for one of the related products like Looker API, Looker Platform and LookML? You can do so using our interim services. Indeed, hiring Looker Data Analytics developers is not always necessary and sometimes even inconvenient. Leave a message here and we will explore the possibilities of cooperation with you.

Screen shot of Looker Data Analytics software.
Picture of Looker Data Analytics tools.
Looker Data Analytics in action
Figure 2, 3 and 4: These three images give a first impression of Looker Data Analytics. Click on the image to enlarge it.

What is LookML?

In this paragraph, we portrait LookML, including some of its features and any related products. This product / group of products can be characterized by the following functionalities:

  • data governance > data management > SQL
  • business intelligence > dashboards
  • data discovery > analysis
  • BI infrastructure > open source
  • business intelligence > dashboard
  • BI infrastructure > Application Programming Interface
  • data connectivity > native
  • artificial intelligence > data science
  • data governance > data management > data modeling
  • performance optimization > caching

Do you want to know everything about all elements (100+) of LookML? Download the BI & Analytics Guide™ 2023 here.

What is Looker Studio?

Under this heading, we report the (main) characteristics of Looker Studio, including some of its features and any related products. This product / group of products can be best defined by the following characteristics:

  • business intelligence > reports
  • business intelligence > report
  • analytics
  • business intelligence > dashboards
  • BI infrastructure > API
  • business intelligence
  • data connectivity > Google Analytics
  • business intelligence > reporting
  • data discovery > data visualizations
  • BI infrastructure > embedded analytics

Are you curious about all characteristics (100+) of Looker Studio? Download directly our BI & Analytics Guide™ 2023 here.

What is Looker API?

Under this heading, we describe Looker API, including some of its features and any related products. This product / group of products can be best defined by the following functionalities:

  • BI infrastructure > API
  • BI infrastructure > Application Programming Interface
  • BI infrastructure > SDK
  • BI infrastructure > authentication
  • business intelligence > dashboards
  • BI infrastructure > authentication > API authentication
  • artificial intelligence > Python
  • BI infrastructure > authentication > OAuth
  • business intelligence > reporting
  • business intelligence

Are you now curious about all properties (100+) of Looker API? In that case open the BI & Analytics Guide™ 2023 here.

Screen shot of Looker API software.
Picture of Looker API tools.
Looker API in action
Figure 5, 6 and 7: Overlying images illustrate the functionality of Looker API. Click on the image to make it bigger.

What is LookML Dashboards?

In this section, we provide a description of LookML Dashboards, including some of its features and any related products. This product / group of products can be best characterized by the following features:

  • business intelligence > dashboards
  • business intelligence > dashboard
  • BI infrastructure > API
  • BI infrastructure > Application Programming Interface
  • data discovery > data visualization > map chart
  • data discovery > data visualization > waterfall chart
  • BI infrastructure > authentication > Single Sign-On
  • BI
  • business intelligence > reports
  • data discovery > data visualization > tiles

Do you want to know the intricacies of all characteristics (100+) of LookML Dashboards? Then download our BI & Analytics Guide™ 2023 here.

What is Looker Blocks?

In this paragraph, we report the (main) characteristics of Looker Blocks, including some of its features and any related products. This product can be defined by the following features:

  • analytics
  • business intelligence > reporting
  • data connectivity > Google BigQuery
  • BI infrastructure > scalability > Amazon Web Services
  • analytics > analytics platform
  • business intelligence > dashboards
  • data governance > data management > SQL
  • data discovery > analysis
  • real-time analytics > real-time

Do you want to know everything about all elements (100+) of Looker Blocks? Then download our BI & Analytics Guide™ 2023 here.

Screen shot of Looker Blocks software.
Picture of Looker Blocks tools.
Looker Blocks in action
Figure 8, 9 and 10: Several images show the operation of Looker Blocks. Click on the image to magnify.

What is Looker Server?

We don’t reveal everything here but, in this paragraph, we provide a description of Looker Server, including some of its features and any related products. Looker Server can be best characterized by the following features:

  • BI infrastructure > Application Programming Interface
  • BI infrastructure > SDK
  • analytics
  • business intelligence > dashboards
  • BI infrastructure > authentication > Single Sign-On
  • data governance > data management > SQL
  • business intelligence
  • analytics > analytics platform
  • BI infrastructure > authentication
  • BI infrastructure > API

Are you now curious about all the functionalities (100+) of Looker Server? Download the BI & Analytics Guide™ 2023 here.

What is Looker mobile?

In this paragraph, we provide a description of Looker mobile, including some of its features and any related products. The product Looker mobile can be best characterized by the following characteristics:

  • business intelligence > dashboards
  • business intelligence > dashboard
  • analytics
  • mobile business intelligence > Android
  • BI infrastructure > operating systems > iOS
  • BI
  • business intelligence > report
  • decision management > performance management > KPI
  • business intelligence
  • mobile business intelligence > iPhone

Are you curious about all the functionalities (100+) of Looker mobile? Then order the BI & Analytics Guide™ 2023 here.

What is Looker Embedded Analytics?

In this paragraph, we provide a description of Looker Embedded Analytics, including some of its features and any related products. The Looker Embedded Analytics can be best characterized by the following functionalities:

  • analytics
  • BI infrastructure > embedded analytics
  • business intelligence > reporting
  • business intelligence > report
  • BI infrastructure > API
  • BI infrastructure > authentication > SSO
  • BI infrastructure > SDK
  • business intelligence > dashboard
  • analytics > analytics platform

Are you now curious about all properties (100+) of Looker Embedded Analytics? Open the BI & Analytics Guide™ 2023 here.

What is Looker Retail?

In this paragraph, we provide a description of Looker Retail, including some of its features and any related products. This product can be best characterized by the following properties:

  • analytics > retail analytics
  • business intelligence
  • BI infrastructure > scalability > Amazon Web Services
  • data discovery > data visualization
  • data connectivity > Amazon Redshift
  • analytics > ecommerce analytics
  • real-time analytics > near real-time
  • real-time analytics > real-time
  • data discovery > analysis

Do you want to know the intricacies of all features (100+) of Looker Retail? In that case order the BI & Analytics Guide™ 2023 here.

What is Looker Data Modeling?

In this paragraph, we describe the key elements of Looker Data Modeling, including some of its features and any related products. This product can be characterized by the following characteristics:

  • data governance > data management > SQL
  • data governance > data management > data modeling
  • artificial intelligence > machine learning
  • data connectivity > Google BigQuery
  • BI infrastructure > Application Programming Interface > REST APIs
  • analytics
  • agile analytics
  • BI infrastructure > Application Programming Interface

Do you want to know the intricacies of all the functions (100+) of Looker Data Modeling? Download the BI & Analytics Guide™ 2023 here.

Screen shot of Looker Data Modeling software.
Picture of Looker Data Modeling tools.
Looker Data Modeling in action
Figure 11, 12 and 13: These three images give a first impression of Looker Data Modeling. Click on the image to make it bigger.

What is Looker Marketing Analytics?

We do not display here all the features but, in this paragraph, we display the details of Looker Marketing Analytics, including some of its features and any related products. This product / group of products can be characterized by the following properties:

  • analytics > marketing analytics
  • BI
  • business intelligence > dashboard
  • BI infrastructure > API
  • business intelligence > dashboards
  • data integration
  • artificial intelligence > machine learning
  • data discovery > analysis
  • data integration > ETL

Are you now curious about all elements (100+) of Looker Marketing Analytics? Download directly our BI & Analytics Guide™ 2023 here.

What is Looker Web Analytics?

In this part, we describe Looker Web Analytics, including some of its features and any related products. The Looker Web Analytics can be characterized by the following functionalities:

  • analytics > web analytics
  • analytics
  • business intelligence
  • data analytics
  • BI infrastructure > embedded analytics
  • business intelligence > business intelligence platform
  • BI infrastructure > API
  • big data
  • real-time analytics > real-time

Do you want to know the intricacies of all the functions (100+) of Looker Web Analytics? Then order the BI & Analytics Guide™ 2023 here.

Screen shot of Looker Web Analytics software.
Picture of Looker Web Analytics tools.
Looker Web Analytics in action
Figure 14, 15 and 16: Overlying figures show the operation of Looker Web Analytics. Click on an image to enlarge it.

What is Looker Digital Marketing?

In this section, we report the (main) characteristics of Looker Digital Marketing, including some of its features and any related products. The Looker Digital Marketing can be best characterized by the following functionalities:

  • business intelligence > dashboard
  • BI
  • analytics
  • business intelligence > dashboards
  • business intelligence > reports
  • data analytics
  • business intelligence > reporting
  • data discovery > analysis

Are you curious about all characteristics (100+) of Looker Digital Marketing? Download directly our BI & Analytics Guide™ 2023 here.

Innovations of Looker Data Analytics-tools and the version history

Lately, we see a positive trend when it comes to BI & Analytics functionality and support for various platforms and data sources. The latest added ‘gadgets’ are in the areas of > candlestick charts, data integration > data warehousing > ODS and data discovery > data visualization > gauge charts.

We reviewed Looker’s latest updates of its product portfolio. Below you can see the respective version numbers of all the ones known to us BI & Analytics products of Looker:

  • Looker API: 4.0 3.1
  • Looker Data Analytics: 192 23 22.20 22.16 22.12 22.10 22.8 22.6 22.4.35 21.20 21.4 7.0 6.6 5.14 4.6 0.1.3
  • Looker mobile: 1.2.5 january 1.2.5 1.2.1 1.2.0 may 1.2.0 1.1.1 february 1.1.0 january

Behind each product we mention the version numbers, the older the version the more backward the version is in the list.

What are the licensing costs of LookML, Looker Studio and Looker API?

It is difficult to determine exactly what a license of LookML, Looker Studio and Looker API costs because it depends on the country, the number of users (also consider the amount of CPUs for server versions), the connectors to data sources, and at what point in the year you request a quote. And before the end of a fiscal quarter of Looker, you may be able to look forward to a decent discount. In addition, we recommend running the software in the cloud, for the most part, you only pay for your consumption then. The purchase cost of LookML, Looker Studio and Looker API may not be the single largest expense, but maintenance and support can certainly put quite a strain on your annual budget.

What makes Looker BI & Analytics unique compared to other BI platforms

In our study, we see that Looker in the field of BI & Analytics software has several specific features which emerged distinctively in our research. This makes Looker Data Analytics more or less unique: motion charts, ab testing, customer profitability analysis, funnel analysis and profitability analysis.

The advantages and disadvantages of Looker Data Analytics

Tag cloud of the Looker Data Analytics tools.Figure 17: Tag cloud of the strengths and weaknesses of Looker BI & Analytics

In the following paragraphs, we name all the advantages and disadvantages of Looker BI & Analytics, LookML, Looker Studio and Looker API, et cetera. The listing in the following paragraphs is subject to change, because: Looker can currently work to improving existing and developing new functionality at this time (such as support for Salesforce, OLAP, active directory, predictive analytics, high availability, Kerberos, in-memory, sentiment analysis, IIS and MDX). It may also be that a feature has not yet been adequately described.

Share your experience with Looker BI & Analytics

Report your experience with Looker BI & Analytics here. Your observations may then be taken into consideration in an even better assessment of the performance of Looker Data Analytics.

1. Looker Data Discovery

56%

The vendor Looker has a good rating in our objective BI & Analytics survey on the section ‘Data Discovery’. The score amounts to 56%, relative to other vendors. The following criteria were used: time series, standard deviation, data storytelling and share insights. In total, we examined 398 criteria in this category. Would you like to delve further into the topic ‘Data Discovery’? Then download here our BI & Analytics Guide 2023.

2. Looker Business Intelligence

52%

The vendor Looker has a good score in our current BI & Analytics survey on the section ‘Business Intelligence’. The score amounts to 52%, relative to other vendors. We used the following selection criteria: reporting and business intelligence platform. In doing so, we looked at the following five products: Looker Web Analytics, Looker Data Analytics, Looker API, Looker Retail and Looker Blocks. In total, we examined 73 selection criteria within this main theme. Would you like to go into more depth with the topic ‘Business Intelligence’? Then download here our BI & Analytics Guide 2023. Or take a deep dive in the following content:

3. Looker Data Connectivity

51%

Looker has a good score in our current BI & Analytics survey of the theme ‘Data Connectivity’. The company scores 51% on this topic, compared to other vendors. We looked at the following criteria, among others: Sharepoint, Salesforce, Teradata, Amazon Redshift, PostgreSQL, Google BigQuery and Microsoft Excel. In total, we examined 91 features within this discipline. Would you like to learn more about the topic ‘Data Connectivity’? Then download here our BI & Analytics Study 2023.

4. Looker BI Infrastructure

46%

Looker has a moderate rating in our independent BI & Analytics survey on the subject ‘BI Infrastructure’ with a score of 46%, relative to other vendors. The following criteria were used: infrastructure, repository, open source, web services, web server and hybrid cloud. In total, we examined 162 criteria in this category. Would you like to learn more about the topic ‘BI Infrastructure’? Then download here our BI & Analytics Guide 2023.

5. Looker Performance Optimization

43%

The company has a moderate performance in our 100% vendor-independent BI & Analytics survey of the theme ‘Performance Optimization’. The score amounts to 43%, relative to other vendors. We looked at the following criteria, among others: parallel processing, data pipelines, materialized views and cache settings. In total, we examined 29 criteria in this category. Would you like to learn more about the topic ‘Performance Optimization’? Then download here our BI & Analytics Guide 2023.

6. Looker Self-service BI

33%

Looker has a moderate performance in our independent BI & Analytics survey on the subject ‘Self-service BI’ with a score of 33%, compared to other vendors. We looked at the following criteria, among others: self-service data preparation, self-service reporting, self-service analysis, self-service data discovery and self-service data analytics. In total, we examined 14 criteria in this category. Would you like to learn more about the topic ‘Self-service BI’? Then download here our BI & Analytics Study.

7. Looker Analytics

32%

Looker has a moderate performance in our 100% vendor-independent BI & Analytics survey of the theme ‘Analytics’ with a score of 32%, relative to other vendors. We looked at the following criteria, among others: analytics platform, process analytics and performance analytics. In doing so, we looked at the following five products: LookML, Looker Web Analytics, Looker Data Analytics, Looker API and Looker Retail. In total, we examined 130 criteria in this category. Would you like to delve further into the topic ‘Analytics’? Then download here our BI & Analytics Guide 2023.

8. Looker Artificial Intelligence

31%

The company has a moderate performance in our independent BI & Analytics survey on the subject ‘Artificial Intelligence’ with a score of 31%, relative to other vendors. We looked at the following criteria, among others: machine learning, R, algorithms, natural language processing, linear regression and business rules. In total, we examined 181 selection criteria within this main theme. Would you like to learn more about the topic ‘Artificial Intelligence’? Then download here our BI & Analytics Guide 2023. Or take a deep dive in the following content:

9. Looker Data Governance

30%

The vendor Looker has a moderate rating in our 100% vendor-independent BI & Analytics survey on the section ‘Data Governance’ with a score of 30%, relative to other vendors. We looked at the following criteria, among others: data management, data quality, data catalog, data encryption, data lineage and data acquisition layer. In total, we examined 91 criteria in this category. Would you like to learn more about the topic ‘Data Governance’? Then download here our BI & Analytics Guide 2023.

10. Looker Big Data

30%

The vendor Looker has a moderate rating in our current BI & Analytics survey on the section ‘Big Data’ with a score of 30%, relative to other vendors. The following criteria were used: streaming, unstructured data, sensors, Blob storage, sensor data, big data integration and big data processing. In total, we examined 59 criteria in this category. Would you like to learn more about the topic ‘Big Data’? Then download here our BI & Analytics Guide 2023. Or take a deep dive in the following content:

11. Looker Data Integration

29%

The vendor Looker has a poor performance in our objective BI & Analytics survey on the section ‘Data Integration’. The score amounts to 29%, relative to other vendors. We looked at the following criteria, among others: data warehousing, data hub and data virtualization. In total, we examined 76 criteria in this category. Would you like to learn more about the topic ‘Data Integration’? Then download here our BI & Analytics Study 2023.

12. Looker Mobile Business Intelligence

28%

The vendor Looker has a poor score in our objective BI & Analytics survey on the subject ‘Mobile Business Intelligence’ with a score of 28%, relative to other vendors. We looked at the following criteria, among others: push notification, mobile server, mobile analytics, mobile dashboards and mobile push notifications. In total, we examined 10 criteria in this category. Would you like to go into more depth with the topic ‘Mobile Business Intelligence’? Then download here our BI & Analytics Study 2023.

13. Looker Real-time Analytics

28%

The company has a poor performance in our 100% vendor-independent BI & Analytics survey on the subject ‘Real-time Analytics’ with a score of 28%, relative to other vendors. We looked at the following criteria, among others: real-time, real-time data, near real-time, real-time insights, real-time data warehousing and real-time big data. In total, we examined 19 features within this discipline. Would you like to learn more about the topic ‘Real-time Analytics’? Then download here our BI & Analytics Guide.

14. Looker Decision Management

21%

The company has a poor performance in our 100% vendor-independent BI & Analytics survey on the section ‘Decision Management’ with a score of 21%, relative to other vendors. We looked at the following criteria, among others: performance management, decision support, decision-making platform, enterprise decision management and real-time decisioning. In total, we examined 30 criteria in this category. Would you like to delve further into the topic ‘Decision Management’? Then download here our BI & Analytics Guide. Or take a deep dive in the following content:

15. Looker Multidimensional Models

9%

The vendor Looker has a poor score in our objective BI & Analytics survey on the subject ‘Multidimensional Models’ with a score of 9%, relative to other vendors. We considered the following factors: OLAP, DAX, MOLAP, ROLAP and tabular data models. In total, we examined 14 selection criteria within this main theme. Are you planning to specialize further in the topic ‘Multidimensional Models’? Then download here our BI & Analytics Guide 2023.

Want to know more? Then order the BI & Analytics Guide™ 2023 here

In which sectors is Looker BI & Analytics most active?

In our recently updated, independent BI & Analytics research on, we also looked at which industries a supplier has a track record. These are the industries where Looker is most popular: automotive, energy, insurance, manufacturing and retail.

Looker software is most used by…

The BI & Analytics software from Looker is most often mentioned in combination with the following function: data analysts.

Hire a competent Looker programmer

Education and training course Looker BI & Analytics

We provide various training courses in the field of BI & Analytics but can also provide specific Looker training, for example as incompany. Then think about the following software: LookML, Looker Studio and Looker API. Of course we color such a training with the ideas of the intelligent, data-driven organization.

Final Verdict: Looker Data Analytics scores reasonably well

Looker has a compact product portfolio with which it scores reasonably well in our BI & Analytics survey. Looker BI & Analytics innovates (approximately) at an average rate of more than 15 features per year, is active (for now) in many different sectors, and has developed best in data discovery.

About Passionned Group

logo of Passionned Group, the Looker BI & Analytics specialistPassionned Group specializes in 100% independent BI & Analytics consulting and the implementation of BI & Analytics solutions. Our dedicated and passionate consultants help large & small organizations to advance as intelligent, data-driven organizations.

Get in touch with us

A selection of our customers

Become a customer with us now

Do you also want to become a customer of ours? We are happy to help you with data-driven working or other things that will make you smarter.

Daan van Beek - Business Partner

DAAN VAN BEEK MSc

Business Partner

Contact me directly

Fact sheet

Number of organizations serviced ___
Number of training courses ___
Number of participants trained ___
Overall customer rating 4.7 stars
Number of consultants & teachers ___
Number of offices 3
Number of years active 18