Today, I propose you to build a tool for BigQuery. Google Cloud BigQuery is the best friend of Looker Studio. We will not state today all the benefits to consider BigQuery, at least, as the preparation layer of Looker Studio…
Read moreLast year, I wrote an article describing how to build a simple funnel chart with a single table chart. A way to demonstrate in Looker Studio (ex Google Data Studio…should I continue to specify it) that we don’t need 20…
Read moreSparkline is a mini line chart without axis and labels to get more context about the trend of a displayed metric for a specific period or variation series. It is often used in data visualization through tables displaying metric trends…
Read moreAgainst all odds, let’s include in our Google Analytics 4 report: Google Analytics 4 and Looker Studio: Introduction and technical context Looker Studio (formerly known as Google Data Studio) offers a native connector to load data from Google Analytics 4….
Read moreLet’s go back to the basic to create a simple metric selector. This allows to change the measure displayed inside a set of Looker Studio charts (formerly known as Google Data Studio) as report reader. Taking of avantage of a…
Read moreFew years ago, I wrote a tutorial about how we can include annotations inside Looker Studio line charts. My custom solution was nice for instant events and correlation analysis. This time, we will take care about periods and events occurring…
Read moreKeeping charts as simple as possible is very challenging. For some cases, a single interactive feature can offer a first level of data exploration or calculation without overloading the default state of your Looker Studio (formerly Data Studio) chart. In…
Read moreI always prefer preparing data outside Data Studio and I always prefer using builtin chart types when it is possible. But sometimes, we need something fast, more or less disposable, addressing temporarily visualization needs, to get a first level of…
Read moreWe create funnel reports for a while inside Google Data Studio. There are a lot of solutions, templates, articles describing how to do. Most of these resources are nice and address the visualisation need. Technically speaking, they are based on…
Read moreFor a lot of cases, legends are not the best visualization solution for line chart (and similar trends chart types). Often, the chart and related data are simple BUT complicated to read because of it requires back and forth to…
Read moreThe Looker Studio (ex Google Data Studio) calculated field below returns the older date from a date dimension. The min date in other words.
Read moreThe Looker Studio (ex Google Data Studio) calculated field below returns the most recent date from a date dimension. The max date in other words.
Read moreWaterfall charts are nice & efficient to visualize cumulative values of a metric and the related participation weight of each item, towards the final value. In digital analytics fields, it can address insights about frictions on funnels, form filling, web…
Read moreThe Looker Studio calculated field below returns the file name with the related extension from a field providing an absolute URL.
Read moreFew months ago, I’ve discovered a nice Google hidden URL thanks to a tweet from Ben Collins about a Google Sheets tip. If you use Sheets, I strongly recommend to follow Ben and enjoy what he shares every day. Thank…
Read moreNeed a freelance analytics expert?
