How to visualise the sequential impact of positive and negative values with the Waterfall Chart in Looker Studio

Waterfall charts in Looker Studio are excellent for understanding the sequential impact of positive and negative values relative to a baseline. We will use the Superstore Products dataset to see how net revenue has evolved over the years for the ecommerce in our data. Visit the post on how to add charts to your report … Read more

How to represent data hierarchy with the Treemap chart in Looker Studio

The treemap chart in Looker Studio is a mosaic with colored blocks inside. These are ideal for visualising data hierarchies, easily revealing patterns in large datasets. Personally, I love using this chart to visually represent hierarchy within a category. In this post, we’ll continue using the Spotify dataset and use it to display the songs … Read more

The Sankey diagram in Looker Studio

The Sankey diagram shows how a dimension is distributed and flows, tracing multiple paths indicating where the data is moving. The thickness of these links represents the weight of the relationship, based on the selected metric. In this post, we’ll look at an example using the Sankey diagram and explore its configuration options. Remember, visit … Read more

The Scatter Plot: How to analyse the relationship between two variables in Looker Studio

The scatter plot is ideal for analysing the relationship between two variables. In this post, we’ll explore how to set up this visualisation and what configuration options it offers. Remember, visit the post on how to add charts to your report in Looker Studio, if you need a refresher. 1. Example In this example, we’ll … Read more

Geo maps in Looker Studio

This is the first of several posts where we’ll explore one of the most visually appealing types of visualisation you can create in Looker Studio: maps. For the examples, I’ll use the H&M store data. 1, Types of Maps in Looker Studio There are two types of maps available: Geo Maps These were the first … Read more

Heatmap in Looker Studio

Continuing the series on maps in Looker Studio, this post will focus on another map type offered by Google Maps: the heatmap. As in previous posts about maps, I’ll continue using the H&M store data. Visit the post on how to add charts to your report in Looker Studio, if you need a refresher. 1. … Read more

Filled map in Looker Studio

Continuing with the posts on maps in Looker Studio, let’s look at another one offered by Google Maps: the filled map. For the examples, I’ll keep using the H&M store data. Visit the post on how to add charts to your report in Looker Studio, if you need a refresher. 1. The Filled Map A … Read more

Bubbles map in Looker Studio

Google Maps brought Looker Studio’s map visualisations to a more advanced level. There are several types available, and in this post, we’ll review the bubble map. As we saw in the first post about maps, Looker Studio initially only offered the Geo Map. For the examples, I’ll keep using the H&M store data. Visit the … Read more

Chart options that provide more user interaction power in Looker Studio

There are several chart options that empower user interaction in Looker Studio. In this post, I will explain some of them. For the examples I will continue using the Top Movies 2019 dataset for the examples. 1. Optional Metrics When creating visualisations, you may have noticed that within Set-up there is an option to add … Read more

The combo chart in Looker Studio

This is one of my favorite visualisations when I want to show two distinct metrics for the same category. To create a combo chart, you can start with a bar or column chart and make modifications in the Style settings, but choosing the combo chart from the beginning makes it much quicker. Remember, visit the … Read more