Tag
Data blending in Looker Studio is a feature that enables data designers to combine data from multiple sources into a single data set. This is particularly valuable when analyzing data that spans different platforms, such as combining analytics from your favorite suite with sales metrics CRM system as example. By blending data, analysts can gain a more comprehensive view of their business performance.
Data blending is also a way to filter subset of data from the same data source to open new possibilities of preparation and calculations
Last 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 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 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 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 moreFunnel report type inside Looker Studio, a recurring need for a popular visualization. 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…
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 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 moreLast week, we enjoyed discovering the new possibilities of data manipulation inside Looker Studio (formerly known as Google Data Studio), thanks to the new data blending features. Now, it is time for a first tip to leverage them and built…
Read moreThe Looker Studio Google Data Studio team has just released a highly anticipated new feature paving the way for a lot of amazing possibilities about data manipulation & preparation: A new data blending engine with join types (inner, outer, right…
Read moreBuilding a statistics annual report is a nice exercise for challenging the way to display metric values comparison over a granularity of time inside our data visualisation tool. We could decide to use the default available feature of the tool,…
Read moreNeed to access to selected date range and related time repository Most of data sources and related APIs provide rows of dated data only if the requested data are available (in other words, when the combination of all requested fields…
Read moreLet’s describe step by step, inside Looker Studio (formerly known as Google Data Studio) – how to split delimiter-separated values – as example with comma – from a text dimension to get the same related metrics, drilled down by real…
Read moreData label is an optimized solution to avoid the use of chart legend, putting directly the right and short information inside your chart. But sometimes we face constraints and limitation for customization inside Looker Studio (formerly known as Google Data…
Read moreThe purpose of this article is not to debate about the right cases & visualisation opportunities to use controversial pie charts or donut charts. This post is just made to address a simple need 🙂 Through this tip, we will…
Read moreThe preparation & the deployment of a URLs redirection plan require method, know-how, a lot of rigor of execution, involving various digital team members and expertises (from traffic management to IT services). Because of its high weight of impacts, and…
Read moreNeed a freelance analytics expert or a Google Data Studio consultant?
