Google BigQuery / SQL & Data Studio

BigQuery panel for queries

Using SQL is not as hard as it seems when you know English. Want to limit results? Use limit. Want to make a filter for results? User where column name = something.

Would like to use distinct value? You guessed it – it is distinct :)

With BigQuery you can process gigabytes of data. With Google Analytics 4, and big e-commerce site you will process such amounts.

Obviously it is not the queries itself which have a value. It is the decisions which you can make based on the data

Next step is to make it easy for each user to get the data by him/her self without asking data analyst where is it. For small/mid companies DataStudio + Google Sheets + Google Slides is enough. It helps a lot to show data in proper form.

BigQuery panel for queries

Using SQL is not as hard as it seems when you know English. Want to limit results? Use limit. Want to make a filter for results? User where column name = something.

Would like to use distinct value? You guessed it – it is distinct :)

With BigQuery you can process gigabytes of data. With Google Analytics 4, and big e-commerce site you will process such amounts.

Obviously it is not the queries itself which have a value. It is the decisions which you can make based on the data

Next step is to make it easy for each user to get the data by him/her self without asking data analyst where is it. For small/mid companies DataStudio + Google Sheets + Google Slides is enough. It helps a lot to show data in proper form.