Check out all the tutorials of the blog here! There are various of them about Looker Studio and Google Sheets. Formulas, report creation, tricks & tips – everything is in this section.
When you start working with Looker Studio you may ask yourself “How do I connect a Google Sheets to Looker Studio?” I am here to explain! Keep up with the video tutorial to get a better understanding: Google Sheets tips …
How to connect and use Looker Studio with Google Sheets 2023 Read more »
Did you know that you can do conditional formatting in Google Sheets based on another cell value? Keep reading this article to get to know it! Also, you may find interesting my article about the basics of conditional formatting. But …
Conditional formatting in Google Sheets based on another cell value in 2023 Read more »
Let’s talk about one useful function in Google Sheets – conditional formatting. I will show you how to set it up using a pivot table (read the article about creating a pivot table here). Check out the video tutorial here: …
Conditional formatting in Google Sheets for beginners Read more »
It is impossible to imagine data analysts working without pivot charts. If you’re not familiar with them, here I am with my new article – Pivot tables in Google Sheets tutorial for beginners. I would like to tell you about …
Pivot charts in Google Sheets tutorial for beginners Read more »
This week I had an interesting case while working in Looker Studio.I have Google Analytics 4 and one of the dimensions is Event Name in format of small letters and underscore. However I need to show the events names in …
Errors in Google Sheets… It happens every time! Breaks the charts in Looker Studio and is simply an eyesore while working with data! Read the article about Google Sheets errors handling! In this article I am going to teach you …
Mastering data in Google Sheets: ERRORS handling with these formula tricks Read more »
Not to forget to send the report to your client among a bunch of other tasks to do, you can use the Schedule email delivery feature in Looker Studio. Keep reading the article to know some tricks about it or …
Schedule email delivery feature in Looker Studio Read more »
May 2023 was a prosperous month of innovations in Looker Studio hence now we can see many new features in the tool. One of them is a buttons feature in Looker Studio. Let’s see how can we use it but …
Welcome back to the second part of the tutorial of creating a cohort analysis in Google Sheets. In the previous chapter we’ve seen what kind of data we need to input and started doing the calculations. I’ve filmed a video …
How to create a cohort analysis in Google Sheets – part 2 Read more »
Cohort analysis is a type of analysis when we split the users by groups and observe the behavior of these groups based on certain characteristics. In this article we will start doing all the settings and calculations for cohort analysis …
How to create cohort analysis in Google Sheets? Part 1 Read more »
0 items in the cart (0 €)