Looker BI & Analytics

Photo Daan van Beek MSc
Author: 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 ThoughtSpot but slightly worse than Yellowfin. 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 2024. 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,377 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 in our BI & Analytics Guide 2024 Image of Looker in our BI & Analytics Guide 2024In our 100% vendor-independent BI & Analytics Guide we have collected all the ins and outs of Looker for you. You get access to hundreds of (shorter) trainings, tech talks, lectures, demos, tutorials, and so on and always have the latest BI & AI news. This guide will additionally assist you in profoundly improve your knowledge about BI & Analytics.view the BI & Analytics Guide™

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:

  • analysis
  • analytics
  • analytics platform
  • business intelligence
  • dashboards
  • data modeling
  • data visualization
  • embedded analytics
  • infrastructure
  • SQL

Are you curious about all the functionalities (100+) of Looker Data Analytics? Download directly our BI & Analytics Guide™ 2024 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? 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. Credits: Looker & partners.

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:

  • analytics
  • caching
  • dashboards
  • data modeling
  • embedded analytics
  • SQL

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

Screen shot of LookML software.
Picture of LookML tools.
LookML in action
Figure 5, 6 and 7: Various figures show the operation of LookML. Click on the image to enlarge it. Credits: Looker & partners.

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:

  • analytics
  • business intelligence
  • business intelligence platform
  • dashboards
  • data visualization
  • embedded analytics
  • Google Analytics
  • real-time insights
  • reporting
  • share insights

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

Screen shot of Looker Studio software.
Picture of Looker Studio tools.
Looker Studio in action
Figure 8, 9 and 10: Overlying figures show the operation of Looker Studio. Click on an image to magnify. Credits: Looker & partners.

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:

  • API authentication
  • Application Programming Interface
  • authentication
  • business intelligence platform
  • embedded analytics
  • infrastructure
  • OAuth
  • Python
  • repository
  • SDK

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

Screen shot of Looker API software.
Picture of Looker API tools.
Looker API in action
Figure 11, 12 and 13: Overlying images illustrate the functionality of Looker API. Click on the image to make it bigger. Credits: Looker & partners.

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:

  • analytics
  • dashboards
  • map chart
  • self-service BI
  • tiles

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

Screen shot of LookML Dashboards software.
Picture of LookML Dashboards tools.
LookML Dashboards in action
Figure 14, 15 and 16: Overlying images illustrate the functionality of LookML Dashboards. Click on an image to enlarge it. Credits: Looker & partners.

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:

  • analysis
  • analytics
  • analytics hub
  • business intelligence
  • custom visualizations
  • dashboards
  • embedded analytics
  • Google Analytics
  • retail analytics
  • SQL

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

Screen shot of Looker Blocks software.
Picture of Looker Blocks tools.
Looker Blocks in action
Figure 17, 18 and 19: Several images show the operation of Looker Blocks. Click on the image to magnify. Credits: Looker & partners.

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:

  • analytics
  • authentication
  • business intelligence
  • business intelligence platform
  • dashboards
  • data catalog
  • embedded analytics
  • interactive dashboards
  • java
  • SDK

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

Screen shot of Looker Server software.
Picture of Looker Server tools.
Looker Server in action
Figure 20, 21 and 22: Overlying figures show the operation of Looker Server. Click on the image to magnify. Credits: Looker & partners.

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:

  • analytics
  • Android
  • business intelligence
  • business intelligence platform
  • dashboards
  • embedded analytics
  • iOS
  • iPhone
  • KPI
  • real-time

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

Screen shot of Looker mobile software.
Picture of Looker mobile tools.
Looker mobile in action
Figure 23, 24 and 25: Overlying figures show the operation of Looker mobile. Click on the image to enlarge it. Credits: Looker & partners.

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
  • analytics platform
  • business intelligence
  • business intelligence platform
  • embedded analytics
  • high availability
  • iOS
  • real-time insights
  • SDK
  • share insights

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

Screen shot of Looker Embedded Analytics software.
Picture of Looker Embedded Analytics tools.
Looker Embedded Analytics in action
Figure 26, 27 and 28: These three images give a first impression of Looker Embedded Analytics. Click on an image to make it bigger. Credits: Looker & partners.

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
  • business intelligence
  • business intelligence platform
  • cloud computing
  • CRM
  • dashboards
  • data discovery
  • embedded analytics
  • real-time
  • retail analytics

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

Screen shot of Looker Retail software.
Picture of Looker Retail tools.
Looker Retail in action
Figure 29, 30 and 31: Overlying figures show the operation of Looker Retail. Click on an image to magnify. Credits: Looker & partners.

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:

  • analysis
  • analytics
  • business intelligence
  • dashboards
  • data governance
  • data management
  • data modeling
  • reporting
  • SQL
  • SQL database

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

Screen shot of Looker Data Modeling software.
Picture of Looker Data Modeling tools.
Looker Data Modeling in action
Figure 32, 33 and 34: These three images give a first impression of Looker Data Modeling. Click on the image to make it bigger. Credits: Looker & partners.

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:

  • analysis
  • analytics
  • complex data
  • dashboards
  • data integration
  • Google BigQuery
  • machine learning
  • marketing analytics

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

Screen shot of Looker Marketing Analytics software.
Picture of Looker Marketing Analytics tools.
Looker Marketing Analytics in action
Figure 35, 36 and 37: These three images give a first impression of Looker Marketing Analytics. Click on an image to make it bigger. Credits: Looker & partners.

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:

  • analysis
  • analytics
  • big data
  • business intelligence
  • business intelligence platform
  • data science
  • embedded analytics
  • real-time
  • SQL
  • web analytics

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

Screen shot of Looker Web Analytics software.
Picture of Looker Web Analytics tools.
Looker Web Analytics in action
Figure 38, 39 and 40: Overlying figures show the operation of Looker Web Analytics. Click on an image to enlarge it. Credits: Looker & partners.

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:

  • analysis
  • analytics
  • analytics platform
  • business intelligence
  • dashboards
  • data discovery
  • data visualization
  • interactive dashboards
  • reporting
  • web analytics

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

Screen shot of Looker Digital Marketing software.
Picture of Looker Digital Marketing tools.
Looker Digital Marketing in action
Figure 41, 42 and 43: Overlying images illustrate the functionality of Looker Digital Marketing. Click on the image to enlarge it. Credits: Looker & partners.

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: 2023 2022 192 23.14 23.12 23.6 23.4.1 23.0 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, flow analytics, profitability analysis, customer profitability analysis and conditional colors.

The advantages and disadvantages of Looker Data Analytics

Tag cloud of the Looker Data Analytics tools.Figure 44: 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 OLAP, active directory, ad hoc reporting, predictive analytics, Blob storage, cube, EMR, MDX, machine learning algorithms and financial planning). 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

55%

The vendor Looker has a good rating in our objective BI & Analytics survey on the section ‘Data Discovery’. The score amounts to 55%, 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 2024.

2. Looker Data Connectivity

51%

The vendor Looker has a good score in our current BI & Analytics survey on the section ‘Data Connectivity’. The score amounts to 51%, relative to other vendors. We used the following selection criteria: Sharepoint and PostgreSQL. In total, we examined 91 selection criteria within this main theme. Would you like to go into more depth with the topic ‘Data Connectivity’? Then download here our BI & Analytics Guide 2024.

3. Looker Business Intelligence

50%

Looker has a good score in our current BI & Analytics survey of the theme ‘Business Intelligence’. The company scores 50% on this topic, compared to other vendors. We looked at the following criteria, among others: reporting, dashboards, CRM, business intelligence platform, enterprise business intelligence and business process monitoring. In doing so, we assessed the following five products: Looker Data Modeling, Looker Web Analytics, Looker Data Analytics, Looker Retail and Looker Blocks. In total, we examined 73 features within this discipline. Would you like to learn more about the topic ‘Business Intelligence’? Then download here our BI & Analytics Study 2024.

4. Looker BI Infrastructure

44%

Looker has a moderate rating in our independent BI & Analytics survey on the subject ‘BI Infrastructure’ with a score of 44%, 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 2024.

5. Looker Performance Optimization

39%

The company has a moderate performance in our 100% vendor-independent BI & Analytics survey of the theme ‘Performance Optimization’. The score amounts to 39%, 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 2024.

6. Looker Self-service BI

36%

Looker has a moderate performance in our independent BI & Analytics survey on the subject ‘Self-service BI’ with a score of 36%, 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 Data Governance

33%

Looker has a moderate performance in our 100% vendor-independent BI & Analytics survey of the theme ‘Data Governance’ with a score of 33%, relative to other vendors. We looked at the following criteria, among others: data management, data quality and data catalog. In total, we examined 91 criteria in this category. Would you like to delve further into the topic ‘Data Governance’? Then download here our BI & Analytics Guide 2024.

8. Looker Artificial Intelligence

32%

The company has a moderate performance in our independent BI & Analytics survey on the subject ‘Artificial Intelligence’ with a score of 32%, 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 2024. Or take a deep dive in the following content:

9. Looker Analytics

31%

The vendor Looker has a moderate rating in our 100% vendor-independent BI & Analytics survey on the section ‘Analytics’ with a score of 31%, relative to other vendors. We looked at the following criteria, among others: analytics platform, customer analytics, retail analytics, marketing analytics, HR analytics, process analytics and performance analytics. In doing so, we assessed the following five products: Looker Data Modeling, Looker Web Analytics, Looker Data Analytics, Looker Retail and Looker Blocks. In total, we examined 130 criteria in this category. Would you like to learn more about the topic ‘Analytics’? Then download here our BI & Analytics Guide 2024.

10. Looker Real-time Analytics

31%

The vendor Looker has a moderate rating in our current BI & Analytics survey on the section ‘Real-time Analytics’ with a score of 31%, relative to other vendors. The following criteria were used: real-time, real-time data, near real-time, real-time insights, real-time big data, real-time data warehousing and real-time streaming data. In total, we examined 19 criteria in this category. Would you like to learn more about the topic ‘Real-time Analytics’? Then download here our BI & Analytics Guide 2024.

11. Looker Data Integration

30%

The vendor Looker has a moderate performance in our objective BI & Analytics survey on the section ‘Data Integration’. The score amounts to 30%, 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 2024.

12. Looker Decision Management

29%

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

13. Looker Big Data

27%

The company has a poor performance in our 100% vendor-independent BI & Analytics survey on the subject ‘Big Data’ with a score of 27%, relative to other vendors. We looked at the following criteria, among others: streaming, unstructured data, sensors, Blob storage, sensor data and big data integration. In total, we examined 59 features within this discipline. Would you like to learn more about the topic ‘Big Data’? Then download here our BI & Analytics Guide.

14. Looker Mobile Business Intelligence

25%

The company has a poor performance in our 100% vendor-independent BI & Analytics survey on the section ‘Mobile Business Intelligence’ with a score of 25%, 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 delve further into the topic ‘Mobile Business Intelligence’? Then download here our BI & Analytics Guide.

15. Looker Multidimensional Models

12%

The vendor Looker has a poor score in our objective BI & Analytics survey on the subject ‘Multidimensional Models’ with a score of 12%, relative to other vendors. We considered the following factors: OLAP, DAX, ROLAP, MOLAP 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 2024.

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

In which sectors is Looker BI & Analytics most active?

In our research, 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.

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. In these sessions, we delve into various software applications including 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 minimal 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

You May Also Like

Featured image Creatio CRM & Customer Interaction
Creatio CRM & Customer Interaction
Featured image Tibco ETL & Data Integration
Tibco ETL & Data Integration
Featured image Adeptia ETL & Data Integration
Adeptia ETL & Data Integration

A selection of our customers

Become a customer 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.

Photo Daan van Beek - Business PartnerDAAN VAN BEEK MScBusiness Partner

Contact me directly

Fact sheet

___
customers
___
training courses
___
people trained
9.3
customer satisfaction
___
consultants & teachers
3
offices
19
years of experience