...

Looker Visualisations

Adrien Boutreau
February 17, 2020
Read: 4 min

Looker offers a wide range of visualisation options such as pie charts, funnels, and single-value metrics. However, as you are working with stakeholders in different business contexts, you occasionally need to showcase data in a way that is not readily available.

For example, let’s say you want to represent customer journeys on a website using a flow chart. Or maybe a hierarchy of categories in a tree-based model. Or just a catchy view of a single record?

Luckily, Looker enables us to import and use custom visualizations in addition to prebuilt chart types.

liquid gauge

Before Looker 7.0

How to add them?

You can add any existing visualizations from the Visualizations Panel in the Admin Board.

Admin Visualizations

On this board, you can add a new visualization.

To add a new chart type, fill in the “ID“ and “Label” fields. Keep in mind that when you select a visualization, the Label you chose will appear as a title in the Visualization header.

Explore Visualization

Looker has developed some example visualizations, which are available on their Github Repository and on their website. It is also possible to create a viz from scratch using this guide that explains how to set up a simple visualization script.

How to use them?

Once added, the custom visualizations are immediately available in any Explore of your choice. What’s important is that you select the necessary number of fields.

For example, the Sankey chart is a type of flow diagram that needs at least 2 dimensions and 1 measure. But for the Collapsible Tree, which shows parent-to-child relationships, you need 2 or more dimensions.

In our example of a customer journey, we track customer actions on an e-commerce website using Snowplow. Thanks to this Sankey diagram, we can easily visualize usage patterns.

customer journey sankey

Alternatively, with the same data and the Chord visualization type, we have been able to explore the flow of users between linked pages:

customer journey chord

Or we can display a Retail Department Hierarchy, for example, using a Collapsible Tree.

grocery categories

Another catchy option for visualizing parts of a whole together with hierarchical data is the Sunburst chart type:

grocery sunburst

After Looker 7.0

Marketplace

Looker has added a new marketplace feature with Looker 7.0

Looker Marketplace

This feature lets you easily enable even more custom visualizations. Those discussed above are now available through the marketplace icon. You are still able to customize them and add them from the Admin panel.

The marketplace offers interesting new viz types, like the Calendar Heatmap, the Spider, the Gauge, or even the Image Carousel! The Calendar Heatmap is a nice way to display the number of events in a calendar style.

Heatmap Calendar

The Spider chart, on the other hand, can help to visually compare different values in different zones as in this example:

spider chart

The last one is a fancy new feature that can be helpful if you need a slideshow of images.

image carousel

Many other cool visualizations are available, you should take a Look! These new plug-ins show us that Looker is continuously investing in helping analysts and business users better and more easily visualize data, which is key to generating taking the right actions!

More on the topic

Everything we know, we are happy to share. Head to the blog to see how we leverage the tech.

Apache Airflow start_date and execution_date explained
Airflow start_date and execution_date Explained
Despite Airflow’s popularity in data engineering, the start_date and execution_date concepts remain confusing among many new developers today. This article aims to demystify them. Basic...
June 15, 2022
Breaking Some Myths about the Use of Dual-Track Agile
Bringing both flexibility and transparency, the Dual-Track Agile methodology is increasingly popular. With a growing number of teams that decide to try it out, it...
June 10, 2022
Creating a PostgreSQL to BigQuery Sync Pipeline Using Debezium and Kafka
Many companies today use different database technologies for their application and their data platform. This creates the challenge of enabling analytics on application data without...
June 1, 2022
How to Apply Dual-Track Agile in Practice
This article is a part of a series on the Dual-Track model. Here, I am going to share with you 5 rules on how to...
May 17, 2022
Challenges of Using Dual-Track Agile and How to Handle Them
Welcome to Part II of the Infinite Lambda’s blog series on Dual-Track Agile. You might want to check Part I that explains what this model...
April 15, 2022
Sustainability: the Last Frontier in Business Intelligence
The power of the modern data stack in generating actionable insights out of disparate data is well documented. It’s time to apply this to sustainability....
April 1, 2022

Everything we know, we are happy to share. Head to the blog to see how we leverage the tech.

Optimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.