This tutorial describing how to create a time frame control has been inspired by a question from the community. This control is strongly associated to the financial world for stock prices charts. More generally, when building a dashboard or an…
Read moreThe story begins with the need to graphically represent metric variations and the related expected range values in Looker Studio. A device for anomaly detection, displaying it to give context and identify quickly routine variations Vs real anomalies (for the…
Read moreLast week, the Looker Studio team has released a new chart type: The funnel chart! All the users community on the social networks was excited to discover this new welcomed feature, sharing examples. We were waiting for it for a…
Read moreThe Looker Studio calculated field below cleans a text field removing any HTML tag.
Read moreExcel-ling Now, you are thinking that July is the month of feature previews for Looker Studio. It is not wrong, but what is definitely true: The acceleration of the cadence of releases by Looker BI and Looker Studio teams with…
Read moreYesterday, we saw with a real life use case how the Formula Assistant will help us to build calculated fields faster with a minimum of knowledge about the Looker Studio functions library. Today let’s continue with another feature preview. Don’t…
Read moreGemini is coming inside Looker Studio Pro and Looker BI. Few months ago, a restricted preview program gave a chance to some power users to start to test very promising features. And the program is progressively expanded to more and…
Read moreArchived data from Google Analytics Universal…don’t dig to deeply As any Google Analytics practitioner, you made some archives of GA Universal data and are ready for the full sunset planed in 2 weeks. But you know that some doors need…
Read moreAs you probably already know, a new chart type has been released last week by the Looker Studio team: Timeline chart! It is an efficient feature to include any planning inside your reports through Gantt chart.And so, it helps to…
Read moreI like the graphical charter of Piwik Pro and had an idea discovering the new video series “25 years of digital analytics with Brian Clifton“:Let’s create an effect of perspective to compare dynamically 2 months of data from the demo…
Read moreTwo years ago, I started working on this interactive date range comparison solution within Data Studio, to fill a gap in the tool. It required using BigQuery as a data source and the context at the time was not like…
Read moreWeighted sort was a nice feature from Google Universal Analytics table charts. Adjusting the sorting to inject the importance of the quantity represented by each row helped a lot, applied to rates. If you sort by descending order a list…
Read more25 days before Superweek Analytics Summit 2024! The unique international conference of digital analytics. Just for fun, I built an interactive report with geo data of the announced speakers with 2 recent Looker Studio features:– Connection map– Transposed table, helping…
Read moreToday, 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 moreFew months ago, I was wondering how Midjourney could ease the creation of dynamic infographics or illustrate dashboards with very few graphic skills, just basic knowledge of how using Photoshop. I started recently an experiment using Midjourney for the 1st…
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 moreFor infographics with dynamic data, and almost just for fun, let’s change the position of a picture following the interactions of the reader of Looker Studio report! Let’s use the universe of Tron movie to do so! To build this…
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 moreLe’s have fun with Looker Studio, using Using charts as a drawing engine! Dragon Ball was a cartoon of my childhood. Here a drawing with:
Read more